MySQL Problem summary

1, the data table exists, but the query prompt does not exist

Cause: By default, MySQL is not sensitive to table name size (Lower_case_table_names=1) in Windows, and is size sensitive on Linux (lower_case_table_names=0).

Workaround: Add configuration Items to the configuration file/etc/my.cnf

[mysqld]    Lower_case_table_names=1

2, navicat remote connection MySQL database 1045 error occurred

Cause: MySQL service is not licensed

Workaround: Add access to the remote login user to all machines

0、 UseMySQL;1、Grant  All Privileges  on *.*  to 'Root'@'%'Identified by 'MySQL'  with Grant option; 2, flushPrivileges;3、Select *  from User;
Command format: Grant permission 1, permission 2,... Permission n on the database name. Table name to User name @ user address identified by ' connection password ';
Permissions 1, Permissions 2,... Permission n represents 14 permissions, such as Select,insert,update,delete,create,drop,index,alter,grant,references,reload,shutdown,process,file.
When permissions 1, permissions 2,... Permission n is replaced by all privileges or all to give the user full permission.
When the database name. The table name is replaced by *. *, which indicates that the user is given permission to manipulate all tables on the server.
The user address can be localhost, or it can be an IP address, a machine name, and a domain name. You can also use '% ' to indicate connections from any address.
' Connection password ' cannot be empty, otherwise the creation failed.

MySQL Problem summary