
mysql
「已注销」
这个作者很懒,什么都没留下…
展开
-
mysql数据库大小写敏感
mysql> show global variables like '%lower_case%';+------------------------+-------+| Variable_name | Value |+------------------------+-------+| lower_case_file_system | OFF || lower_case_table_names | 0 |+------------------------+--原创 2021-11-23 13:02:41 · 1369 阅读 · 0 评论 -
navicat 忘记mysql密码
在数据库连接 右击选择命令行界面在这直接重置为rootmysql> use mysql;Database changedmysql> UPDATE user SET authentication_string = PASSWORD('root') WHERE user = 'root';Query OK, 1 row affected (0.04 sec)Rows matched: 1 Changed: 1 Warnings: 1mysql> flush privil.原创 2020-12-31 22:33:40 · 325 阅读 · 0 评论 -
数据库连接池 Too many connections
java.sql.SQLNonTransientConnectionException: Data source rejected establishment of connection, message from server: "Too many connections" at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110) at com.mysql.cj.jdbc.exceptions.SQL原创 2020-12-27 19:39:41 · 291 阅读 · 1 评论