Shulou(Shulou.com)05/31 Report--

This article mainly introduces "how to solve the problem of ERROR 1054 (42S22) error report in MySQL". In daily operation, I believe many people have doubts about how to solve the problem of error report of ERROR 1054 (42S22) in MySQL. Xiaobian consulted all kinds of data and sorted out simple and easy-to-use operation methods. I hope it will be helpful for you to answer the doubt of "how to solve the error problem of ERROR 1054 (42S22) in MySQL". Next, please follow the editor to study!

Error adding user Times

Mysql > grant all privileges on *. * to 'aaa'@'%' identified by' aaa123'

ERROR 1054 (42S22): Unknown column 'plugin' in' mysql.user'

When upgrading the mysql database, the mysql.user table was not upgraded, resulting in missing fields

Modify the mysql.user table in the following ways

Mysql > use mysql

Reading table information for completion of table and column names

You can turn off this feature to get a quicker startup with-A

Database changed

Mysql > ALTER TABLE user ADD Create_tablespace_priv ENUM ('Nintendo Magazine Y') NOT NULL DEFAULT' N' AFTER Trigger_priv

Query OK, 14 rows affected (0.08 sec)

Records: 14 Duplicates: 0 Warnings: 0

Mysql > ALTER TABLE user ADD plugin CHAR (64) NULL AFTER max_user_connections

Query OK, 14 rows affected (0.09 sec)

Records: 14 Duplicates: 0 Warnings: 0

Mysql > ALTER TABLE user ADD authentication_string TEXT NULL DEFAULT NULL AFTER plugin

Query OK, 14 rows affected (0.05sec)

Records: 14 Duplicates: 0 Warnings: 0

Mysql > ALTER TABLE user ADD password_expired ENUM ('Nintendo Magazine Y') NOT NULL DEFAULT' N' AFTER authentication_string

Query OK, 14 rows affected (0.04 sec)

Records: 14 Duplicates: 0 Warnings: 0

Mysql > grant all privileges on *. * to 'aaa'@'%' identified by' aaa123'

Query OK, 0 rows affected (0.00 sec)

At this point, the study on "how to solve the problem of ERROR 1054 (42S22) error reporting in MySQL" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

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.