Jump to content
learning php mysql, chapter 9, what user?
Asked by Torkuda
Posted Dec 22 2012 10:37 PM
Answered by iennae
Posted Dec 26 2012 06:13 PM
In chapter 8 when you did "create database publications" and "GRANT ALL ON publications.* TO 'jim'@'localhost' IDENTIFIED BY 'mypasswd';" (replacing jim with the name of your choosing), did you keep information about what username and password you chose? That would be a username and password combo that you could use.
If you didn't set a password to your database it maybe that root with no password works as well.
mysqldump -u root publications > publications.sql
may work if you do not have root configured with a password.
If you ran the grant command exactly as it is in the book then your username password pair would be jim and mypasswd.