Mysql学习mysql 添加用户并为用户授权

发布时间：2020-12-12 02:39:20 所属栏目：MySql教程来源：网络整理

导读：《Mysql学习mysql 添加用户并为用户授权》要点：本文介绍了Mysql学习mysql 添加用户并为用户授权，希望对您有用。如果有疑问，可以联系我们。导读：mysql中的所有用户都在mysql的mysql数据库user表中,因此,对mysql用户的管理也就是对user表的管理.首先,以

《Mysql学习mysql 添加用户并为用户授权》要点：
本文介绍了Mysql学习mysql 添加用户并为用户授权，希望对您有用。如果有疑问，可以联系我们。

导读：mysql中的所有用户都在mysql的mysql数据库user表中,因此,对mysql用户的管理也就是对user表的管理.首先,以管理员身份登录到mysql. mysql...

mysql中的所有用户都在mysql的mysql数据库user表中,对mysql用户的管理也就是对user表的管理.MYSQL实例

首先,以管理员身份登录到mysql.
?MYSQL实例

mysql>> mysql -u root -p
Enter password:*******

然后,查看用户表mysql.userMYSQL实例

1,查看下user表结构
?MYSQL实例

其中db就是针对用户和数据库的对应数据.
?MYSQL实例

mysql>> describe db;
+-----------------------+---------------+------+-----+---------+-------+
| Field???????????????? | Type????????? | Null | Key | Default | Extra |
+-----------------------+---------------+------+-----+---------+-------+
| Host????????????????? | char(60)????? | NO?? | PRI |???????? |?????? |
| Db??????????????????? | char(64)????? | NO?? | PRI |???????? |?????? |
| User????????????????? | char(16)????? | NO?? | PRI |???????? |?????? |
| Select_priv?????????? | enum('N','Y') | NO?? |???? | N?????? |?????? |
| Insert_priv?????????? | enum('N','Y') | NO?? |???? | N?????? |?????? |
| Update_priv?????????? | enum('N','Y') | NO?? |???? | N?????? |?????? |
| Delete_priv?????????? | enum('N','Y') | NO?? |???? | N?????? |?????? |
| Create_priv?????????? | enum('N','Y') | NO?? |???? | N?????? |?????? |
| Drop_priv???????????? | enum('N','Y') | NO?? |???? | N?????? |?????? |
| Grant_priv??????????? | enum('N','Y') | NO?? |???? | N?????? |?????? |
| References_priv?????? | enum('N','Y') | NO?? |???? | N?????? |?????? |
| Index_priv??????????? | enum('N','Y') | NO?? |???? | N?????? |?????? |
| Alter_priv??????????? | enum('N','Y') | NO?? |???? | N?????? |?????? |
| Create_tmp_table_priv | enum('N','Y') | NO?? |???? | N?????? |?????? |
| Lock_tables_priv????? | enum('N','Y') | NO?? |???? | N?????? |?????? |
| Create_view_priv????? | enum('N','Y') | NO?? |???? | N?????? |?????? |
| Show_view_priv??????? | enum('N','Y') | NO?? |???? | N?????? |?????? |
| Create_routine_priv?? | enum('N','Y') | NO?? |???? | N?????? |?????? |
| Alter_routine_priv??? | enum('N','Y') | NO?? |???? | N?????? |?????? |
| Execute_priv????????? | enum('N','Y') | NO?? |???? | N?????? |?????? |
| Event_priv??????????? | enum('N','Y') | NO?? |???? | N?????? |?????? |
| Trigger_priv????????? | enum('N','Y') | NO?? |???? | N?????? |?????? |
+-----------------------+---------------+------+-----+---------+-------+
shell>> describe mysql.user;
+-----------------------+-----------------------------------+------+-----+---------+-------+
| Host????????????????????? | char(60)????????????????????????? | NO?? | PRI |???????? |?????? |
| User????????????????????? | char(16)????????????????????????? | NO?? | PRI |???????? |?????? |
| Password????????????? | char(41)????????????????????????? | NO?? |???? |???????? |?????? |
| Select_priv?????????? | enum('N','Y')???????????????????? | NO?? |???? | N?????? |?????? |
| Insert_priv?????????? | enum('N','Y')???????????????????? | NO?? |???? | N?????? |?????? |
| Update_priv?????????? | enum('N','Y')???????????????????? | NO?? |???? | N?????? |?????? |
| Delete_priv?????????? | enum('N','Y')???????????????????? | NO?? |???? | N?????? |?????? |
| Create_priv?????????? | enum('N','Y')???????????????????? | NO?? |???? | N?????? |?????? |
| Drop_priv???????????? | enum('N','Y')???????????????????? | NO?? |???? | N?????? |?????? |
| Reload_priv?????????? | enum('N','Y')???????????????????? | NO?? |???? | N?????? |?????? |
| Shutdown_priv???????? | enum('N','Y')???????????????????? | NO?? |???? | N?????? |?????? |
| Process_priv????????? | enum('N','Y')???????????????????? | NO?? |???? | N?????? |?????? |
| File_priv???????????? | enum('N','Y')???????????????????? | NO?? |???? | N?????? |?????? |
| Grant_priv??????????? | enum('N','Y')???????????????????? | NO?? |???? | N?????? |?????? |
| References_priv?????? | enum('N','Y')???????????????????? | NO?? |???? | N?????? |?????? |
| Index_priv??????????? | enum('N','Y')???????????????????? | NO?? |???? | N?????? |?????? |
| Alter_priv??????????? | enum('N','Y')???????????????????? | NO?? |???? | N?????? |?????? |
| Show_db_priv????????? | enum('N','Y')???????????????????? | NO?? |???? | N?????? |?????? |
| Super_priv??????????? | enum('N','Y')???????????????????? | NO?? |???? | N?????? |?????? |
| Create_tmp_table_priv | enum('N','Y')???????????????????? | NO?? |???? | N?????? |?????? |
| Lock_tables_priv????? | enum('N','Y')???????????????????? | NO?? |???? | N?????? |?????? |
| Execute_priv????????? | enum('N','Y')???????????????????? | NO?? |???? | N?????? |?????? |
| Repl_slave_priv?????? | enum('N','Y')???????????????????? | NO?? |???? | N?????? |?????? |
| Repl_client_priv????? | enum('N','Y')???????????????????? | NO?? |???? | N?????? |?????? |
| Create_view_priv????? | enum('N','Y')???????????????????? | NO?? |???? | N?????? |?????? |
| Show_view_priv??????? | enum('N','Y')???????????????????? | NO?? |???? | N?????? |?????? |
| Create_routine_priv?? | enum('N','Y')???????????????????? | NO?? |???? | N?????? |?????? |
| Alter_routine_priv??? | enum('N','Y')???????????????????? | NO?? |???? | N?????? |?????? |
| Create_user_priv????? | enum('N','Y')???????????????????? | NO?? |???? | N?????? |?????? |
| Event_priv??????????? | enum('N','Y')???????????????????? | NO?? |???? | N?????? |?????? |
| Trigger_priv????????? | enum('N','Y')???????????????????? | NO?? |???? | N?????? |?????? |
| ssl_type????????????? | enum('','ANY','X509','SPECIFIED') | NO?? |???? |???????? |?????? |
| ssl_cipher??????????? | blob?????????????????????????????? | NO?? |???? | NULL??? |?????? |
| x509_issuer?????????? | blob????????????????????????????? | NO?? |???? | NULL??? |?????? |
| x509_subject????????? | blob????????????????????????????? | NO?? |???? | NULL??? |?????? |
| max_questions???????? | int(11) unsigned????????????????? | NO?? |???? | 0?????? |?????? |
| max_updates?????????? | int(11) unsigned????????????????? | NO?? |???? | 0?????? |?????? |
| max_connections?????? | int(11) unsigned????????????????? | NO?? |???? | 0?????? |?????? |
| max_user_connections? | int(11) unsigned????????????????? | NO?? |???? | 0?????? |?????? |
+-----------------------+-----------------------------------+------+-----+---------+-------+

下面开始添加用户并授权.MYSQL实例

1,添加一个用户：
?MYSQL实例

mysql>> CREATE USER 'test_1' IDENTIFIED BY PASSWORD 'test123';

2,进行mysql用户授权
?MYSQL实例

mysql>> GRANT ALL PRIVILEGES ON *.* TO 'test_1'@'localhost'
??? ->??? IDENTIFIED BY 'some_pass' WITH GRANT OPTION;

编程之家PHP培训学院每天发布《Mysql学习mysql 添加用户并为用户授权》等实战技能，PHP、MYSQL、LINUX、APP、JS,CSS全面培养人才。

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!