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

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/mysqlgrep -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: kezunlin.me/post/36e618…
• Copyright Notice: All articles in this blog are licensed under CC BY-NC-SA 3.0 unless stating additionally.