Remote access to the MySQL database in Ubuntu

In Ubuntu, MySQL only allows local access by default. If you want other machines to remotely access this Mysql database, you need to set something. Next we will step by step: 1. modify the configuration file 1. # sudovim/etc/mysql/my. conf find bind-address = 127.0.0.1 comment out this sentence 2. Mysql database Modification 1) [root @ etcetc] # mysql-u & nb

In Ubuntu, MySQL only allows local access by default. If you want other machines to remotely access this Mysql database, you need to set something. Next we will step by step:

1. Configuration File Modification

1. # sudo vim/etc/mysql/my. conf

Find bind-address = 127.0.0.1

Comment out this sentence

Ii. Mysql database Modification

1) [root @ etc] # mysql-u root-p

Enter password:

2) mysql> use mysql;

3) mysql> select host, user, password from user;

4) grant all privileges on *. * to root@192.168.15.101 identified by 'Password'

Note: (1) 192.168.15.101 is the IP address of the client to connect to this Mysql database, not the IP address of the database server where the Mysql database is located. Remember

(2) password is the password of the root user of the Mysql database, which needs to be modified according to the actual situation.

Iii. Log On with the Mysql client again