mysql 5.5之后没有了password字段，这样添加一条root用户

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,'\',',@FF,' from mysql.user where user=\'root\';') ;


PREPARE stmt from @SQL;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;
flush privileges;

set @setpass = CONCAT('set password for ', @NEWUSER,' = password(\'',@NEWPASS,'\');');
PREPARE p from @setpass;
EXECUTE p;
DEALLOCATE PREPARE p;

select * from mysql.user;