Start stop restart MySQL under Ubuntu to view the error log command Daqo

  • 2020-06-19 11:50:13
  • OfStack

1) Startup:


sudo /etc/init.d/mysql start

2) Stop:


sudo /etc/init.d/mysql stop

3) Restart:


sudo /etc/init.d/mysql restart

4) Log viewing:


cat /var/log/mysql.err

cat /var/log/mysql/error.log

5) Chinese is not supported

Modify/etc mysql/my cnf

Add under [client] :

default character - set = utf8 or character_set_server = utf8

Add under [mysqld] :

default character - set = utf8 or character_set_server = utf8

6) Error: unknown variable 'default-ES50en-ES51en =utf8'

Modify the configuration file/etc mysql/my cnf in "default character - set = utf8" for "character_set_server = utf8"


Related articles: