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.
The order is important, so try this procedure:
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.