Jump to content

learning php mysql, chapter 9, what user?

Torkuda's Photo
Posted Dec 22 2012 10:37 PM
1769 Views

In Learning PHP MYSQL Javascript and CSS 2nd edition, chapter 9, on page 224, the author wants you to perform a backup of the publications database by performing a mysqldump command. The problem is the program requires a user and password combination. The author says to use the user that was set up when you installed Zend. The only problem with that is, the installation of Zend involved creating a password, but not a user. When was I supposed to create a user and how might I find out what that user was?

Tags:
0 Subscribe


1 Reply

0
  iennae's Photo
Posted Dec 26 2012 06:13 PM

Hi,

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.

Thus

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.