How can I create a database and an user to work together in MySQL. Well, it’s quit easy, theres the few MySQL lines you need to use to solve your problem.
Create the database
Create an user
Verify user
Grant privileges to user
Verify user GRANTS
1 | SHOW GRANTS FOR my_user@localhost; |