本文首发于个人博客https://kezunlin.me/post/36e618e7/，欢迎阅读!

Mysql user guide on ubuntu 16.04 and windows 10

Part-1: Ubuntu

install

sudo apt-get install mysql-server
# root,123456

mysql -uroot -p123456

allow remote access

change bind-address

cd /etc/mysql
grep -r "bind-address" .
./mysql.conf.d/mysqld.cnf:bind-address          = 127.0.0.1

change bind-address to 0.0.0.0

vim ./mysql.conf.d/mysqld.cnf
bind-address          = 0.0.0.0

# or 
sed -i "s/127.0.0.1/0.0.0.0/g" /etc/mysql/mysql.conf.d/mysqld.cnf

# restart
service mysql restart

grant users

mysql> grant all privileges on *.* to "root"@"%" identified by "123456" with grant option;
mysql> flush privileges;

check for users.

mysql> use mysql;
mysql> select user,host from user;
+------------------+-----------+
| user             | host      |
+------------------+-----------+
| root             | %         |
| debian-sys-maint | localhost |
| mysql.session    | localhost |
| mysql.sys        | localhost |
| root             | localhost |
+------------------+-----------+
5 rows in set (0.00 sec)

OK. Now we can access mysql from remote Machine.

Test connection

mysql -uroot -p123456 -h 192.168.0.130

Part-2: Windows

install mySQL Server 5.7

OK

allow remote access

grant users

mysql> grant all privileges on *.* to "root"@"%" identified by "123456" with grant option;
mysql> flush privileges;

close fireware

close fireware and allow 3306 tcp connection.

Test connection

mysql -uroot -p123456 -h 192.168.0.130

or by mysql client.

Reference

• mysql guide
• mysql remote access
• mysql on windows remote access

History

• 20180124: created.
• 20180308: add windows part.

Copyright

• Post author: kezunlin
• Post link: https://kezunlin.me/post/36e618e7/
• Copyright Notice: All articles in this blog are licensed under CC BY-NC-SA 3.0 unless stating additionally.