MySQL

Pymysql: Pymysql.Err.Programmingerror: (1064, “You Have An Error In Your Sql Syntax

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

TwoPunch created at May 26, 2022, 10:46 a.m.

B“Incorrect Syntax Near The Keyword ‘Group‘.Db-Lib Error Message 20018, Severity 15:\Ngeneral S

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

TwoPunch created at May 26, 2022, 10:28 a.m.

Causes And Solutions Of Mysql Occupying A Lot Of Disk Space

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

TwoPunch created at March 25, 2022, 11:15 a.m.

Error: 2036 (Cr_Unsupported_Param_Type) Message: Using Unsupported Buffer Type: %D (Parameter: %D)

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

TwoPunch created at Feb. 23, 2022, 9:17 p.m.

Python-Mysql Problem: Nameerror: Name '_Mysql' Is Not Defined

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

TwoPunch created at Feb. 13, 2022, 12:14 p.m.

Mysql8.0: Error 1396 (Hy000): Operation Alter User Failed For 'Root'@'Localhost'

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

TwoPunch created at Jan. 26, 2022, 2:16 p.m.

Error: No Matching Distribution Found For Mysqlclient

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

TwoPunch created at Jan. 25, 2022, 3:08 a.m.

Mysql: Public Key For *.Rpm Is Not Installed

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

TwoPunch created at Jan. 25, 2022, 12:35 a.m.

The Gpg Keys Listed For The "Mysql 8.0 Community Server" Repository Are Already Installed But They Are Not Correct For This Package

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

TwoPunch created at Jan. 24, 2022, 5:28 p.m.

Nacos Start Error: [Db-Load-Error]Load Jdbc.Properties Error

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

TwoPunch created at Jan. 14, 2022, 1:11 p.m.

All Matches Were Filtered Out By Modular Filtering For Argument: Mysql-Community-Server Error: Un...

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

TwoPunch created at Jan. 1, 2022, 9:52 a.m.

Error 1071 (42000): Specified Key Was Too Long; Max Key Length Is 3072 Bytes

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

TwoPunch created at Dec. 30, 2021, 4:01 a.m.

Error 1045 (28000): Access Denied For User 'Root'@'Localhost' (Using Password: Yes)

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

TwoPunch created at Dec. 30, 2021, 3:55 a.m.

Error Creating Bean With Name'methodvalidationpostprocessor'

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

TwoPunch created at Dec. 30, 2021, 3:48 a.m.

Error 1396 (Hy000): Operation Alter User Failed For 'Root'@'Localhost'

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

TwoPunch created at Dec. 29, 2021, 1:26 a.m.

Mysql Workbench Error Code: 1175. You Are Using Safe Update Mode And You Tried To Update

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

TwoPunch created at Dec. 29, 2021, 1:15 a.m.

Loading Class `Com.Mysql.Jdbc.Driver'. This Is Deprecated. The New Driver Class Is `Com.Mysql.Cj.Jdbc.Driver'.

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

TwoPunch created at Dec. 27, 2021, 11:43 p.m.

Mysql Converts A String To A Number

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

TwoPunch created at Dec. 27, 2021, 11:31 p.m.

Mysql Workbench Problem: Ssl Connection Error: Ssl Is Required But The Server Doesn’T Support It.

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

TwoPunch created at Dec. 27, 2021, 9:08 a.m.

Init Datasource Error, Url: Jdbc:Mysql://Localhost:3306/Test

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

TwoPunch created at Dec. 16, 2021, 5:08 p.m.

Error 3021 (Hy000): This Operation Cannot Be Performed With A Running Slave Io Thread; Run Stop Slave Io_Thread For Channel '' First.

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

TwoPunch created at Dec. 13, 2021, 3:14 p.m.

Can't Start Server: Bind On Tcp/Ip Port: Permission Denied

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

TwoPunch created at Dec. 13, 2021, 3:03 p.m.

Error 1805 (Hy000): Column Count Of Mysql.User Is Wrong. Expected 45, Found 42. The Table Is Probably Corrupted

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

TwoPunch created at Dec. 13, 2021, 2:54 p.m.

Parserexception: Syntax Error, Error In :'It 1 Limit ? ', Expect Limit, Actual Limit Pos , Line , Column , Token Limit

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

TwoPunch created at Dec. 12, 2021, 8:37 a.m.

Org.Springframework.Jdbc.Badsqlgrammarexception ### Error Querying Database Cause: Com.Mysql.Jdbc

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

TwoPunch created at Dec. 5, 2021, 7:24 p.m.

Job For Mysqld.Service Failed Because The Control Process Exited With Error Code. See “Systemctl Sta

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

TwoPunch created at Dec. 5, 2021, 6:56 p.m.

Error: Failed Dependencies: Libaio.So.1()(64bit) Is Needed By Mysql-Community-Server-5.7.26-1.El7.X86_64

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

TwoPunch created at Nov. 25, 2021, 10:22 p.m.

How To Recover The Mysql Password When Forgotten-Windows/Liunx Version: Mysql-8.0.27

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

TwoPunch created at Nov. 24, 2021, 4:46 p.m.

How To Deal With Mysql Innodb Startup Failure And Unable To Restart

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

TwoPunch created at Nov. 24, 2021, 2:49 p.m.

Error 3021 (Hy000): Unknown Error 3021

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

TwoPunch created at Nov. 24, 2021, 2:26 p.m.

Error 1820 (Hy000): Unknown Error 1820

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

TwoPunch created at Nov. 17, 2021, 1:24 p.m.

Row Size Too Large. The Maximum Row Size For The Used Table Type, Not Counting Blobs, Is 65535. You Have To Change Some Columns To Text Or Blobs

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

TwoPunch created at Nov. 16, 2021, 2:50 p.m.

Hive Connection Error While Processing Statement: Failed: Execution Error

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

TwoPunch created at Nov. 14, 2021, 11:21 a.m.

Sql Exception Error: Method Querytotal Execution Error Of Sql

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

TwoPunch created at Nov. 14, 2021, 11:16 a.m.

Mysql Error Message Can’T Find Error-Message File

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

TwoPunch created at Nov. 12, 2021, 8:06 a.m.

The Master-Slave Connection Is Disconnected: Error Reading Packet From Server: Lost Connection To Mysql Server During Query (Server_Errno=20131)

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

TwoPunch created at Nov. 10, 2021, 1:36 p.m.

Pyenv 2.7 Environment To Install Mysql-Python Error

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

TwoPunch created at Nov. 10, 2021, 1:21 p.m.

Mysql: Error 1045 (28000): Unknown Error 1045

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

TwoPunch created at Nov. 9, 2021, 7:23 p.m.

Error 1064 (42000): You Have An Error In Your Sql Syntax;

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

TwoPunch created at Nov. 9, 2021, 7:21 p.m.

Mha High Availability: Masterha_Check_Repl Error Summary

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

TwoPunch created at Nov. 8, 2021, 9:05 p.m.

Detailed Explanation Of Mysql Error1118 Error Report

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

TwoPunch created at Oct. 28, 2021, 3:25 p.m.

I Encountered The Following Error When Installing The Tokudb Engine: Error: Percona Server Is Not Running With Jemalloc

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

TwoPunch created at Oct. 27, 2021, 1:05 p.m.

Mysql Server Power Off Got Fatal Error 1236

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

TwoPunch created at Oct. 20, 2021, 4:55 p.m.

Docker-Error Reported After Running Mysql Container: [Error] Innodb: Redo Log File ‘./Ib_Logfile0’ Exists _

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

TwoPunch created at Oct. 18, 2021, 9:55 p.m.

Docker-Error After Running Mysql Container: [Error] --Initialize Specified But The Data Directory Has Files In It. Aborting.

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

TwoPunch created at Oct. 18, 2021, 9:50 p.m.

How To Solve Mysql Error: Error 1045 (28000)

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

TwoPunch created at Oct. 18, 2021, 9:37 p.m.

Error Querying Database. Cause: Java.Sql.Sqlsyntaxerrorexception: Table 'Activiti_Dev.Act_Ge_Property' Doesn't Exist

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

TwoPunch created at Oct. 17, 2021, 10:15 p.m.

2061:Authentication Plugin 'Caching_Sha2_Password' Reported Error:Authentication Require Secure Connection

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

TwoPunch created at Oct. 17, 2021, 1:28 p.m.

Error 1045 (28000): Access Denied For User 'Root'@'Localhost' (Using Password: Yes

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

TwoPunch created at Oct. 7, 2021, 12:08 p.m.

Error: Could Not Read Entry At Offset 946675767: Error In Log Format Or Read Error

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

doporos created at Oct. 1, 2021, 12:06 p.m.

Execution Error Sql_Error_Info: Near “.“: Syntax Error

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

doporos created at Sept. 26, 2021, 9:53 a.m.

64-Bit Windows10, Mysql8.0.13 Reset Password (Forgot Password Or Unable To Log In)

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

doporos created at Sept. 17, 2021, 5:04 p.m.

Don't Understand Redis? After Reading This Story, You Will Understand!

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

doporos created at Sept. 17, 2021, 4:49 p.m.

Mysql Error 1062 (23000): Duplicate Entry ‘%-Root‘ For Key ‘Primary‘

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

doporos created at Sept. 16, 2021, 3:47 p.m.

Differences And Differences Between Inner Join And Outer Join Query Scenarios In Mysql Query

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

doporos created at Sept. 15, 2021, 3:41 p.m.

Navicat: Unknown Error 1130,Unknown Error 1045

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

doporos created at Sept. 13, 2021, 4:26 p.m.

Mysql Creates Auto-Increasing Sequence

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

doporos created at Sept. 12, 2021, 3:25 p.m.
doporos created at Sept. 8, 2021, 2:17 p.m.

Windows Mysql: Error 1045 (28000): Access Denied For User 'Odbc'@'Localhost' (Using Password: No)

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

doporos created at Sept. 4, 2021, 3:16 p.m.

Mysql5.6 Error: Error 1709 (Hy000): Index Column Size Too Large. The Maximum Column Size Is 767 Bytes.

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

doporos created at Sept. 3, 2021, 2:16 p.m.

Error 1728 (Hy000): Cannot Load From Mysql.Procs_Priv. The Table Is Probably Corrupted

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

doporos created at Sept. 1, 2021, 10:22 p.m.

[App Service For Linux(Function) ] Python Modulenotfounderror: No Module Named 'Mysqldb'

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

doporos created at Aug. 27, 2021, 3:04 p.m.

Mysql Workbench Import Error Code: 2013. Lost Connection To Mysql Server During Query

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

doporos created at Aug. 24, 2021, 12:29 a.m.

Error Setting Driver On Unpooleddatasource. Cause: Java.Lang.Classnotfoundexception: Cannot Find Class: Com.Mysql.Cj.Jdbc.Driver

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

doporos created at Aug. 23, 2021, 2:42 p.m.

Error 1449 (Hy000): The User Specified As A Definer ('Mysql.Infoschema'@'Localhost') Does Not Exist

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

doporos created at Aug. 23, 2021, 1:18 p.m.

Mysql 5.7 2003 Cant Connect To Mysql Server On 10061 Unknown Error

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

doporos created at Aug. 23, 2021, 12:59 p.m.

Mysql Reports Error 1615 (Hy000): Prepared Statement Needs To Be Re-Prepared

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

doporos created at Aug. 23, 2021, 12:52 p.m.

Error When Adding Data Into Mybatis: Error: Field * Doesn’T Have A Default Value

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

doporos created at Aug. 19, 2021, 1:18 p.m.

[Err] 1055 - Expression #1 Of Order By Clause Is Not In Group By Clause And Contains Nonaggregate

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

doporos created at Aug. 19, 2021, 7:27 a.m.
doporos created at Aug. 17, 2021, 1:24 p.m.

[Error] [Fatal] Innodb: Semaphore Wait Has Lasted > 600 Seconds

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

doporos created at Aug. 16, 2021, 1:11 p.m.

Mysql Query Information_Schema.Columns Error

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

doporos created at Aug. 13, 2021, 4:11 p.m.

Error++:Communications Link Failure,The Last Packet Successfully Received From The Server Was *** Millisecon

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

doporos created at Aug. 6, 2021, 9:39 p.m.

Export Mysql Query Data To Csv File

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

doporos created at Aug. 5, 2021, 1:56 p.m.

Mysql Clears The Data Of The Specified Table Under The Specified Database And Retains The Table Structure

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

robot18 created at July 28, 2021, 11:26 p.m.

How To Check The Space Occupied By A Table (Table) In Mysql

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

robot18 created at July 27, 2021, 1:31 p.m.

Mysql Group Query And Count The Sql Statements Greater Than A Certain Value

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

robot18 created at July 27, 2021, 1:27 p.m.

What Is The .Frm.Ibd File In Ubuntu Mysql

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

robot18 created at July 27, 2021, 1:25 p.m.

Ubuntu Reinstall Mysql And Restore Data Through .Frm.Ibd

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

robot18 created at July 27, 2021, 1:24 p.m.

Ubuntu Mysql5.7 Startup Prompt Error: /Var/Run/Mysqld/Mysqld.Sock

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

robot18 created at July 27, 2021, 1:21 p.m.

Mysql Error Errcode: 13 "Permission Denied"

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

robot18 created at July 27, 2021, 1:19 p.m.

Install And Completely Delete Mysql5.7 Under Ubuntu16.04

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

robot18 created at July 27, 2021, 1:17 p.m.

Mysql:Error Code 1235,This Version Of Mysql Doesn't Yet Support 'Limit & In/All/Any/Some Subquery'

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

robot18 created at July 27, 2021, 1:11 p.m.

Django.Db.Utils.Internalerror: (1153, "Got A Packet Bigger Than 'Max_Allowed_Packet' Bytes")

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

robot18 created at July 27, 2021, 1:07 p.m.

Pymysql Batch Data Insertation

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

robot18 created at July 27, 2021, 12:54 p.m.

Delete Duplicate Data And Only Keep One In Mysql

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

robot18 created at July 27, 2021, 11:29 a.m.
robot18 created at July 27, 2021, 11:24 a.m.

How To Use The Command To View The Current Mysql Version

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

robot18 created at July 27, 2021, 11:20 a.m.

Mysql Sets The Default Value'collation_Connection'

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

robot18 created at July 27, 2021, 11:17 a.m.

What Is The Difference Between Mysql Count(1) And Count(*)

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

robot18 created at July 27, 2021, 11:12 a.m.

Sql: How To Query Data In A Certain Time Range

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

doporos created at July 27, 2021, 11:02 a.m.

How To Reset The Auto-Increment Of Id Auto_Increment In Mysql?

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

robot18 created at July 26, 2021, 11:48 p.m.

Mysql How To Get The Latest Data/Last Data In The Group (Group By)

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

robot18 created at July 26, 2021, 10:56 p.m.

Optimization/Solution For Problem That Django Pagination Extraction Speed Is Too Slow

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

robot18 created at July 17, 2021, 4:15 p.m.

Django Model Layer (Database) Connection Processing Logic

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

robot18 created at July 17, 2021, 10:53 a.m.

Django Counts The Number Of Articles By Year And Month, Optimizes Sql Statements And Increases The Speed By 30 Times

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

robot18 created at July 17, 2021, 4:27 a.m.

How To Get Equivalent Sql Statement Corresponding To Django Orm

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

robot18 created at July 16, 2021, 5:36 p.m.

The Difference Between Django Null=True And Blank=True

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

robot18 created at July 16, 2021, 4:41 p.m.

Django.Core.Exceptions.Improperlyconfigured: Mysqlclient 1.4.0 Or Newer Is Required; You Have 0.10.1.

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

robot18 created at July 16, 2021, 2:52 p.m.

Django: How To Uses Bulk_Create (Batch Creation) To Get The Id After Successful Creation

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

robot18 created at July 16, 2021, 7:56 a.m.