Fwd: Access denied for user 'root'@'localhost' in mysql

2009-06-03 Thread Bernard Fay
False alarm!!! I forgot to remove the skip-grant-tables and restart mysql. When I try to login with mysql -u "r...@beryllium -p", I receive the following: ERROR 1045 (28000): Access denied for user 'r...@beryllium'@'localhost' (using password: YES) I guess I should add r...@localhost in mysql.us

Fwd: Access denied for user 'root'@'localhost' in mysql

2009-06-03 Thread Bernard Fay
` As fas as I understand it, there is no need to say "update mysql.user set ..." because we have to say "use mysql" first. So the update command should know the table user is part of mysql. Right? I really believe the problem comes from the fact there is know r...@localhost in mysql.user. I ha

Fwd: Access denied for user 'root'@'localhost' in mysql

2009-06-03 Thread Bernard Fay
-- Forwarded message -- From: Bernard Fay Date: Wed, Jun 3, 2009 at 5:00 PM Subject: Re: Access denied for user 'root'@'localhost' in mysql To: paul.le...@quadensemble.co.uk Thanks for your reply, Paul. Yes, I tried without the -p switch and it didn't work. Also, I just found t