Unable to connect to remote mysql server in Ubuntu

Bhanu999 · 11-30-2014, 01:30 AM

Hi everyone.
I have a problem in connecting to mysql database on the remote server.
I've issued the following command to connect to the remote server

mysql -h xyz.com(remote hostname) -u username -ppassword

and I'm getting the following error

ERROR 2003 (HY000): Can't connect to MySQL server on 'xyz.com' (111)

here is my my.cnf file

Code:

[client]
port            = 3306
socket          = /var/run/mysqld/mysqld.sock
[mysqld_safe]
socket          = /var/run/mysqld/mysqld.sock
nice            = 0

[mysqld]
user            = mysql
pid-file        = /var/run/mysqld/mysqld.pid
socket          = /var/run/mysqld/mysqld.sock
port            = 3306
basedir         = /usr
datadir         = /var/lib/mysql
tmpdir          = /tmp
lc-messages-dir = /usr/share/mysql


#skip-external-locking
#bind-address           = 127.0.0.1


key_buffer              = 16M
max_allowed_packet      = 16M
thread_stack            = 192K
thread_cache_size       = 8
myisam-recover         = BACKUP
query_cache_limit       = 1M
query_cache_size        = 16M
log_error = /var/log/mysql/error.log
expire_logs_days        = 10
max_binlog_size         = 100M

[mysqldump]
quick
quote-names
max_allowed_packet      = 16M

[mysql]
[isamchk]
key_buffer              = 16M
!includedir /etc/mysql/conf.d/

please help me and thanks in advance.

OS: xubuntu-14.04

Habitual · 11-30-2014, 08:12 AM

Did you grant this remote access in the database on the remote server?
See http://dev.mysql.com/doc/refman/5.1/en/grant.html

Bhanu999 · 12-10-2014, 07:37 PM

Ya I have granted remote access in the database on the remote server, but i am not able to connect to it.