欧美97色伦欧美一区二区日韩,国产福利片在线观看,freexxx性欧美vide0高清,西西亚洲,日本欧美国产精品第一页久久,成人18免费软件

當前位置： 維易PHP培訓學院 > MYSQL教程 > 內容正文

Mysql學習mysql 添加用戶并為用戶授權

作者：VEPHP   時間 2017-09-27

《Mysql學習mysql 添加用戶并為用戶授權》要點：
本文介紹了Mysql學習mysql 添加用戶并為用戶授權，希望對您有用。如果有疑問，可以聯(lián)系我們。

導讀：mysql中的所有用戶都在mysql的mysql數(shù)據(jù)庫user表中,因此,對mysql用戶的管理也就是對user表的管理.首先,以管理員身份登錄到mysql. mysql...

mysql中的所有用戶都在mysql的mysql數(shù)據(jù)庫user表中,因此,對mysql用戶的管理也就是對user表的管理.MYSQL實例

首先,以管理員身份登錄到mysql.
?MYSQL實例

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

然后,查看用戶表mysql.userMYSQL實例

1,查看下user表結構
?MYSQL實例

mysql>> use mysql;
mysql>> show tables;
+---------------------------+
| Tables_in_mysql?????????? |
+---------------------------+
| columns_priv????????????? |
| db??????????????????????? |
| event???????????????????? |
| func????????????????????? |
| general_log?????????????? |
| help_category???????????? |
| help_keyword????????????? |
| help_relation???????????? |
| help_topic??????????????? |
| host????????????????????? |
| ndb_binlog_index????????? |
| plugin??????????????????? |
| proc????????????????????? |
| procs_priv??????????????? |
| servers?????????????????? |
| slow_log????????????????? |
| tables_priv?????????????? |
| time_zone???????????????? |
| time_zone_leap_second???? |
| time_zone_name??????????? |
| time_zone_transition????? |
| time_zone_transition_type |
| user????????????????????? |
+---------------------------+
?

其中db就是針對用戶和數(shù)據(jù)庫的對應數(shù)據(jù).
?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培訓學院每天發(fā)布《Mysql學習mysql 添加用戶并為用戶授權》等實戰(zhàn)技能，PHP、MYSQL、LINUX、APP、JS,CSS全面培養(yǎng)人才。

轉載請注明本頁網(wǎng)址：
http://www.snjht.com/jiaocheng/12738.html


    標簽：