MySQL Access Denied
Posted on 2009-12-27
Hi Experts ..
I was using mysql normally without any problem until today morning, I am trying to connect but I am getting the following:
[root@srv01 mysql]# mysql -u root -p -h localhost
Enter password: *********
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
It seems I have problem in permissions, I tried to reset the root password, but I am getting the following error:
ERROR 1142 (42000) at line 1: UPDATE command denied to user ''@'localhost' for table 'user'
any idea what should I do?