Quote:
|
Originally Posted by jay3ld
What is this error? and how to fix
|
http://www.google.com/search?client...=UTF-8&oe=UTF-8
Quote:
|
Originally Posted by jay3ld
i was in the phpmyadmin and...
i was changing root password so that stupid error would stop bothering me and now i cant log in or get it to change the set up files right to log in.  stupidy!!!!How do i either set up or get back no password? |
No need to panic. MySQL has a walkthrough on this. Basically, here's what you do:
1. Stop MySQL (you can do this from the prefpane).
2. Create a text file in your home folder called "fixmysql" and put the following text inside:
code:
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('MyNewPassword');
where MyNewPassword is, of course, your new password.
3. In the Terminal, type
MySQL will restart with the new root password and everything should be gold.code:
/usr/local/mysql/bin/mysqld_safe --init-file=~/fixmysql