Configure MySQL to accept Telnet connections

An open MySQL

MySQL configuration file within the/etc/mysql/my.cnf file, there is a line bind-address = 127.0.0.1 means only local access, the line of comments can be

127.0. 0.1

Two create a new MySQL user

(1) The MySQL database is first accessed locally in MySQL library

Use MySQL;

(2) Create User:

Grant all privileges in (*). * to [e-mail protected] '% ' identified by ' password ';

Here (*) to allow access to all libraries, you can also write the library name here, you can only access the library, and all the tables of the database permissions to the user, allow the user through any IP address (also qualified IP address, '% ' to allow the ' IP '), using the specified password to connect, After configuration, use the command: flush privileges; Make the configuration effective, refresh the MySQL system permissions related table, otherwise you will receive access denied. Restarting the database can also achieve this effect

Flush privileges;

Three quit MySQL, restart the database

sudo service mysql restart

Configure MySQL to accept Telnet connections