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"