使用GRANT命令创建远程连接mysql授权用户特定用户
mysql -u root -ppassword 注意:p后面没有空格直接密码。
mysql>grant all privileges on *.* to ‘用户名’@‘%’identified by ‘密码’;
这里使用’%’通配符表示任意地址的远程机器
修改my.cnf文件
Sudo vi /etc/mysql/
[mysqld]
#
# * Basic Settings
#
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
lc-messages-dir = /usr/share/mysql
#skip-external-locking #add contexts as follows was edited by ***
skip-name-resolve
skip-grant-tables
把skip-external-locking注释掉,在下面添加skip-name-resolve,skip-grant-tables
bind-address = 192.168.1.149
#bind-address = 127.0.0.1
把bind-address 原来的环回地址改成ifconfig之后的地址
重启mysql服务
Sudo service mysql restart