piratepatrol
asked on
I Can't Access MySQL Anymore - Please Help
Hi friends,
I fooled around with the user table in the mysql database. I ran the following command just for kicks:
update user set password='boo';
After I restarting my computer, I can no longer access mysql. The error message is
ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)
FYI, before I fooled around with the user table, I was able to connect to MySQL via PHP with the username "root" and no password.
Please kindly help me resolve this issue. I don't know where to start. I'm a Linux newbie. You folks are so awesome.
Jazon from Jacksonville, FL
I fooled around with the user table in the mysql database. I ran the following command just for kicks:
update user set password='boo';
After I restarting my computer, I can no longer access mysql. The error message is
ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)
FYI, before I fooled around with the user table, I was able to connect to MySQL via PHP with the username "root" and no password.
Please kindly help me resolve this issue. I don't know where to start. I'm a Linux newbie. You folks are so awesome.
Jazon from Jacksonville, FL
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I just went ahead and formatted the harddrive and installed Fedora 2 again. Thanks for your help anyway. I split the point between you guys.
Thanks a bunch,
Jazon from Jacksonville, FL