ubuntu16 mysql第一次登录_ubuntu 16.04 mysql 5.6 创建新用户并开启远程登录

Everlasting Cold

于 2021-01-19 10:27:24 发布

阅读量106

点赞数

文章标签： ubuntu16 mysql第一次登录

本文链接：https://blog.csdn.net/weixin_36324960/article/details/113231536

版权

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