Create a database with mysql client

To follow these instructions, you must know the root password for the database. This is likely different from the root password of the server.

1. Start mysql client: mysql -u root -p
2. Create database: CREATE DATABASE mydatabasename;
3. Create user: CREATE USER myuser IDENTIFIED BY 'mypassword';
4. Give user permissions to the database: GRANT ALL ON mydatabasename.* to myuser;