Error Configuring MySQL for Remote Access
I need to configure MySQL to allow remote access. I understand I need to
configure the "my.cnf" file in order to do this. This is the entire
contents of /etc/my.cnf:
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
However, when I add bind-address=134.141.2.72 (my server's IP) under the
symbolic-links=0 line, I am no longer able to start mysqld.
When I run tail /var/log/mysqld.log I return the following error:
130806 12:58:34 InnoDB: Started; log sequence number 0 44253
130806 12:58:34 [ERROR] Can't start server: Bind on TCP/IP port: Cannot
assign requested address
130806 12:58:34 [ERROR] Do you already have another mysqld server running
on port: 3306 ?
130806 12:58:34 [ERROR] Aborting
130806 12:58:34 InnoDB: Starting shutdown...
130806 12:58:39 InnoDB: Shutdown completed; log sequence number 0 44253
130806 12:58:39 [Note] /usr/libexec/mysqld: Shutdown complete
130806 12:58:39 mysqld_safe mysqld from pid file
/var/run/mysqld/mysqld.pid ended
I am brand new to MySQL, so I'm sure I'm making some terribly obvious
mistake.. Thanks!
No comments:
Post a Comment