MySQL添加用户和授权

create user 'dev'@'%' identified by 'dev123456';

添加一个dev用户，所有ip可访问，密码：dev123456


grant privileges on databasename.tablename to 'username'@'host'

- privileges：SELECT , INSERT , UPDATE 如果要授予所的权限则使用ALL
- databasename.tablename 可以用*.*代替

flush privileges;

CentOS

/etc/sysconfig/iptables

A INPUT -p tcp -m state --state NEW -m tcp --dport 3306 -j ACCEPT

service iptables restart

打开 my.cnf 将bind-address=127.0.0.1改为 bind-address=0.0.0.0 或将其注释掉

service mysql restart