MySQL failed to restart on Ubuntu 16.04

Fatal Error:

MYQL is failing to start because as the Journalctl output indicates, but you haven't provided the mandatory server-id. Add the mandatory id as indicated in the code below.

/etc/mysql/mysql.conf.d/mysqld.cnf
Change from:

log-bin=mysql-bin
binlog-format = 'ROW'

Change to:

server-id=master-01
log-bin=mysql-bin
binlog-format = 'ROW'

This will get your server running while you address the proper formatting of your desired logging.

non-fatal warnings:

For the open files limit of your error you will have to either decrease the demand in the configuration you edited or increase the system's limits with:

/etc/security/limits.conf

* soft nofile [new number]
* hard nofile [new number]

The first column describes WHO the limit is to apply for. '' is a wildcard, meaning all users. To raise the limits for root, you have to explicitly enter 'root' instead of ''.

Taken from:
https://askubuntu.com/a/162230/29012


Got the same error, but in my case simply the disk was full. Make also sure to check this.

df -h --total

Tags:

Mysql

16.04