Question
After updating bind-address in /etc/msql/my.cnf file MySQL stops working
Operating System & Droplet information
Ubuntu 14.04.3 x64
1GB Ram
30GB SSD Disk
Steps to reproduce the error
$ sudo apt-get update
$ sudo apt-get install mysql-server
$ sudo mysql_install_db
$ sudo mysql_secure_installation
After updating all packages and downloading/configuring required packages, I tried the following:
$ sudo nano /etc/mysql/my.cnf
Find the bind-address under [mysqld].
I changed the bind-address* to my second Droplet’s **Private Network Address. After that, I told MySQL to restart with the following command: sudo service mysql restart
and I got the following reply:
mysql stop/waiting
start: Job failed to start
It does work fine when I edit the file back to it’s original settings (listening to 127.0.0.1
instead of a Public or Private Network Address).
I’ve also tried to clear log files, purge the system and re-install everything again (on three or four different Droplets). So far without any luck.
What am I doing wrong? Is this a known issue, maybe?
Articles that I’ve (tried) to follow:
Various StackOverflow articles that had similar issues, but their solutions haven’t worked for me (purging the system, re-installing, etc.).
Thank you in advance.
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.
×
Update
I changed the bind-address* * from
127.0.0.1
to my **second Droplet’s Private Network Address. This should be the Private Network Address from my database server.