Enable remote connection to MySQL under Ubuntu Server

To enable remote connection to MySQL under Ubuntu Server, two steps are required:

The first step is to create a MySQL user that can be remotely connected

Mysql> grant all privileges on remote. * TO remote @ "%" identified by "remotepwd ";

Step 2: Modify the mysql configuration file/etc/mysql/my. cnf

$> Sudo vi/etc/mysql/my. cnf

In the old version, locate skip-networking and comment it out.
# Skip-networking

In the new version:
# Instead of skip-networking the default is now to listen only on
# Localhost which is more compatible and is not less secure.
Bind-address = 127.0.0.1

Bind-address = 127.0.0.1 must be commented out.
# Bind-address = 127.0.0.1

Or fill in the ip addresses that are allowed to access
# Bind-address = 192.168.1.100

Restart MySQL
$> Sudo/etc/init. d/mysql restart
* Starting MySQL database server mysqld
... Done.
* Checking for login upt, not cleanly closed and upgrade needing tables.
Andy @ Ubuntu :~ $ Sudo/etc/init. d/mysql start
* Starting MySQL database server mysqld
... Done.

In this way, you can remotely access MySQL.