MySQL

## error message Debug the code and report an error after execution is complete ``` pymysql.…

## error message ``` (156, b"Incorrect syntax near the keyword 'group'.DB-Lib error message 200…

## foreword When we use mysql or other data, we always encounter that the database occupies a lo…

## problem When the server started today, the initialization failed, and the 2036 error of mysql…

## reason `Mysqldb` is not compatible with versions later than `python3.5` ## Solution Use…

## problem I've searched for a lot of solutions online, but nothing works. No matter what you…

## probelm error when installing mysqlcliend with `pip3` ``` ERROR: Command errored out wi…

## peoblem There is no public key in the system that can verify the digital signature of this RP…

## problem When installing mysql8, I did not encounter this problem before, but this time I sudd…

## 1 Check if it is started in cluster mode In the startup script `startup.cmd`, modify `MODE="s…

## problem Install mysql error, there is no error, this is the error message ``` All matches…

## problem The `zabbix` monitor reported an error when importing the `schema.sql` file, and the…

## error When connecting to MySql database remotely ``` ERROR 1045 (28000): Access denied fo…

# error ``` Error creating bean with name'methodValidationPostProcessor' ``` Little notes …

## problem I found a lot of posts on the Internet and copied each other. The key is not to solve…

## error `MySQL Workbench 6.3` is newly installed on Win7 computer. After opening, execute an `u…

abnormal: ``` Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class i…

When I wrote the SQL statement today, I sorted the numbers relative to the string type. How to do i…

## problem MySQL workbench version `8.0.27` connects to the local MySQL database report ``` …

## Problem Description Starting the project today suddenly throws the following error message: …

## error mysql master-slave service, stop the slave server from the machine to execute the start…

## background The business installed a version of `mysql server 5.7.25` of the `percona` branch …

## background The `mysql.user` table is broken after importing the data of `mysql 5.5` version i…

## error PageHelper's unsafe paging problem, resulting in  ``` ParserException: syntax error…

## conclusion first: Because there is a product description field set to `desc` in the table des…

## Start mysql8 ``` systemctl start mysqld.service ``` ## error ``` Job for mysqld.serv…

## error error when Linux installation MySQL  ``` Failed dependencies: libaio.so.1()(64bit) …

## 1 mysql password reset under windows 1.1 Stop the mysql service (in the starting state) ``…

The computer crashed during use. After restarting, it was found that mysql did not start successful…

When implementing mysql master-slave replication configuration, an error is reported as shown in th…

## problem description ``` mysql> update user set authentication_string=password('mysql123') wh…

## reason When MySQL builds a table, there is a limit on the maximum length of a single row: the…

## ERROR ``` SQL ERROR [1] [08S01]: Error while processing statement: FAILED: Execution Error, …

## descriptioon In a connection query, there is no problem with the query in the MySQL query too…

Install MYSQL In execution ``` mysqld --initialize --console ``` encountered an error …

## Problem Description Received four or five master-slave disconnection and recovery text messag…

## error ``` ERROR: Command errored out with exit status 1: command: /root/.pyenv/version…

An error may occur when entering the database for the first time after installing the mysql databas…

Execute an sql statement in mysql today and report an error: ``` mysql> select sum(xxxx) from x…

## Troubleshooting ``` [root@DBMysql ~]#masterha_check_repl --conf=/etc/masterha/app1.cnf ``` …

## two types of ERROR1118 **1.** ``` ERROR 1118 (42000): Row size too large. The maximum row…

## error The following error is encountered when installing the tokudb engine: ``` Checking …

The computer room was powered off, and after mysql started, an error was reported from the library:…

## background Run and start the mysql container on the local mac docker ``` docker run -d -p…

### background Run and start the mysql container on the local mac docker ``` docker run -d -…

## problem description ``` ┌──(rabbit㉿ASUS)-[/mnt/c/Users/rabbit] └─$ mysql -uroot -p3xxxxxxxS…

When learning the activiti process engine, integrating activiti with springboot can automatically d…

## error occured In MySQL8.0, create a user for master-slave replication: ``` mysql> CREATE …

``` /etc/init.d/mysqld stop mysqld_safe --user=mysql --skip-grant-tables --skip-networking & upd…

## problem description Check the content in the binlog and find that it cannot be viewed normall…

I made the simplest mistake when I was doing SQL problems today. ``` update salaries set salar…

After many trials, the steps to reset the password are as follows **step1**. Open the command wi…

## I am Redis Hello, I am Redis, and a man named Antirez brought me into this world. ![redis]…

At that time, I wanted to use `SQLyog` to remotely connect to the database, but found that I could …

## Preface When I write sql query, the most commonly used query is where conditional query. …

Use Navicat to link MySQL, and an error like this appears: ``` unknown error 1130 ``` ## So…

## Create table ``` drop table if exists sequences; create table sequences ( SEQUENCE_NAME…

## error statement: ``` if(ca_coupon_id is null, 0, size(ca_coupon_id)) as m_coupon_available_n…

In the Windows environment, when installing mysql for the first time, I get an error  ``` ERROR…

## 1\. Statement ``` mysql> CREATE TABLE permissions ( -> role varchar(50) NOT NULL, …

Failed to create user creation. `ERROR 1728 (HY000): Cannot load from mysql.procs_priv. The table i…

## Problem Description When using Azure Function to create a new Python Function, `ModuleNotFoun…

## Reason The connection read timeout, MYSQL loses the connection, and the service has been disc…

## reason I went and I imported the **mysql5** package ![ mysql5 package](https://static-work…

## solution ``` mysql> CREATE USER 'mysql.infoschema'@'localhost' IDENTIFIED BY 'password'; …

Solution for the `2003-Can’t connect to Mysql on ‘host name’ (10061)` error when use navicat to con…

Today the company’s project view query reported an error. I looked for the code and the reason for …

## Table ``` CREATE TABLE `apply_log` ( `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '主键', …

Execution data table structure error: ``` [Err] 1055 - Expression #1 of ORDER BY clause is not …

## error message ``` ### Error querying database. Cause: java.sql.SQLException: Unknown initia…

**mysql version**: 5.7.29 When importing the dump file of big data, the database is automaticall…

## DTS data synchronization error prompt: ``` DTS-1020013 Get db tables error,err msg:SELECT…

I did a test recently, and the main thread business processing logic is relatively long. I found th…

## Export MySQL query data to csv file to `.csv`: ``` # mysql  -h  xx.xx.xx.xx  -u root -p'M…

## background For some purposes, it is necessary to frequently delete all data of a specified se…

Query the amount of disk space occupied by all databases ``` select TABLE_SCHEMA, concat(tr…

## Table data Statistical data sql statement ``` SELECT name,count(*) FROM `test` GROUP BY n…

What is the .frm.ibd file in ubuntu mysql? `.ibd`: stores metadata of each table, including the …

ubuntu reinstall mysql and restore data through .frm.ibd ## mysql storage location: ``` /var…

ubuntu mysql5.7 startup prompt error ``` mysql start ERROR 2002 (HY000): Can't connect to loca…

mysql error Errcode: 13 "Permission denied" Background: After reinstalling mysql and dragging th…

## Delete mysql5.7 completely ``` #The following commands are executed in sequence sudo rm /…

## error Encountered an error when executing the sql statement: ``` [Err] 1235 - This versio…

Encountered an error when writing data: ``` django.db.utils.InternalError: (1153, "Got a packet…

Insert a large amount of data into a table in batches. For example, insert name into the tags ta…

## background In the tens of thousands of records in the people table, there are some identical …

## Error message ``` select * from `bdetector` where id in (select id from `bdetector` group b…

mysql Use the command to view the current mysql version ``` select version(); ``` The resul…

## MySql set the default value'collation\_connection' ``` SET NAMES utf8mb4 COLLATE utf8mb4_uni…

`count(1)` and `count()` are generally used to count the amount of data in the entire table, includ…

SQL query data in a certain time range ## sql statement ### first method ``` SELECT users…

## solution ``` ALTER TABLE tablename AUTO_INCREMENT = 1 ``` > **Note**: For InnoDB, you ca…

## Data There is a data table for targt, the data is as follows: ``` Id Name Other_Colum…

## Introduction Fast paging can be achieved in django, but when the data reaches several million…

**Django model layer (database) connection processing logic:** 1. Use `CONN_MAX_AGE` configurat…

## problem Using the Django Debug Toolbar, I found that the sql statement to count the number of…

Sometimes you want to know how Django ORM makes our queries execute, or what the SQL corresponds to…

## Introduction It is important to understand that the options in the Django model field definit…

## environment * python=3.8 * django=3.1 ## error message ``` django.core.exceptions…

## environment Django: how to uses bulk\_create (batch creation) to get the id after successful …