From: Michael Stassen [mailto:[EMAIL PROTECTED]
Subj: Re: Access denied for root user
MueR wrote:
Hello,
I've recently had my HD crash, and have reinstalled everything.
Everything seems to work fine, apart from one thing. My MySQL server
has decided to randomly set a root password
MueR wrote:
From: Michael Stassen [mailto:[EMAIL PROTECTED]
Subj: Re: Access denied for root user
MueR wrote:
Hello,
I've recently had my HD crash, and have reinstalled everything.
Everything seems to work fine, apart from one thing. My MySQL server
has decided to randomly set a root password
Hello,
I've recently had my HD crash, and have reinstalled everything.
Everything
seems to work fine, apart from one thing. My MySQL server has decided to
randomly set a root password.
I have tried logging in with no password, tried it with my old password.
Tried
restarting the server with
MueR wrote:
Hello,
I've recently had my HD crash, and have reinstalled everything.
Everything seems to work fine, apart from one thing. My MySQL server
has decided to randomly set a root password.
No, it didn't. I know it seems that way, but I'm sure that's not what happened.
I have tried
of MySQLFront or
PHPMyAdmin.(4.3) so I assumed maybe the MySQL had becomedamaged -
so I uninstalled it and reloaded it (leaving the data files
untouched).
Now I cannot get in at all and it simply tells me that error
1045 - access denied for user root 127.0.01 which leaves me
stumped.
Meanwhile
out
Seems, you have no running MySQL server on host 'hostname'.
shellmysqladmin -u root password 'new-password'
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: NO)'
But you have already set up a password for 'root'.
Try
: 'Access denied for user: 'root@localhost' (Using password: NO)'
I can only use mysql with mysql user:
shellmysql -u mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 9 to server version: 3.23.54
Type 'help;' or '\h' for help. Type '\c' to clear the buffer
: 'Access denied for user: 'root@localhost' (Using password: NO)'
I can only use mysql with mysql user:
shellmysql -u mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 9 to server version: 3.23.54
Type 'help;' or '\h' for help. Type '\c' to clear
Description:
I just now installed MySQL latest version and I cannot acced the database, even though
the MySQLd daemon is running.
How-To-Repeat:
Fix:
Submitter-Id: [EMAIL PROTECTED]
Originator:root
Organization:
MySQL support: [none | licence | email support |