I think I might have screwed up my DB real bad.
I had no problem installing my MySQL DB.
I then installed PHPmyadmin and everything was super...
But after a while, I got tired of seing the message in red warning me that I had to set up a password for the root@localhost user.
When I installed MySQL for the first time, I had this welcome text in the terminal (MAC OS 10.2.3) :
and I entered the first line, but, my mistake might have been to actually write my new password between '' and I replaced : 'new_password' with the password I wanted.PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
This is done with:
./bin/mysqladmin -u root password 'new-password'
./bin/mysqladmin -u root -h john-does-Computer.local. password 'new-password'
Then I tried the other line and I got access denied or permission denied error since then...
I spent all day looking for answers in this forum (it seems that many people have had this problem) but I found no real solution. Then I spent a lot of time in the MySQL manual... No answer either. I tried many commands and I always got permission denied errors.
PHPmyadmin returned this error:
From this point, I tried to reinstall MySQL, apparently it worked. but It didn't overwrite the corrupted file... Since My DB was quite empty, I don't mind installing it again, but How can I make sure that it erases everything...Error
MySQL said:
Access denied for user: 'root@localhost' (Using password: YES)
Sorry if this message is long... But I really tried many things before I deceided to post. Your help is appreciated
Thanks