ERROR 2003 (HY000): Can ' t connect to MySQL server on ' 192.168.33.10 ' (111) workaround

Google a bit after the original is in the MySQL my.cnf in the following section of code:

# Instead of skip-networking The default is now-listen only on# localhost which are more compatible and are not less secure.bind-address           = 127.0.0.1  #这里默认监听本地localhost

If you want to allow MySQL to listen to other addresses, you can bind-address = 127.0.0.1 comment out. 

Or we'll bind-address = 0.0.0.0 listen to all the addresses.

If you want to 192.168.10.83 be able to connect to the local database, let the database assign permissions to it, log in to MySQL, execute: (username and password are login MySQL username and password)

 grant  all  privileges  on  * . *  to   " username   " @"  192.168.10.83   " identified by  "  password   " with  grant  option ; 

< Span class= "Hljs-keyword" >< Span class= "hljs-string" > 
 
               If you want all external IP addresses to be accessible using MySQL, you can do the following: 

GRANT  All Privileges  on *. *  to ' username '@ '%' by'password'  withGRANTOPTION;

After executing the refresh database:

privileges;

ERROR 2003 (HY000): Can ' t connect to MySQL server on ' 192.168.33.10 ' (111) Workaround