Link to home
Start Free TrialLog in
Avatar of piratepatrol
piratepatrolFlag for United States of America

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
SOLUTION
Avatar of wesly_chen
wesly_chen
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of piratepatrol

ASKER

Hey guys,

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