/etc/init.d/mysql
用apt-get安装的mysql会生成默认用户与密码,配置文件在
/etc/mysql/debian.cnf
链接远程数据库要修改远程链接权限:
update user set host='%' where user='xxxx';
并更改配置文件 /etc/mysql/mysql.conf.d/mysqld.cnf
重的bind-address
Check sql_mode
SELECT @@GLOBAL.sql_mode;
SELECT @@SESSION.sql_mode;
To change the SQL mode at runtime, set the global or session sql_mode
system variable using a SET
statement:
SET GLOBAL sql_mode = '*modes*'; SET SESSION sql_mode = '*modes*';