Report this

What is the reason for this report?

After updating bind-address in /etc/msql/my.cnf file MySQL stops working

Posted on May 29, 2018

I did everyting according to this tutorial, https://www.digitalocean.com/community/tutorials/building-for-production-web-applications-deploying#set-up-database-server and all the nameserver (app1, etc) resolve properly. When i now bind the adress in the mysql config and i restart the mysql server, ill get an error

● mysql.service - LSB: Start and stop the mysql database server daemon Loaded: loaded (/etc/init.d/mysql) Active: failed (Result: exit-code) since Tue 2018-05-29 19:06:08 UTC; 3min 41s ago Process: 14636 ExecStop=/etc/init.d/mysql stop (code=exited, status=0/SUCCESS) Process: 14669 ExecStart=/etc/init.d/mysql start (code=exited, status=1/FAILURE)

May 29 19:05:38 DB1 systemd[1]: Starting LSB: Start and stop the mysql database server daemon… May 29 19:06:08 DB1 /etc/init.d/mysql[15402]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/…ed in May 29 19:06:08 DB1 mysql[14669]: Starting MySQL database server: mysqld . . . . . . . . . . . . . . . . . . …ailed! May 29 19:06:08 DB1 systemd[1]: mysql.service: control process exited, code=exited status=1 May 29 19:06:08 DB1 systemd[1]: Failed to start LSB: Start and stop the mysql database server daemon. May 29 19:06:08 DB1 systemd[1]: Unit mysql.service entered failed state. Hint: Some lines were ellipsized, use -l to show in full.


~# journalctl -xn – Logs begin at Tue 2018-05-29 19:00:42 UTC, end at Tue 2018-05-29 19:06:54 UTC. – May 29 19:06:08 DB1 /etc/init.d/mysql[15402]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysql May 29 19:06:08 DB1 /etc/init.d/mysql[15402]: May 29 19:06:08 DB1 mysql[14669]: Starting MySQL database server: mysqld . . . . . . . . . . . . . . . . . . . . . . . May 29 19:06:08 DB1 sudo[14631]: pam_unix(sudo:session): session closed for user root May 29 19:06:08 DB1 systemd[1]: mysql.service: control process exited, code=exited status=1 May 29 19:06:08 DB1 systemd[1]: Failed to start LSB: Start and stop the mysql database server daemon. – Subject: Unit mysql.service has failed – Defined-By: systemd – Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel

– Unit mysql.service has failed.

– The result is failed. May 29 19:06:08 DB1 systemd[1]: Unit mysql.service entered failed state. May 29 19:06:54 DB1 sshd[15406]: Invalid user video from 130.211.63.22 May 29 19:06:54 DB1 sshd[15406]: input_userauth_request: invalid user video [preauth] May 29 19:06:54 DB1 sshd[15406]: Connection closed by 130.211.63.22 [preauth] lines 1-18/18 (END)

The developer cloud

Scale up as you grow — whether you're running one virtual machine or ten thousand.

Start building today

From GPU-powered inference and Kubernetes to managed databases and storage, get everything you need to build, scale, and deploy intelligent applications.