无法连接远程MySQL数据库的解决方案

-- 查看user
mysql> use mysql;
mysql> select host,user,password from user;

-- 创建新user
mysql> create user 'username' identified by 'userpwd';
# 或
mysql> grant all privileges on *.* to 'username'@'xxx.xxx.xxx.xxx' identified by 'userpwd'; -- 如果任何IP可连接，则@'%'

-- 修改用户名
mysql> rename user 'oldname' to 'newname'；-- mysql5之前需要使用update更新user表

-- 删除user
mysql> drop user newuser; -- mysql5之前删除用户时必须先使用revoke 删除用户权限，然后删除用户，mysql5之后drop 命令可以删除用户的同时删除用户的相关权限

-- 更改密码
mysql> update mysql.user set password=password('xxxx') where user='username';

-- 查看用户权限
mysql> show grants for 'username';
-- 赋予权限
mysql> grant select on dbname.* to 'username';
-- 回收权限
mysql> revoke select on dbname.* from 'username';

-- 刷新生效
mysql> flush privileges;

[mysqld]
# instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure
bind-address = 127.0.0.1