Why does the mysql password with the special character\ v report an error?

mysql> ALTER USER `db_example`@`%` IDENTIFIED BY "qeW0zdszb\vZjt4o";
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

mysql> ALTER USER `db_example`@`%` IDENTIFIED BY "qeW0zdszb\tZjt4o";
Query OK, 0 rows affected (0.00 sec)

MySQL version: 5.7
two passwords qeW0zdszb\ vZjt4o and qeW0zdszb\ tZjt4o are distinguished only by \ v or \ t

Why do passwords containing \ v report errors? What are the restrictions on setting a password in MySQL?

when using Spring to connect to the database, if the password has \ characters, the configuration also has to escape.

Java spring mysql

May.12,2022

MySQL itself supports some escape characters

Escape Sequence    Character Represented by Sequence
\0    An ASCII NUL (X'00') character
\'    A single quote (') character
\"    A double quote (") character
\b    A backspace character
\n    A newline (linefeed) character
\r    A carriage return character
\t    A tab character
\Z    ASCII 26 (Control+Z); see note following the table
\\    A backslash (\) character
\%    A % character; see note following the table
\_    A _ character; see note following the table

of course, it is turned on well by default, and you can do special handling in programs that do not need to be escaped.
but if you want to turn it off, you can SET sql_mode='NO_BACKSLASH_ESCAPES'; turn off the escape character

\ t is a tab. It seems to me that \ v is not a special character.
I guess: it should be that mysql deciphered the password string when setting the password, so that \ v did not have a corresponding interpretation and reported an error?
for example, if you change it to \\ v to see if you will report an error. And if you do not report an error, do you want to enter two \ or one? if it is one, it means that the password was indeed interpreted when you set it.

Previous: H5 Baidu map how to achieve real-time update of the current location? No need to poll

Next: Gunfight FPS Mini Game, may I ask how to achieve frame synchronization, and the problem of data transmission of bullet firing?

Spring transaction and Mysql transaction
1. Background: mysql transaction isolation level for READ_COMMITTED; data saving using native hibernate; queries using JdpcTempLate; 2. Main question: hibernateJDBCNot_suppport;; 3. Code: 3.1.hibernate: 3.2.JDBC 3.3Jdbcjdbc reasons for asking ...

Java spring mysql

Mar.13,2021
Hibernate generation sql syntax is not compatible with mysql
the original title was "springdata jpa uses @ ElementCollection to report an error " Table doesn t exists ". Later, I patiently read all the error messages and found that the source of the error was that the sql syntax generated by hibernate was inco...

Java spring mysql hibernate

Mar.16,2021
How do I insert data into JoinTable?
Code first: entity class: @Entity @Table(name = "joinTable_a") public class JoinTableA { @Id @GeneratedValue private long id; private String name; @OneToOne @JoinTable(name = "join_a2b", joinColumns = @JoinColumn(n...

Java spring mysql spring-data-jpa

Mar.16,2021
Design a background program, extract a large amount of data according to the rules to generate short messages and send them, how to design to ensure that the short messages do not repeat and the stability of the system?
requirements are as follows: there are one or more databases that hold all kinds of user data, such as contract information, time, amount, and so on. now we are going to develop a background system to regularly extract data from the specified databa...

Java spring mysql

Nov.29,2021
On the user Information data Management of Unified Authentication Service
I didn t want to register repeatedly, but wanted to integrate into a microservice, so I began to search, think, and design, but I encountered a key problem as I walked: where should I put my user data? the reason for this confusion is to consider t...

Java spring mysql programmer

Mar.21,2022
On the user Information data Management of Unified Authentication Service
I didn t want to register repeatedly, but wanted to integrate into a microservice, so I began to search, think, and design, but I encountered a key problem as I walked: where should I put my user data? the reason for this confusion is to consider t...

Java spring mysql programmer

Mar.21,2022
On the user Information data Management of Unified Authentication Service
I didn t want to register repeatedly, but wanted to integrate into a microservice, so I began to search, think, and design, but I encountered a key problem as I walked: where should I put my user data? the reason for this confusion is to consider t...

Java spring mysql programmer

Mar.21,2022
Multiple update funds in a function, each change needs to record the transaction log, is there any way to optimize it?
problem description update funds multiple times in a function, and transaction log needs to be recorded for each change. you need to re-query the changed Amount for each fund change. related codes long amountWX = 100; in...

Java spring mysql

May.07,2022

MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1b38005-2b92f.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1b38005-2b92f.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?