Ubuntu 16.04 and windows 10 systems install Mysql to allow remote access

Time:2020-3-18

This article was first published on my blog https://kezunlin.me/post/36e618e7/, welcome to read!

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.

Recommended Today

The difference between jar package and war package

1、 Concept Jar package: jar package is the archive file of class. Jar file format is based on popular zip file format. Unlike zip files, jar files are not only used to compress and publish, but also to deploy and encapsulate libraries, components and plug-ins, and can be used directly by tools like compilers and […]