access remote mysql db with mysql-administrator command

uppalagayatri · 05-13-2011, 01:20 AM

Hi

I have install mysql on my fedora12. My different mysql server is located in us. I want to check health status and hits per seconds everything. Is it possible with mysql-administrator command.

now a these days i am connect through ssh and excuting below command
#mytop mysql -u root -p <passwd>

In my mysql db i have added the userip & passwd (allowed the privileages for that ip)

If i use mysql-administrator
i am getting below error

##########
MySQL Error Nr. 2003
Can't connect to MySQL server on '66.98.152.64' (111)
###########

please guide how to fix the problem

Thanks in advanced...............

EricTRA · 05-13-2011, 01:35 AM

Hello,

First thing you'd need to check is if MySQL server is configured to accept connections from the outside world and not only from localhost. Next I'd check any firewalls (iptables, hardware, ...) and routers (to see if ports are being directed correctly) between your computer and the remote server to see if they allow connections on port 3306, which is the default port for MySQL. If all that checks out correctly, then review the user settings in MySQL.

Kind regards,

Eric

prayag_pjs · 05-13-2011, 01:53 AM

Hi,

On 66.98.152.64 mysql server(if its a mysql server) :

vim /etc/my.cnf

Code:

[mysqld]
bind-address = 66.98.152.64

Grant access to a new database

If you want to add a new database called mydb for user db and remote IP 202.56.240.50 then you need to type the following
commands
mysql> prompt:

Code:

mysql> CREATE DATABASE mydb;
mysql> GRANT ALL ON mydb.* TO db@'202.56.240.50' IDENTIFIED BY 'urpassword';

Restart the mysql server, enter:

Code:

# /etc/init.d/mysql restart

Now you can connect using :

Code:

mysql -u db –h  66.98.152.64 –p

You can Monitor number of active connections to MySQL using Nagios using this link:

uppalagayatri · 05-13-2011, 02:13 AM

Quote:

Originally Posted by EricTRA

Hello,

First thing you'd need to check is if MySQL server is configured to accept connections from the outside world and not only from localhost. Next I'd check any firewalls (iptables, hardware, ...) and routers (to see if ports are being directed correctly) between your computer and the remote server to see if they allow connections on port 3306, which is the default port for MySQL. If all that checks out correctly, then review the user settings in MySQL.

Kind regards,

Eric

Thanks for giving reply but i mention in my my.cnf file
bind-address=0.0.0.0

in iptables also it is accepting 3306(my default mysqlport) port number.
#iptables -A INPUT -p tcp -s <MY IP> --dport 3306 -j ACCEPT
In my remote system

EricTRA · 05-13-2011, 02:22 AM

Hello,

You've posted iptables rule for SSH not for MySQL, check if it's there. Also did you check your router(s) for port redirection and physical firewalls if any are used?

Kind regards,

Eric