Debian6 Configure Mysql to allow remote connections (figure) _mysql

DEBIAN6 System:

First install MySQL bar:

Open terminal (root) User Login

Apt-get Purge mysql-server-5.5

After the installation is complete:

By default, MySQL only allows local logins, so you need to modify the configuration file to bind addresses to comments:

Copy Code code as follows:

Vim/etc/mysql/my.cnf

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

If not, please log on locally mysql execution words: UPDATE user SET Password=password (' NewPassword ') where user= ' root ';