MySQL telnet and table name capitalization issues

Long time no blog, this period in the study of an open source project, inside the use of MySQL, long no use of MySQL. In the use of the process encountered a problem, remote login. Error message It is obvious that the connection failed. The solution is as follows:

1. First check to see if the server network is up, and there is no problem.

2. Check the user name password is correct, by logging on the server to see also no problem.

3. Check if the MySQL service is started, the port is correct: Ps-aux|grep "MySQL" Netstat-apn|grep "3306", and check if the link in the configuration file is correct, everything is OK.

4. See if the selected user supports remote login. SELECT * from Mysql.user\g; Verified work The user's host value is the% wildcard, and there is no problem.

This is a bit of an egg, look at the MySQL configuration file vim/etc/mysql/mysql.conf.d/mysqld.cnf found in the configuration file has a binding attribute bind-address=127.0.0.1, first explain the meaning of this parameter: This parameter is primarily configured with MySQL's monitoring IP specific values as follows:

*	Receive all IPV4 or IPV6 connection requests
0.0.0.0	Accept all IPV4 addresses.
::	Accept all IPv4 or IPV6 addresses
ipv4-mapped	Accept all IPV4 addresses or IPV4 state-fixed addresses (ex: ffff:127.0.0.1)
IPV4 (IPV6)	Accept only the corresponding IPV4 (IPV6) address

It seems that the problem is here, if this value is localhost, then MySQL can only accept local access, as far as the request for remote access is unacceptable, so we simply take this line to comment out, all OK. (Note: If it must be set to the specified IP in the production environment, anyone can access it, which is bound to create unnecessary danger)

Problem two: There was another error at run time, table not exist, but it does exist when looking at the table, simply put the name of the table in the code (uppercase) to the terminal for querying, or a table not exist error. Modify the configuration file in the Lower_case_table_names parameter is 1, specific analysis see blog 44236259.

If there is any improper, please criticize correct, thank you!

MySQL telnet and table name capitalization issues