如何让mysql开启root账户远程可用。

How to grant remote access permissions to mysql server for user?
授权先：


GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.1.%'     IDENTIFIED BY 'some_characters'      WITH GRANT OPTION; FLUSH PRIVILEGES;


-----
然后改下：
/etc/mysql/my.cnf 中的bind-address，注掉就是不限制ip了。

转载于:https://www.cnblogs.com/yanyuge/p/4294086.html