Access Denied for User-Upgrading to Mysql5.5

thoufiq · 05-03-2011, 10:35 AM

Hello All,
When am trying to upgrade from mysql5.1 to mysql5.5, i got many errors and at-last i upgraded to mysql5.5. It is going inside the mysql root and have permissions to create new databases, but still i am facing one problem is when giving command mysql_upgrade, i got error like this

root@dhcppc4:~# mysql_upgrade
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/var/run/mysqld/mysqld.sock'
Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/var/run/mysqld/mysqld.sock'
Running 'mysql_fix_privilage_tables'...
ERROR 1044 (42000): Access denied for user ''@' localhost to database 'mysql'
FATAL ERROR: Upgrade failed

Can anyone suggest me to resolve this error.

Thanks in advance.

nowonmai · 05-03-2011, 11:07 AM

You need to pass a user to mysql_upgrade by using the -u option. This user needs to have full access to the databases on this server.