Ubuntu15.04 MySQL database allows Toad remote connection

I installed Ubuntu15.04 on the vmwarevm. mysql service can be enabled. However, when I use Toad for remote connection, the connection fails. The error message UnabletoconnecttoanyofthespecifiedMySQLhosts is displayed. solution: 1. Disable the firewall root @ linuxidc:/etc/mysql # ufwdisable2. Set/etc/mys

I installed Ubuntu 15.04 IN THE vmwarevm. mysql service can be enabled. However, when Toad is used for remote connection, the connection fails and an error message is displayed.

Unable to connect to any of the specified MySQL hosts.

The solution is as follows:

1. Disable the Firewall

Root @ linuxidc:/etc/mysql # ufw disable

2. Comment out bind-address = 127.0.0.1 in the/etc/mysql. conf. d/mysqld. cnf file.

Procedure:

Root @ linuxidc:/etc/mysql # vim/etc/mysql. conf. d/mysqld. cnf

3. Restart the mysql service.

Root @ linuxidc:/etc/mysql # service mysql restart

For more information about Ubuntu, see Ubuntu special page http://www.linuxidc.com/topicnews.aspx? Tid = 2

This article permanently updates the link address: Http://www.linuxidc.com/Linux/2016-03/129202.htm