关于mysql8.0以上的权限及其外部连接报错常用语句

myzzb

已于 2023-06-20 23:45:20 修改

阅读量275

点赞数

文章标签：数据库 mysql

于 2023-06-20 23:41:16 首次发布

本文链接：https://blog.youkuaiyun.com/weixin_52810349/article/details/131317767

版权

该文详细列出了对MySQL数据库进行用户管理的命令，包括创建用户、赋予权限、修改密码策略以及flushprivileges操作。重点在于root和root1用户的设置，赋予了所有权限并设定了登录认证方式。同时，调整了validate_password策略以降低密码复杂度要求。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

grant system_user on *.* to 'root';
grant all privileges on *.* to root@'%' ;
GRANT ALL ON *.* TO root1@'%' IDENTIFIED BY '12345678Aa!' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO 'root1'@'%'IDENTIFIED BY '12345678Aa!' WITH GRANT OPTION;

use mysql;
SELECT user, host, plugin from mysql.user;
select user,host,grant_priv from mysql.user;
set global validate_password.policy=LOW;
flush privileges;
ALTER USER 'debian-sys-maint'@'localhost' IDENTIFIED BY '123456';
SHOW VARIABLES LIKE 'validate_password%';
set global validate_password.length=4;

create user root1@'%' identified by '12345678Aa!';
grant all privileges on *.* to root1@'%' with grant option;
flush privileges;
ALTER USER 'root1'@'%' IDENTIFIED WITH mysql_native_password BY '12345678Aa!';