mysql常见问题汇总

1. 指定用户访问指定数据库

grant all privileges on imserver.* to 'imserver'@'%' identified by '1204';
flush privileges;

2.  表名不区分大小写

show variables like '%lower%';

修改 vim  /etc/mysql/mysql.conf.d/mysqld.cnf

lower_case_table_names = 1

再查：

3. mysql主从备份，从数据库备份错误: Could not execute Delete_rows event on table imserver.qrtz_scheduler_state; Can't find record in 'qrtz_scheduler_state', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log mysql-bin.000040, end_log_pos 633

https://blog.csdn.net/sj349781478/article/details/79492895

4. java.sql.SQLNonTransientConnectionException: Data source rejected establishment of connection,  message from server: "Too many connections"

查询show variables like 'max_connections';

修改 vim /etc/mysql/mysql.conf.d/mysqld.cnf

max_connections        = 1000