1、Mysql中对时间的格式化
DATE_FORMAT(i.ctime,'%Y-%m-%d %T')
2、Mysql开启远程的方式;
mysql> Grant all privileges on *.* to 'root'@'%' identified by ‘password’with grant option;
mysql> flush privileges;