如何将源数据库的用户与权限导出，再导入到目标数据库-凯发k8国际娱乐官网入口

mysql -h 'host' -u 'user' -p -n $@ -e "select concat('show grants for ''', user, '''@''', host, ''';') as query from mysql.user" > /tmp/users.sql

其中的'host'替换为源数据库的访问ip地址，'user' 替换为源数据库的用户名。

mysql -h 'host' -u 'user' -p -n $@ -e "source /tmp/users.sql" > /tmp/grants.sql

sed -i 's/$/;/g' /tmp/grants.sql

其中的'host'替换为源数据库的访问ip地址，'user' 替换为源数据库的用户名。

-- grants for root@%
grant all privileges on *.* to 'root'@'%';
-- grants for testt@%
grant select, insert, update, delete on *.* to 'testt'@'%';
-- grants for debian-sys-maint@localhost 
grant all privileges on *.* to 'debian-sys-maint'@'localhost' with grant option;
-- grants for mysql.session@localhost
grant super on *.* to 'mysql.session'@'localhost'; 
grant select on `performance_schema`.* to 'mysql.session'@'localhost';
grant select on `mysql`.`user` to 'mysql.session'@'localhost';
-- grants for mysql.sys@localhost
grant usage on *.* to 'mysql.sys'@'localhost'; 
grant trigger on `sys`.* to 'mysql.sys'@'localhost'; 
grant select on `sys`.`sys_config` to 'mysql.sys'@'localhost';
-- grants for root@localhost
grant all privileges on *.* to 'root'@'localhost' with grant option; 
grant proxy on ''@'' to 'root'@'localhost' with grant option;