Summary of common problems with mysql during development

Record the mysql-related problems encountered during the development process and their solutions, and update them in the long term.

Remote connection problem

Mysql default connection can only be given to the local (localhost or 127.0.0.1). If you want a certain IP address to access mysql, you need to open it manually. This permission

Method:

● Enter the terminal

● Assign a new user

grant all privileges on *.* to '用户名'@'IP地址' identified by '密码';

● Refresh permissions

flush privileges;

If you want to use LAN All machines can connect to the mysql database and execute the following command

grant all privileges on *.* to '用户名'@'%' identified by '密码' with grant option;

● all privileges refers to all permissions, and can also be written as select, utdate, etc.

● *.*refers to all tables in the database

● IP address: IP address allowed to connect, % is allowed for all machines in the LAN

Reserved word problem

MySQL reserved words like index , should be avoided as much as possible in development. If index is used, then the sql should be processed through back single quotes `` (the key below Esc)

Table case issue

Mysql does not distinguish the case of table names under the Windows system, but mysql indicates that it is case-sensitive under the Linux system. In Linux, make mysql case-insensitive:

● Log in as root and modify /etc/my.cnf

● Add a line under [mysqld]: lower_case_table_names=1

● Restart mysql

Recommendation: "mysql video tutorial"

The above is the detailed content of Summary of common problems with mysql during development. For more information, please follow other related articles on the PHP Chinese website!