In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
2025-04-06 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >
Share
Shulou(Shulou.com)06/01 Report--
Editor to share with you the method of mysql to export user rights, I believe that most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!
Mysql method to export user rights: first generate a script for user rights; then generate a permission SQL script; finally, execute the script on the target server with the code [mysql-uname-ppwd. / grants.sql]
2. Generate permission SQL script
[root@HKBO ~] # / exp_grant.sh [root@HKBO ~] # head grants.sql-- Grants for root@127.0.0.1 GRANT ALL PRIVILEGES ON *. * TO 'root'@'127.0.0.1' IDENTIFIED BY PASSWORD' * EB3EA446C759C9DA93F84FCB56430DBEF051A9DD' WITH GRANT OPTION;GRANT ALL PRIVILEGES ON `CNBO0815`. * TO 'root'@'127.0.0.1' WITH GRANT OPTION -- Grants for root@172.16.10.% GRANT ALL PRIVILEGES ON *. * TO 'root'@'172.16.10.%' IDENTIFIED BY PASSWORD' * 6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9;-- Grants for CNBO@192.168.1.% GRANT USAGE ON *. * TO 'CNBO'@'192.168.1.%' IDENTIFIED BY PASSWORD' * ABD91BAD4A3448428563952E281015B237310EA8';. -- Author: Leshami--Blog: http://blog.csdn.net/leshami
3. Execute the script on the target server
The generated script can be executed on the target server.
Mysql-uname-ppwd
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.
Views: 0
*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.