ubuntu 16.04 mysql 5.6 创建新用户并开启远程登录

前端之家收集整理的这篇文章主要介绍了ubuntu 16.04 mysql 5.6 创建新用户并开启远程登录前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。

In order to connect remotely you have to have MysqL bind port: 3306 to your machines IP in /etc/MysqL/MysqL.conf.d/MysqLd.cnf Then you have to have created the user in both localhost and '%' wildcard and grant permissions on all DB's as such . See below:

Replace xxx with your IP Address (normally 0.0.0.0)

bind-address= xxx.xxx.xxx.xxx

then

CREATE USER 'myuser'@'localhost' IDENTIFIED BY 'mypass';
CREATE USER 'myuser'@'%' IDENTIFIED BY 'mypass';

Then

GRANT ALL ON *.* TO 'myuser'@'localhost';
GRANT ALL ON *.* TO 'myuser'@'%';

Depending on your OS you may have to open port 3306 to allow remote connections.

restart MysqL service:

sudo systemctl restart MysqL

猜你在找的Ubuntu相关文章