After installing the MySQL server and setting it all up as per this blog post: https://mrfloris.com/article/3288/ubuntu-18-how-to-add-basic-firewall-with-ufw/, it’s time to add a database, and a user to this database.
Assuming you’ve followed the previous blog post, connect to the mysql server with the mysql root user as such:
mysql -u root -p
It will look like this:
floris@server:~# mysql -u root -p Enter password: Welcome to the MySQL monitor.
Let’s first add a database that our user can use.
CREATE DATABASE database_name;
You can see it in the list:
SHOW DATABASES;
Note: if you ever need to delete a database, it’s: DROP DATABASE IF EXISTS database😉
Okay, that’s all. Let’s add a user, now you COULD use this, and go through it all step by step, but I will show you how to add a user using the grant command. Since it will add the user anyway. So instead of this:
CREATE USER username IDENTIFIED BY 'password';
You can use this instead:
GRANT ALL PRIVILEGES ON *.* TO 'username'@'localhost' IDENTIFIED BY 'password';
And that’s it. Next we want to flush and exit:
FLUSH PRIVILEGES;
and
exit