Help
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?
|
|
|||
|
Welcome
O'Reilly Answers is a community site for sharing knowledge, asking questions, and providing answers that brings together our customers, authors, editors, conference speakers, and Foo (Friends of O'Reilly). More »
learning php mysql, chapter 9, what user?1 Reply
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. |
|||
© 2013, O’Reilly Media, Inc. (707) 827-7019 (800) 889-8969 All trademarks and registered trademarks appearing on oreilly.com are the property of their respective owners. |
