授权MySQL root 用户所有权限

VC_Tiger

于 2020-04-20 09:02:35 发布

阅读量8.5k

点赞数 5

文章标签： mysql 数据库

本文链接：https://blog.csdn.net/CS_Tiger/article/details/105626938

版权

本文详细介绍了如何授权MySQL的root用户获得所有权限，包括关键步骤和涉及的命令，确保安全管理和使用数据库。

摘要由CSDN通过智能技术生成

授权MySQL root 用户所有权限

步骤

Microsoft Windows [版本 10.0.18363.720]
(c) 2019 Microsoft Corporation。保留所有权利。

C:\Windows\system32>mysql -u root -p
Enter password: ******
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1015
Server version: 8.0.19 MySQL Community Server - GPL

Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> select user,host,authentication_string from mysql.user;
+------------------+-----------+------------------------------------------------------------------------+
| user             | host      | authentication_string