Shulou(Shulou.com)06/01 Report--

Export

[root@db01 tmp] # mysql-B-N-uroot-p-e "SELECT CONCAT ('\', user,'\'@\', host,'\') FROM user WHERE user! = 'debian-sys-maint' AND user! =' root' AND user! =''" mysql > / tmp/mysql_all_users.txt

[root@db01 tmp] # cat / tmp/mysql_all_users.txt

[root@db01 tmp] # cd / tmp/

[root@db01 tmp] # while read line; do mysql-B-N-uroot-predhat-e "SHOW GRANTS FOR $line"; done

Mysql_all_users_sql.sql

[root@db01 tmp] # cat mysql_all_users_sql.sql

[root@db01 tmp] # sed-I's mysql_all_users_sql.sql

[root@db01 tmp] # cat mysql_all_users_sql.sql

[root@db01 tmp] # echo "flush privileges;" > > mysql_all_users_sql.sql

Import

[root@db02 tmp] # mysql-u root-p < mysql_all_users_sql.sql

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.