MySQL默认是没有开启远程控制的,必须添加远程访问的用户,如果是安装版的话,从MySQL提供的控制台进入。
# mysql -u root -p
进入mysql操作界面
mysql> select host from mysql.user where user="root";
+-----------+
| host |
+-----------+
| localhost |
+-----------+
1 row in set (0.01 sec)
创建全权限用户:
mysql>grant all privileges on *.* to UserName@'%' identified by 'password';
创建有限权限的本地操作用户:
mysql>grant select, insert, delete, update ON databasename.tablename TO UserName@'localhost' identified by 'password';