- create user ‘user’@’localhost’ identified by ‘password’;
- create database appdb;
- grant all privileges on appdb.* to ‘user’@’localhost’;
- flush privileges;
And to get rid of of your prior tries just in case they exist:
- drop user;
- drop database;
Use the first set of commands and see if that clears up your issues. Use the drop commands to clear out earlier attempts that didn’t work.
Let me know how it went and whether you need further help.
Ron
PS: Remember to update ‘user’, ‘localhost’ and ‘password’ to whatever is correct for your setup.