I have a Linux Ubuntu server with 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 know 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!