Bug #59960 missing MySQL super user privileges for root
Submitted: 5 Feb 2011 4:33 Modified: 6 Mar 2011 14:52
Reporter: aswathi p Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server Severity:S1 (Critical)
Version:MySQL 5.1 OS:Linux
Assigned to: CPU Architecture:Any

[5 Feb 2011 4:33] aswathi p
Description:
I have a Linux Ubuntu server with installs MySQL 5.1. I access this server from a remote Windows machine through SSH. I want to access its database using PremiumSoft Navicat software. 

I tried to access it using the 'root' user. But it gave an error "2003 - can't connect to MySQL server on 192.168.0.89".

To correct this error following steps where done
1.  bind-address = 0.0.0.0 of /etc/mysql/my.cnf
2.  restart mysql
3.  grant all privileges on *.* to 'root'@'192.168.0.89';
4.  flush privileges;

After this i donot what happened, I logged in as 'root' user and
'show databases;' command displays only 'information_schema'.

if i give 'use mysql;' it shows "ERROR 1044 (42000): Access denied for user 'root'@'localhost' to database 'mysql' "

It seems that there is some problem in user privileges. Then i reinstalled MySQL and tried with 'root' user and repeated the 'show databases'. But the problem still exists.

Now what should i do? Please help!

How to repeat:
actually i donot have an exact idea of what caused this error.
[6 Feb 2011 14:52] Valeriy Kravchuk
Please, login as root as you did before and send the output of:

select current_user();

select user, host from mysql.user;
[7 Mar 2011 0:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".