If suddenly the server is not active, start it with the command -
sudo systemctl start mysql
Login to mysql root
In order for you to be able to add a user, you will need to enter the following commands:
Sudo mysql
This command introduces c level executive list you to the server database itself
home
Creating a database
Create database "namebase"
DBcreate
As you can see the database has been created
Adding Users
After you have logged into the server database on behalf of the Root user, you will need to enter the following command to create a user
CREATE USER 'USERNAME'@'host’ IDENTIFIED BY 'password’ ;