MySQL登錄的配置

這篇文章主要介紹“MySQL登錄的配置”，在日常操作中，相信很多人在MySQL登錄的配置問題上存在疑惑，小編查閱了各式資料，整理出簡單好用的操作方法，希望對大家解答”MySQL登錄的配置”的疑惑有所幫助！接下來，請跟著小編一起來學習吧！

GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY 'abc';
 
> select user, host, password from mysql.user;
 
+------+-----------+------------------+
 
| user | host      | password         |
 
+------+-----------+------------------+
 
| root | localhost | 7b49a39922703c30 |
 
| root | wengdev01 |                  |
 
| root | 127.0.0.1 |                  |
 
|      | localhost |                  |
 
|      | wengdev01 |                  |
 
| root | %         | 7b49a39922703c30 |
 
+------+-----------+------------------+
 
6 rows in set (0.00 sec)
 
 
 DELETE FROM mysql.user WHERE Host <> '%' and user = 'root';
 
 
mysql> select user, host, password from mysql.user;
 
+------+------+------------------+
 
| user | host | password         |
 
+------+------+------------------+
 
| root | %    | 7b49a39922703c30 |
 
+------+------+------------------+
 
1 row in set (0.00 sec)
 
mysql> FLUSH PRIVILEGES;
 
Query OK, 0 rows affected (0.00 sec)
 
# 或者delete from mysql.user where password='' or user='';update mysql.user set host='%' where user='root';GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY 'abc';FLUSH PRIVILEGES;
 
新建一個用戶，并grant除administration之外的所有權限。
GRANT CREATE,DROP,GRANT OPTION,REFERENCES,EVENT,ALTER,DELETE,INDEX,INSERT,SELECT,UPDATE,LOCK TABLES,TRIGGER,CREATE TEMPORARY TABLES,CREATE VIEW,SHOW VIEW ON *.* TO cs@"%" IDENTIFIED BY 'abc';

到此，關于“MySQL登錄的配置”的學習就結束了，希望能夠解決大家的疑惑。理論與實踐的搭配能更好的幫助大家學習，快去試試吧！若想繼續學習更多相關知識，請繼續關注億速云網站，小編會繼續努力為大家帶來更多實用的文章！