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';

表統(tǒng)計

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

遠(yuǎn)程訪問
1、登錄mysql
2、查看 show databases;
3、使用 use mysql;
4、查看用戶 select User,Password,Host from user;
5、開放權(quán)限 GRANT ALL PRIVILEGES ON . TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;
6、刷新 FLUSH PRIVILEGES;
7、查看 select User,Password,Host from user; %代表不指定遠(yuǎn)程IP

另外 centos7 開啟3306 端口 firewall-cmd --add-port=3306/tcp --permanent
Warning: ALREADY_ENABLED: 3306:tcp（說明3306端口通過成功）
查看所有開發(fā)端口 firewall-cmd --zone=public --list-ports
重啟防火墻 service firewalld restart
在一個注意點(diǎn)，阿里云之類的 看看，安全組策略