mysql -HELP!!!
- Started
- Last post
- 27 Responses
- stupidresponse0
did you set a root password when you installed mysql? you can do this on the command line with:
/usr/local/mysql/bin/mysqladmin -u root password new_pwd
replacing new_pwd with your password
- Dancer0
This is where the problem started. Before I could get access to PHPMyadmin but when I tried to set a password in myadmin I then could not get in again.
So, to create a new password I just type it in replacement of new_pwd?
- Dancer0
[macintosh:/usr/local/mysql] alistair% /usr/local/mysql/bin/mysqladmin -u root password l0calhost
/usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
[macintosh:/usr/local/mysql] alistair%where the new password would of been l0calhosrt
- stupidresponse0
try:
/usr/local/mysql/bin/mysqladmin -u root -p statusand just hit enter when it asks for the password
- Dancer0
[macintosh:/usr/local/mysql] alistair% /usr/local/mysql/bin/mysqladmin -u root -p status
Enter password:
/usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
[macintosh:/usr/local/mysql] alistair%
- stupidresponse0
hmm. well, the only thing i can think is that root has a password, you just don't know what it is! you can try to reset it by following these instructions:
http://dev.mysql.com/doc/refman/…once you have the (correct) root password, you need to enter it in your config.inc.php to get phpmyadmin to work.
and with that i must be leaving, sorry! good luck!
- Dancer0
Hey Stupid... thanks so much for your patience and time, really appreciate it.