配置mysql远程连接
- vim /etc/mysql/mysql.conf.d/mysqld.cnf # 注释bind那行
- /etc/init.d/mysql restart # 重启mysql
- GRANT ALL PRIVILEGES ON . TO 'root'@'%' IDENTIFIED BY 'mysql' WITH GRANT OPTION;
- flush privileges;
终端乱码问题配置文件修改/etc/my/etc/mysql/mysql.conf.d/mysqld.conf
[mysql]
default-character-set=utf8
[mysqld]
character-set-server=utf8
Debug sql查询
SET GLOBAL log_output = 'TABLE';SET GLOBAL general_log = 'ON'; //日志开启
SELECT * from mysql.general_log ORDER BY event_time DESC; //查询
truncate table mysql.general_log; //清空表