MySQL

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: ```plaintext …

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 ```plaintext docker …

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 ```plaintext docker…

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

How To Solve Mysql Error: Error 1045 (28000)

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

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: ```plaintext mysql…

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

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

```plaintext /etc/init.d/mysqld stop mysqld_safe --user=mysql --skip-grant-tables --skip-networki…

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. ```plaintext update salaries …

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: ```plaintext unknown error 1130 ```…

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

Mysql Creates Auto-Increasing Sequence

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

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  ```plainte…

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 ```plaintext mysql> CREATE TABLE permissions ( -> role varchar(50) NO…

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 ```plaintext mysql> CREATE USER 'mysql.infoschema'@'localhost' IDENTIFIED BY 'passw…

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 ```plaintext CREATE TABLE `apply_log` ( `id` int(10) NOT NULL AUTO_INCREMENT COMMEN…

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: ```plaintext [Err] 1055 - Expression #1 of ORDER BY claus…

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: ```plaintext DTS-1020013 Get db tables error,err m…

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`: ```plaintext # mysql  -h  xx.xx.xx.xx  -u …

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 ```plaintext select TABLE_SCHEMA, …

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 ```plaintext SELECT name,count(*) FROM `test` G…

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: ```plaint…

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 ```plaintext mysql start ERROR 2002 (HY000): Can't connec…

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 ```plaintext #The following commands are executed in sequence …

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: ```plaintext [Err] 1235 - Th…

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: ```plaintext django.db.utils.InternalError: (1153, "Got…

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 ```plaintext select version(); ``` …

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

Mysql Sets The Default Value'collation_Connection'

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

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 ```plaintext SEL…

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

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

## solution ```plaintext ALTER TABLE tablename AUTO_INCREMENT = 1 ``` > **Note**: For InnoD…

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: ```plaintext Id Name Ot…

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 ```plaintext django.core.e…

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.

Incorrect String Value: ‘\Xf0\X9f\X8c\Xb8’ For Column'xxx' At Row 1, Mysql Storage Of Unusual Characters/Emoticons Error

Solve `Incorrect string value: ‘\xF0\x9F\x8C\xB8’ for column'xxx' at row 1` error caused by storing…

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

Solution For Python Django.Db.Utils.Interfaceerror: (0, '')

## error message ```plaintext django.db.utils.InterfaceError: (0, '') ``` ## Reasons for da…

robot18 created at July 15, 2021, 3:56 p.m.

Production-Error--The-Resource-Owner-Or-Authorization-Server

## description The Laravel log file reports a lot of errors:  ```plaintext production.ERROR:…

robot18 created at July 11, 2021, 6:10 a.m.

Mysqldump Report Error-Error 2013 Lost Connection To Mysql Server

## Specific error information error message: ```plaintext mysqldump: Error 2013: Lost connec…

robot18 created at July 7, 2021, 6:49 a.m.

Mysql [Error] Mysql Establishment Of Connection

## description What should I do when MySQL reports an error `[Error] MySQL establishment of conn…

robot18 created at July 6, 2021, 5:29 p.m.

Mysql:[Err] 1064 You Have An Error In Your Sql Syntax

## description Problems with using MySql to build tables When using Navicat Premium to run sq…

robot18 created at July 6, 2021, 5:13 p.m.

Error: Please Install Mysql2 Package Manually

## description error message: ```plaintext ERROR: Please install mysql2 package manually ``…

robot18 created at July 6, 2021, 4:04 p.m.

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

## Connect Mysql with Python ```plaintext import mysql.connector conn = mysql.connector.connec…

robot18 created at July 6, 2021, 6:01 a.m.

Laravel 5.4 Migrated Error: Specified Key Was Too Long Error

## description Laravel 5.4 uses utf8mb4 character encoding by default instead of the previous ut…

robot18 created at July 6, 2021, 5:49 a.m.

Sql Injection Violation, Syntax Error:Token Lparen

## description Use druid to query MySql with as and report the following error: > Error query…

robot18 created at July 5, 2021, 3:05 p.m.

Mysql Error 1093 (Hy000)

## error message ```plaintext mysql ERROR 1093 (HY000): You can't specify target table 'table_n…

robot18 created at July 5, 2021, 2:29 p.m.

Mysql Error 1449 (Hy000)

## description error message ```plaintext ERROR 1449 (HY000): The user specified as a define…

robot18 created at July 5, 2021, 2:15 p.m.

Mysql Error 1040: Too Many Connections

As the title, this chapter mainly talks about some handling experience when the server appears `ERR…

robot18 created at July 5, 2021, 9:36 a.m.

Laravel : Syntax Error Or Access Violation: 1055 Error

## Error message ```plaintext public function uploads($count) { $items = \DB::tab…

robot18 created at July 3, 2021, 6:03 p.m.

Mysql-How Much Disk Space Does 10 Million Pieces Of Data Take Up?

## calculation Suppose there is a table called `table_name`; there are four fields: ```plaint…

robot18 created at July 3, 2021, 8:33 a.m.

You Have An Error In Your Sql Syntax Check The Manual That Corresponds To Your Mysql

Recently get a project, there is a demand that requires PC to read information and write to the dat…

panda created at June 26, 2021, 7:17 a.m.