Debian6 how to configure mysql to allow remote connection (figure)

Debian6 system:

First install mysql:

Open the terminal (root) User Login

Apt-get purge mysql-server-5.5

After installation:

By default, Mysql only allows local login, so you need to modify the configuration file to bind the address to comment out:
Copy codeThe Code is as follows:
Vim/etc/mysql/my. cnf

# Bind-address = 127.0.0.1 <--- comment out this line and you can log on remotely.

If the problem persists, log on to mysql and run the following statement: UPDATE user SET Password = PASSWORD ('newpassword') where USER = 'root ';