1

I am using Amazon Cloud to deploy my web services. However, this requires a MySQL instance and I already installed it. In order to allow remote connectivity to MySQL database, I followed the below sequence as elaborated in MySQL documentation and even in the below thread.

Edit my.cnf file to change the following.

[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
language        = /usr/share/mysql/English
bind-address    = <server ip OR 0.0.0.0>

The same solutions discussed in detail, following posts.
Remote Connections Mysql Ubuntu

http://www.cyberciti.biz/tips/how-do-i-enable-remote-access-to-mysql-database-server.html

However, as soon as I edited the my.cnf file as mentioned, the MySQL server failed to restart. I tried my best to recover this, it's failing instead.

Could anyone help me to identify and resolve the issue, would be a great help.

Community
  • 1
  • 1
Aviro
  • 2,125
  • 22
  • 28

1 Answers1

2

Verify that the MySQL server isn't running.

Try setting the bind-address to 0.0.0.0

bind-address = 0.0.0.0

Verify that the files are deleted

/var/run/mysqld/mysqld.sock
/var/run/mysqld/mysqld.pid
Shimon Tolts
  • 1,602
  • 14
  • 15
  • 1
    Thanks, this worked. I think the issue occurred when I tried to edit the conf file while the service is running. – Aviro Feb 21 '15 at 17:27