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

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

Mysql實例MySQL增加用戶與用戶授權(quán)命令舉例

作者：VEPHP   時間 2017-09-27

《Mysql實例MySQL增加用戶與用戶授權(quán)命令舉例》要點：
本文介紹了Mysql實例MySQL增加用戶與用戶授權(quán)命令舉例，希望對您有用。如果有疑問，可以聯(lián)系我們。

導讀：本節(jié)內(nèi)容：在mysql數(shù)據(jù)庫中創(chuàng)建用戶與對用戶授權(quán)的辦法.創(chuàng)建用戶: 命令: CREATE USER username@host IDENTIFIED BY password;說明:...

MYSQL必讀本節(jié)內(nèi)容：
在mysql數(shù)據(jù)庫中創(chuàng)建用戶與對用戶授權(quán)的辦法.

MYSQL必讀創(chuàng)立用戶:
命令:
?

CREATE USER 'username'@'host' IDENTIFIED BY 'password';?

MYSQL必讀說明:username – 你將創(chuàng)建的用戶名, host – 指定該用戶在哪個主機上可以登陸,如果是本地用戶可用localhost,如果想讓該用戶可以從任意遠程主機登陸,可以使用通配符%. password –? 該用戶的登陸暗碼,暗碼可以為空,如果為空則該用戶可以不需要暗碼登陸服務器.
?

CREATE USER 'dog'@'localhost' IDENTIFIED BY '123456';??
CREATE USER 'pig'@'192.168.1.101_' IDENDIFIED BY '123456';??
CREATE USER 'pig'@'%' IDENTIFIED BY '123456';??
CREATE USER 'pig'@'%' IDENTIFIED BY '';??
CREATE USER 'pig'@'%';?

MYSQL必讀?

MYSQL必讀授權(quán):
敕令:
?

GRANT privileges ON databasename.tablename TO 'username'@'host'?

MYSQL必讀說明: privileges – 用戶的操作權(quán)限,如SELECT , INSERT , UPDATE? 等(詳細列表見該文最后面).如果要授予所的權(quán)限則使用ALL.;databasename –? 數(shù)據(jù)庫名,tablename-表名,如果要授予該用戶對所有數(shù)據(jù)庫和表的相應操作權(quán)限則可用*表現(xiàn), 如*.*.
例子:
?

GRANT SELECT, INSERT ON test.user TO 'pig'@'%';??
GRANT ALL ON *.* TO 'pig'@'%';?

MYSQL必讀注意:用以上命令授權(quán)的用戶不克不及給其它用戶授權(quán),如果想讓該用戶可以授權(quán),用以下命令:
?

GRANT privileges ON databasename.tablename TO 'username'@'host' WITH GRANT OPTION；
?

MYSQL必讀設置與更改用戶暗碼
命令:
?

SET PASSWORD FOR 'username'@'host' = PASSWORD('newpassword');?

MYSQL必讀如果是當前登岸用戶用
?

SET PASSWORD = PASSWORD("newpassword");?

MYSQL必讀撤銷用戶權(quán)限
敕令:
?

REVOKE privilege ON databasename.tablename FROM 'username'@'host';?

MYSQL必讀說明: privilege, databasename, tablename – 同授權(quán)部門.
例子
?

REVOKE SELECT ON *.* FROM 'pig'@'%';?

MYSQL必讀注意: 假如你在給用戶’pig’@'%’授權(quán)的時候是這樣的(或類似的):GRANT SELECT ON test.user TO? ‘pig’@'%’, 則在使用REVOKE SELECT ON *.* FROM? ‘pig’@'%’;命令并不克不及撤銷該用戶對test數(shù)據(jù)庫中user表的SELECT 操作.相反,如果授權(quán)使用的是GRANT SELECT ON? *.* TO ‘pig’@'%’;則REVOKE SELECT ON test.user FROM? ‘pig’@'%’;命令也不克不及撤銷該用戶對test數(shù)據(jù)庫中user表的Select 權(quán)限.
具體信息可以用命令SHOW GRANTS FOR ‘pig’@'%’; 查看.
刪除用戶
命令:
?

DROP USER ‘username’@'host’;?

MYSQL必讀一個典型的數(shù)據(jù)庫建表, 建用戶進程:
?

##創(chuàng)建用于localhost連接的用戶并指定暗碼??
mysql> create user 'pcom'@'localhost' identified by 'aaa7B2249';??
Query OK, 0 rows affected (0.00 sec)??
??????
##創(chuàng)建數(shù)據(jù)庫??
mysql> create database pcom default character set utf8 collate utf8_bin;??
Query OK, 1 row affected (0.00 sec)??
??????
##給本地用戶授權(quán), 這里不需要指定暗碼??
mysql> grant all on pcom.* to 'pcom'@'localhost';??
Query OK, 0 rows affected (0.00 sec)??
??????
##給其他IP地址下的用戶授權(quán), 注意: 這里必須指定暗碼, 否則就可以無暗碼訪問??
mysql> grant all on pcom.* to 'pcom'@'192.168.0.0/255.255.0.0' identified by 'aaa7B2249';??
Query OK, 0 rows affected (0.00 sec)??
??????
##同理??
mysql> grant all on pcom.* to 'pcom'@'172.20.0.0/255.255.0.0' identified by 'aaa7B2249';??
Query OK, 0 rows affected (0.00 sec)??
??????
Done!?
?
##刷新系統(tǒng)權(quán)限表.??
mysql> flush privileges;?

MYSQL必讀附表:在MySQL中的操作權(quán)限

MYSQL必讀ALTER?
## Allows use of ALTER TABLE.??
?????
ALTER ROUTINE??
## Alters or drops stored routines.??
?????
CREATE?
## Allows use of CREATE TABLE.??
?????
CREATE ROUTINE??
## Creates stored routines.??
?????
CREATE TEMPORARY TABLE?
## Allows use of CREATE TEMPORARY TABLE.??
?????
CREATE USER?
## Allows use of CREATE USER, DROP USER, RENAME USER, and REVOKE ALL? PRIVILEGES.??
?????
CREATE VIEW?
## Allows use of CREATE VIEW.??
?????
DELETE?
## Allows use of DELETE.??
?????
DROP?
## Allows use of DROP TABLE.??
?????
EXECUTE?
## Allows the user to run stored routines.??
?????
FILE??
## Allows use of SELECT… INTO OUTFILE and LOAD DATA INFILE.??
?????
INDEX?
## Allows use of CREATE INDEX and DROP INDEX.??
?????
INSERT?
## Allows use of INSERT.??
?????
LOCK TABLES??
## Allows use of LOCK TABLES on tables for which the user also has SELECT privileges.??
?????
PROCESS??
## Allows use of SHOW FULL PROCESSLIST.??
?????
RELOAD??
## Allows use of FLUSH.??
?????
REPLICATION??
## Allows the user to ask where slave or master??
?????
CLIENT??
## servers are.??
?????
REPLICATION SLAVE??
## Needed for replication slaves.??
?????
SELECT?
## Allows use of SELECT.??
?????
SHOW DATABASES??
## Allows use of SHOW DATABASES.??
?????
SHOW VIEW?
## Allows use of SHOW CREATE VIEW.??
?????
SHUTDOWN??
## Allows use of mysqladmin shutdown.??
?????
SUPER??
## Allows use of CHANGE MASTER, KILL, PURGE MASTER LOGS, and SET GLOBAL SQL statements. Allows mysqladmin debug co妹妹and. Allows one extra connection to be made if maximum connections are reached.??
?????
UPDATE?
## Allows use of UPDATE.??
?????
USAGE??
## Allows connection without any specific privileges.

歡迎參與《Mysql實例MySQL增加用戶與用戶授權(quán)命令舉例》討論，分享您的想法，維易PHP學院為您提供專業(yè)教程。

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


    標簽：