How to unbind a local MySQL database from Ubuntu

Problem: In Ubuntu, a MySQL account is added, the database is granted full operation permissions, and the database is allowed to access the MySQL database remotely from external links. Cause: In Ubuntu, the default MySQL installation limits that only the local machine can access the database. Solution: cancel the local binding limit of the MySQL database.

Problem: In Ubuntu, a MySQL account is added, the database is granted full operation permissions, and the database is allowed to access the MySQL database remotely from external links. Cause: In Ubuntu, the default MySQL installation limits that only the local machine can access the database. Solution: cancel the local binding limit of the MySQL database.

Problem: In Ubuntu, a MySQL account is added, full database operation permissions are granted, and the database is allowed to access external links.
However, you still cannot remotely access the MySQL database.

Cause: In Ubuntu, the default MySQL installation limits that only the local machine can access the database.

Solution: remove the local binding restrictions of the MySQL database.

Nano/etc/mysql/my. cnf # edit the configuration file
Find bind-address = 127.0.0.1

Change

# Bind-address = 127.0.0.1
Ctrl + o # Save Configuration
Ctrl + x # exit
/Etc/init. d/mysql restart # restart the database

Now you can remotely connect to the MySQL database.