Topic

database

A collection of 2 issues

MySQL backlog

今天正巧看到了，先总结在这里 back_log [https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_back_log] Command-Line Format--back-log=#System Variableback_logScopeGlobalDynamicNo SET_VAR Hint AppliesNoTypeIntegerDefault Value-1 (signifies autosizing; do not assign this literal value)Minimum Value1The number of outstanding connection requests MySQL can have. This comes into play

[AWS]记一次连接EC2 MySQL的问题

帮实习生解决连不上ec2上mysql的问题。 AMI是Amazon Linux 2, MySQL版本是Ver 14.14 Distrib 5.7.29 1. 先看了眼security group的inbound rules，是允许公司内网所有端口的。 2. 检查本地连接,尝试本地登录安装后尝试本地连接报错 (env) [root@XXXXXXX ec2-user]# mysql -u root ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) 也不允许看版本 (env) [root@XXXXXXX ec2-user]# mysql -v ERROR 1045 (28000): Access