"Old blog Transfer-posted on September 6, 2015 18:42" The remote client connection does not appear on Linux after it is installed because the MySQL server is only allowed to log on locally to the database server for security reasons. Since I'm not familiar with linux, I've searched for some information and found some solutions.
one. Locate the MySQL configuration file etc/mysql/my.cnfNote skip-external-locking with bind-address = 127.0.0.1 Unlock the intranet, but after the release found still not connected, because my MySQL user does not have remote login permissions
two. Set remote permissions for users
Use MySQL;
Grant all privileges on * * to [email protected] '% ' identified by ' 123456 ';
The
above statement indicates that all permissions for all databases are authorized to the Lijia user, and *. * represents all databases if you want to authorize only one database, use the database name. *
and set the password to 123456
after executing the above statement, execute the
flush Privileges;Connection Successful ~
MySQL remote connection problem under Linux
