mysql

SELECT * FROM INFORMATION_SCHEMA.INNODB_trx;

• Access denied for user ‘root‘@’%’ to database ‘mysql’
  https://www.cnblogs.com/index01/articles/12760968.html

• https://blog.csdn.net/elizabethxxy/article/details/110124105

# 登录
grant all privileges on *.* to 'root'@'localhost' identified by 'root' with grant option;

# 数据库访问权限
GRANT ALL PRIVILEGES ON *.* TO 'admin'@'localhost' WITH GRANT OPTION;

• Mysql只有information_schema信息数据库
  https://blog.csdn.net/weixin_30472035/article/details/99398099

https://blog.csdn.net/weixin_30958737/article/details/113275571

https://blog.csdn.net/m0_52009789/article/details/126161199

https://www.jb51.net/article/255975.htm

https://blog.csdn.net/weixin_39707536/article/details/113206056

mysqld --console --skip-grant-tables --shared-memory


update user set authentication_string='' where user='root'


net stop MySQL80


CREATE USER 'root'@'%' IDENTIFIED BY '123456';

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;#注意刷新权限表

GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION;

flush privileges;

INSERT INTO `user`(`host`, `user`) VALUES ('%', 'root');