1. 控制台连接MySQL
mysql -uroot -proot
2. 创建用户
CREATE USER 'mysql.infoschema'@'localhost' IDENTIFIED BY 'password';
3. 赋权
GRANT SELECT ON *.* TO `mysql.infoschema`@`localhost`;
4. 完工。
1. 控制台连接MySQL
mysql -uroot -proot
2. 创建用户
CREATE USER 'mysql.infoschema'@'localhost' IDENTIFIED BY 'password';
3. 赋权
GRANT SELECT ON *.* TO `mysql.infoschema`@`localhost`;
4. 完工。