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 the MySQL database, you need to set something

Modify/etc/mysql/my. cnf

Comment out this sentence bind-address = 127.0.0.1

Grant database access permissions to a host

Grant all privileges on weguan. * to test@202.101.222.111 identified by 'Password'

Note:
1.202.101.222.111 is the IP address of the client to connect to this mysql database.

2. The password is the password of the mysql database test user, which needs to be modified according to the actual situation.

The mysql table name installed in Ubuntu is case-sensitive. To make mysql of Ubuntu ignore the case sensitivity of the table name, you can add it under [mysqld] Of my. cnf

Lower_case_table_names = 1