Shulou(Shulou.com)06/01 Report--

MySQL 5.5 can generally change the parameters (the baseline defaults to 1). The warning,note information is recorded in debug mysql.err. If the application connects to the database due to abnormal user password, it can record the message of user connection failure in my.err, and a connection failure alarm will appear if the connection fails many times.

Mysql > show variables like 'log_warnings%'

+-+ +

| | Variable_name | Value |

+-+ +

| | log_warnings | 1 | |

+-+ +

Modification method:

Set global log_warnings=2

There is no user lock status in the official documentation of MySQL version 5.5. Therefore, there is no user to be locked.

The account-locking capability depends on the presence of the account_locked column in the

Mysql.user table. For upgrades to MySQL 5.7.6 and later from older versions, run mysql_upgrade

To ensure that this column exists. For nonupgraded installations that have no account_locked

Column, the server treats all accounts as unlocked, and using the ACCOUNT LOCK or ACCOUNT

UNLOCK clauses produces an error.

Fields with no user lock in the user information of MySQL 5.5A

4. Row

Host: 1

User: root

Password: * 13C230E7E4DDA7CCF4BED86963D2B066390F3E56

Select_priv: Y

Insert_priv: Y

Update_priv: Y

Delete_priv: Y

Create_priv: Y

Drop_priv: Y

Reload_priv: Y

Shutdown_priv: Y

Process_priv: Y

File_priv: Y

Grant_priv: Y

References_priv: Y

Index_priv: Y

Alter_priv: Y

Show_db_priv: Y

Super_priv: Y

Create_tmp_table_priv: Y

Lock_tables_priv: Y

Execute_priv: Y

Repl_slave_priv: Y

Repl_client_priv: Y

Create_view_priv: Y

Show_view_priv: Y

Create_routine_priv: Y

Alter_routine_priv: Y

Create_user_priv: Y

Event_priv: Y

Trigger_priv: Y

Create_tablespace_priv: Y

Ssl_type:

Ssl_cipher:

X509_issuer:

X509_subject:

Max_questions: 0

Max_updates: 0

Max_connections: 0

Max_user_connections: 0

Plugin:

Authentication_string:

4 rows in set (0.00 sec)

Account_locked in MySQL 5.7user information

2. Row

Host:%

User: root

Select_priv: Y

Insert_priv: Y

Update_priv: Y

Delete_priv: Y

Create_priv: Y

Drop_priv: Y

Reload_priv: Y

Shutdown_priv: Y

Process_priv: Y

File_priv: Y

Grant_priv: N

References_priv: Y

Index_priv: Y

Alter_priv: Y

Show_db_priv: Y

Super_priv: Y

Create_tmp_table_priv: Y

Lock_tables_priv: Y

Execute_priv: Y

Repl_slave_priv: Y

Repl_client_priv: Y

Create_view_priv: Y

Show_view_priv: Y

Create_routine_priv: Y

Alter_routine_priv: Y

Create_user_priv: Y

Event_priv: Y

Trigger_priv: Y

Create_tablespace_priv: Y

Ssl_type:

Ssl_cipher:

X509_issuer:

X509_subject:

Max_questions: 0

Max_updates: 0

Max_connections: 0

Max_user_connections: 0

Plugin: mysql_native_password

Authentication_string: * D61994AAB9327E97C4BECC73E497951CFC723C99

Password_expired: N

Password_last_changed: 2018-04-14 22:20:00

Password_lifetime: NULL

Account_locked: N

2 rows in set (0.00 sec)

User lock status can be viewed in the following ways, but only above MySQL 5.7.6

Mysql > show create user 'root'

+- -+

| | CREATE USER for root@% |

+- -+

| | CREATE USER 'root'@'%' IDENTIFIED WITH' mysql_native_password' AS'* D61994AAB9327E97C4BECC73E497951CFC723C99' REQUIRE NONE PASSWORD EXPIRE DEFAULT ACCOUNT UNLOCK |

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.