本文提供了一段MySQL数据库脚本，用于将一个指定用户（如root）的所有权限复制到一个新的用户上，并设置新的用户名和密码。
SET @NEWUSER='master';
SET @NEWPASS='password';
SELECT @FF:=GROUP_CONCAT(column_name) from information_schema.columns where TABLE_NAME='User' and COLUMN_NAME not in('Host','User','Password');
set @SQL=CONCAT('insert into mysql.user select \'%\',\'',@NEWUSER,'\',PASSWORD(\'',@NEWPASS,'\'),',@FF,' from mysql.user where user=\'root\';') ;
PREPARE stmt from @SQL;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;
flush privileges;
select * from mysql.user;
SET @NEWPASS='password';
SELECT @FF:=GROUP_CONCAT(column_name) from information_schema.columns where TABLE_NAME='User' and COLUMN_NAME not in('Host','User','Password');
set @SQL=CONCAT('insert into mysql.user select \'%\',\'',@NEWUSER,'\',PASSWORD(\'',@NEWPASS,'\'),',@FF,' from mysql.user where user=\'root\';') ;
PREPARE stmt from @SQL;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;
flush privileges;
select * from mysql.user;
扫一扫
679
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
