MYSQL创建与root一样权限用户

1.创建账号

create user backupdb@'localhost' identified by '123456';
#或
create user backupdb@'%' identified by '123456';

2.设置权限

grant usage  on *.* to backupdb@'localhost';
grant all privileges on mysql.* to backupdb@'localhost';
grant all privileges on *.* to backupdb@'localhost' with grant option;
#或
grant usage  on *.* to backupdb@'%';
grant all privileges on mysql.* to backupdb@'%';
grant all privileges on *.* to backupdb@'%' with grant option;

3.如果是高版本数据库需要修改登录验证

ALTER USER 'backupdb'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';
#或
ALTER USER 'backupdb'@'%' IDENTIFIED WITH mysql_native_password BY '123456';

程序员灯塔
转载请注明原文链接：MYSQL创建与root一样权限用户