Sep 13, 2018

How to start MySQL directly for debuging

Starting up the MySQL server directly could provide you more information for debugging, instead of
sudo -i service mysql start 
or
sudo -i /etc/init.d/mysql start
You could do something similar to:
shell> /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/extra/mysql2/db1-err.log --open-files-limit=8192 --pid-file=/var/lib/mysql/db1.pid --socket=/var/lib/mysql/mysql.sock --port=3306