mysql 安装后，服务连接不上

1. [Warning] TIMESTAMP with implicit DEFAULT value is deprecated

solution: https://www.cnblogs.com/abclife/p/5051589.html
explicit_defaults_for_timestamp参数: https://www.cnblogs.com/abclife/p/5051861.html

2. mysql 连接时 ERROR 1045 (28000): Access denied for user ‘root’@‘主机名’ (using password: YES)

• 查password 是否正确; 改密码可用：

mysqladmin -u root password "new_password";

• 执行 授权

 grant all previleges on *.*  user@'%'  to identified by ‘password′ ;

• 以上者了不行： 在my.cnf 或 my.ini 最后加上 skip_name_resolve; linux 可用 whereis my.ini 找到 my.ini找到文件;

https://blog.youkuaiyun.com/hwhua1986/article/details/78188231
https://www.cnblogs.com/ivictor/p/5311607.html