Ubuntu MySQL Configuration

By default, MySQL only allows local access. 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@www.bkjia.com] # mysql-u root-p

Enter password:

2) mysql> usemysql;

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

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

Note: (1) 192.168.15.101 is the IP address of the client connecting to the 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