授权
1、登录 mysql -uroot -p 123456
2、use mysql;
3、GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;(可根据自己需要授权)
4、检查/etc/mysql/my.cnf中
bind-address设置,看是绑定的IP,根据实际情况设定(设定固定IP,或屏蔽)
5、重启mysql,service mysql restart