MySQL server fails to start after IP change (Ubuntu machine)

  • 0

MySQL server fails to start after IP change (Ubuntu machine)

Tags :

Category : Tools

Happened today after we relocated a staging environment machine to DMZ.

>sudo service mysql start

start: Job failed to start.

Solution:

Mysql has a bind address recorded in it’s configuration file: /etc/mysql/my.cnf

bind-address    =    <your.machine.ip>

Change the value to your new ip and start mysql. Should work like charm.


About Author

Anton Weiss

Founding Consultant at Otomato. More than 17 years of industry experience delivering software and building great IT organisations. Passionate about innovation, creativity and freedom of expression.

Leave a Reply