mysql 操作

全局查看某表的字段

　　SELECT * FROM information_schema.`COLUMNS` WHERE COLUMN_NAME = "XXX";

 

全局查看某表

　　SELECT * FROM information_schema.`TABLES` WHERE TABLE_NAME = "XXX";

 

建表：

　　设置字符集编码  utf8mb4   所有字段NOT NULL

 

 

数据库锁定时（db-lock）：

---->mysql -u root -p
---->123456
---->flush hosts;

 

 

 

错误提示caching_sha2_password

use mysql;

mysql> SELECT Host, User, plugin from user;

mysql> ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';

mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';