datetime(0) NOT NULL DEFAULT '0000-00-00 00:00:00' 失败
SET GLOBAL sql_mode='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';
表统计
SELECT TABLE_NAME,TABLE_ROWS,DATA_LENGTH/1024/1024 "DATA_LENGTH",CREATE_TIME,TABLE_COLLATION FROM
INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'test' ORDER BY TABLE_ROWS DESC
SELECT TABLE_NAME,TABLE_ROWS,DATA_LENGTH/1024/1024 "DATA_LENGTH",TABLE_COMMENT,CREATE_TIME,TABLE_COLLATION FROM
INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'jc_cainiaosys' ORDER BY TABLE_ROWS DESC
远程访问
1、登录mysql
2、查看 show databases;
3、使用 use mysql;
4、查看用户 select User,Password,Host from user;
5、开放权限 GRANT ALL PRIVILEGES ON . TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;
6、刷新 FLUSH PRIVILEGES;
7、查看 select User,Password,Host from user; %代表不指定远程IP
另外 centos7 开启3306 端口 firewall-cmd --add-port=3306/tcp --permanent
Warning: ALREADY_ENABLED: 3306:tcp（说明3306端口通过成功）
查看所有开发端口 firewall-cmd --zone=public --list-ports
重启防火墙 service firewalld restart
在一个注意点，阿里云之类的 看看，安全组策略
