1、添加个新用户
在MYSQL下执行:
mysql>GRANT ALL PRIVILEGES ON *.* TO '用户名'@'%' IDENTIFIED BY '密码' WITH GRANT OPTION;2、修改一个用户
mysql>use mysql;mysql>update user set host = '%' where user = 'root';mysql>select host, user from user;
PS:
如果连接不上可能是防火墙的拦截了;可以关闭防火墙试试
# service iptables stop