| 订阅 | 在线投稿
分享
 
 
当前位置: 王朝网络 >> mysql >> MySQL shu ju ku zhong shi yong GRANT yu ju zeng tian xin yong hu

MySQL shu ju ku zhong shi yong GRANT yu ju zeng tian xin yong hu

2008-06-01 03:36:34 编辑來源:互联网 评论
 
 
 
本文为【MySQL数据库中使用GRANT语句增添新用户】的拼音翻译版
  zhe pian lun tan wen zhang ( sai di wang ji shu she qu ) xiang xi de jie shao le zai MySQL zhong shi yong GRANT yu ju zeng tian xin yong hu de ju ti bu zhou , geng duo nei rong qing shen kao xia wen ……
  xia mian de li zi xian shi ru he shi yong MySQL ke hu an zhuang xin yong hu 。 zhe xie li zi jia ding quan xian yi que sheng bei an zhuang 。 zhe yi wei zhe wei le gai bian , ni bi xu zai MySQL zheng zai yun xing tong yi tai ji qi shang , ni bi xu zuo wei MySQL root yong hu lian jie , bing qie root yong hu bi xu dui MySQL shu ju ku you insert quan xian he reload guan li quan xian 。 ling wai , ru guo ni gai bian le root yong hu kou ling , ni bi xu ru xia de MySQL ming ling zhi ding ta 。
  ni ke yi tong guo fa chu GRANT yu ju zeng jia xin yong hu :
  shell> mysql --user=root mysql mysql> GRANT ALL PRIVILEGES ON *.* TO monty@localhost IDENTIFIED BY 'something' WITH GRANT OPTION; mysql> GRANT ALL PRIVILEGES ON *.* TO monty@"%" IDENTIFIED BY 'something' WITH GRANT OPTION; mysql> GRANT RELOAD,PROCESS ON *.* TO admin@localhost; mysql> GRANT USAGE ON *.* TO dummy@localhost;
  zhe xie GRANT yu ju an zhuang 3 ge xin yong hu :
  monty: ke yi cong ren he di fang lian jie fu wu qi de yi ge wan quan de chao ji yong hu , dan shi bi xu shi yong yi ge kou ling ('something' zuo zhe ge 。 zhu yi , wo men bi xu dui monty@localhost he monty@"%" fa chu GRANT yu ju 。 ru guo wo men zeng jia localhost tiao mu , dui localhost de ni ming yong hu tiao mu zai wo men cong ben di zhu ji lian jie jie shi you mysql_install_db chuang jian de tiao mu jiang you xian kao lv , yin wei ta you geng te ding de Host zi duan zhi , suo yi yi user biao pai lie shun xu kan geng zao dao lai 。
  admin: ke yi cong localhost mei you yi ge kou ling jin xing lian jie bing qie bei shou yu reload he process guan li quan xian de yong hu 。 zhe yuan xu yong hu zhi xing mysqladmin reload、mysqladmin refresh he mysqladmin flush-* ming ling , huan you mysqladmin processlist。 mei you shou yu shu ju ku you guan de quan xian 。 ta men neng zai yi hou tong guo fa chu ling yi ge GRANT yu ju shou quan 。
  dummy: ke yi bu yong yi ge kou ling lian jie de yi ge yong hu , dan shi zhi neng cong ben di zhu ji 。 quan ju quan xian bei she zhi wei 'N'--USAGE quan xian lei xing yuan xu ni wu xu quan xian jiu ke she zhi yi ge yong hu 。 ta jia ding ni jiang zai yi hou shou yu shu ju ku xiang guan de quan xian 。
  ni ye ke yi zhi jie tong guo fa chu INSERT yu ju zeng jia tong yang de yong hu cun qu xin xi , ran hou gao su fu wu qi zai ci zhuang ru shou quan biao :
  shell> mysql --user=root mysql mysql> INSERT INTO user VALUES('localhost','monty',PASSWORD('something'), 'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y') mysql> INSERT INTO user VALUES('%','monty',PASSWORD('something'), 'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y') mysql> INSERT INTO user SET Host='localhost',User='admin', Reload_priv='Y', Process_priv='Y'; mysql> INSERT INTO user (Host,User,Password) VALUES('localhost','dummy',''); mysql> FLUSH PRIVILEGES;
  qu jue yu ni de MySQL ban ben , dui shang shu , ni ke neng bi xu shi yong yi ge bu tong shu mu 'Y' zhi ( zai 3.22.11 yi qian de ban ben you geng shao de quan xian lie )。 dui admin yong hu , zhi yong zai 3.22.11 kai shi de ban ben ju you de geng jia ke du de INSERT kuo chong de yu fa 。
  zhu yi , wei le she zhi yi ge chao ji yong hu , ni zhi xu chuang zao yi ge user biao tiao mu , qi quan xian zi duan she wei 'Y'。 bu xu yao db huo host biao de tiao mu 。
  zai user biao zhong de quan xian lie bu shi you zui hou yi ge INSERT yu ju ming que she zhi de ( dui dummy yong hu ), yin ci na xie lie bei fu yu que sheng zhi 'N'。 zhe shi GRANT USAGE zuo de tong yang de shi qing 。
  xia lie li zi zeng jia yi ge yong hu custom, ta neng cong zhu ji localhost、server.domain he whitehouse.gov lian jie 。 ta zhi xiang yao cong localhost cun qu bankaccount shu ju ku , cong whitehouse.gov cun qu expenses shu ju ku he cong suo you 3 tai zhu ji cun qu customer shu ju ku 。 ta xiang yao cong suo you 3 tai zhu ji shang shi yong kou ling stupid。
  wei le shi yong GRANT yu ju she zhi ge yong hu de quan xian , yun xing zhe xie ming ling :
  shell> mysql --user=root mysql mysql> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ON bankaccount.* TO custom@localhost IDENTIFIED BY 'stupid'; mysql> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ON expenses.* TO custom@whitehouse.gov IDENTIFIED BY 'stupid'; mysql> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ON customer.* TO custom@'%' IDENTIFIED BY 'stupid';
  tong guo zhi jie xiu gai shou quan biao she zhi yong hu quan xian , yun xing zhe xie ming ling ( zhu yi , zai jie shu shi FLUSH PRIVILEGES):
  shell> mysql --user=root mysql mysql> INSERT INTO user (Host,User,Password) VALUES('localhost','custom',PASSWORD('stupid')); mysql> INSERT INTO user (Host,User,Password) VALUES('server.domain','custom',PASSWORD('stupid')); mysql> INSERT INTO user (Host,User,Password) VALUES('whitehouse.gov','custom',PASSWORD('stupid')); mysql> INSERT INTO db (Host,Db,User,Select_priv,Insert_priv,Update_priv,Delete_priv, Create_priv,Drop_priv) VALUES ('localhost','bankaccount','custom','Y','Y','Y','Y','Y','Y'); mysql> INSERT INTO db (Host,Db,User,Select_priv,Insert_priv,Update_priv,Delete_priv, Create_priv,Drop_priv) VALUES ('whitehouse.gov','expenses','custom','Y','Y','Y','Y','Y','Y'); mysql> INSERT INTO db (Host,Db,User,Select_priv,Insert_priv,Update_priv,Delete_priv, Create_priv,Drop_priv) VALUES('%','customer','custom','Y','Y','Y','Y','Y','Y'); mysql> FLUSH PRIVILEGES;【原文】【汉音对照
 
 
 
 
 
 
 
 
 
日版宠物情人插曲《Winding Road》歌词

日版宠物情人2017的插曲,很带节奏感,日语的,女生唱的。 最后听见是在第8集的时候女主手割伤了,然后男主用嘴帮她吸了一下,插曲就出来了。 歌手:Def...

兄弟共妻,我成了他们夜里的美食

老钟家的两个儿子很特别,就是跟其他的人不太一样,魔一般的执着。兄弟俩都到了要结婚的年龄了,不管自家老爹怎么磨破嘴皮子,兄弟俩说不娶就不娶,老父母为兄弟两操碎了心...

如何磨出破洞牛仔裤?牛仔裤怎么剪破洞?

把牛仔裤磨出有线的破洞 1、具体工具就是磨脚石,下面垫一个硬物,然后用磨脚石一直磨一直磨,到把那块磨薄了,用手撕开就好了。出来的洞啊很自然的。需要猫须的话调几...

我就是扫描下图得到了敬业福和爱国福

先来看下敬业福和爱国福 今年春节,支付宝再次推出了“五福红包”活动,表示要“把欠大家的敬业福都还给大家”。 今天该活动正式启动,和去年一样,需要收集“五福”...

冰箱异味产生的原因和臭味去除的方法

有时候我们打开冰箱就会闻到一股异味,冰箱里的这种异味是因为一些物质发出的气味的混合体,闻起来让人恶心。 产生这些异味的主要原因有以下几点。 1、很多人有这种习...

 
 
zhe pian lun tan wen zhang ( sai di wang ji shu she qu ) xiang xi de jie shao le zai MySQL zhong shi yong GRANT yu ju zeng tian xin yong hu de ju ti bu zhou , geng duo nei rong qing shen kao xia wen …… xia mian de li zi xian shi ru he shi yong MySQL ke hu an zhuang xin yong hu 。 zhe xie li zi jia ding quan xian yi que sheng bei an zhuang 。 zhe yi wei zhe wei le gai bian , ni bi xu zai MySQL zheng zai yun xing tong yi tai ji qi shang , ni bi xu zuo wei MySQL root yong hu lian jie , bing qie root yong hu bi xu dui MySQL shu ju ku you insert quan xian he reload guan li quan xian 。 ling wai , ru guo ni gai bian le root yong hu kou ling , ni bi xu ru xia de MySQL ming ling zhi ding ta 。 ni ke yi tong guo fa chu GRANT yu ju zeng jia xin yong hu : shell> mysql --user=root mysql mysql> GRANT ALL PRIVILEGES ON *.* TO monty@localhost IDENTIFIED BY 'something' WITH GRANT OPTION; mysql> GRANT ALL PRIVILEGES ON *.* TO monty@"%" IDENTIFIED BY 'something' WITH GRANT OPTION; mysql> GRANT RELOAD,PROCESS ON *.* TO admin@localhost; mysql> GRANT USAGE ON *.* TO dummy@localhost; zhe xie GRANT yu ju an zhuang 3 ge xin yong hu : monty: ke yi cong ren he di fang lian jie fu wu qi de yi ge wan quan de chao ji yong hu , dan shi bi xu shi yong yi ge kou ling ('something' zuo zhe ge 。 zhu yi , wo men bi xu dui monty@localhost he monty@"%" fa chu GRANT yu ju 。 ru guo wo men zeng jia localhost tiao mu , dui localhost de ni ming yong hu tiao mu zai wo men cong ben di zhu ji lian jie jie shi you mysql_install_db chuang jian de tiao mu jiang you xian kao lv , yin wei ta you geng te ding de Host zi duan zhi , suo yi yi user biao pai lie shun xu kan geng zao dao lai 。 admin: ke yi cong localhost mei you yi ge kou ling jin xing lian jie bing qie bei shou yu reload he process guan li quan xian de yong hu 。 zhe yuan xu yong hu zhi xing mysqladmin reload、mysqladmin refresh he mysqladmin flush-* ming ling , huan you mysqladmin processlist。 mei you shou yu shu ju ku you guan de quan xian 。 ta men neng zai yi hou tong guo fa chu ling yi ge GRANT yu ju shou quan 。 dummy: ke yi bu yong yi ge kou ling lian jie de yi ge yong hu , dan shi zhi neng cong ben di zhu ji 。 quan ju quan xian bei she zhi wei 'N'--USAGE quan xian lei xing yuan xu ni wu xu quan xian jiu ke she zhi yi ge yong hu 。 ta jia ding ni jiang zai yi hou shou yu shu ju ku xiang guan de quan xian 。 ni ye ke yi zhi jie tong guo fa chu INSERT yu ju zeng jia tong yang de yong hu cun qu xin xi , ran hou gao su fu wu qi zai ci zhuang ru shou quan biao : shell> mysql --user=root mysql mysql> INSERT INTO user VALUES('localhost','monty',PASSWORD('something'), 'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y') mysql> INSERT INTO user VALUES('%','monty',PASSWORD('something'), 'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y') mysql> INSERT INTO user SET Host='localhost',User='admin', Reload_priv='Y', Process_priv='Y'; mysql> INSERT INTO user (Host,User,Password) VALUES('localhost','dummy',''); mysql> FLUSH PRIVILEGES; qu jue yu ni de MySQL ban ben , dui shang shu , ni ke neng bi xu shi yong yi ge bu tong shu mu 'Y' zhi ( zai 3.22.11 yi qian de ban ben you geng shao de quan xian lie )。 dui admin yong hu , zhi yong zai 3.22.11 kai shi de ban ben ju you de geng jia ke du de INSERT kuo chong de yu fa 。 zhu yi , wei le she zhi yi ge chao ji yong hu , ni zhi xu chuang zao yi ge user biao tiao mu , qi quan xian zi duan she wei 'Y'。 bu xu yao db huo host biao de tiao mu 。 zai user biao zhong de quan xian lie bu shi you zui hou yi ge INSERT yu ju ming que she zhi de ( dui dummy yong hu ), yin ci na xie lie bei fu yu que sheng zhi 'N'。 zhe shi GRANT USAGE zuo de tong yang de shi qing 。 xia lie li zi zeng jia yi ge yong hu custom, ta neng cong zhu ji localhost、server.domain he whitehouse.gov lian jie 。 ta zhi xiang yao cong localhost cun qu bankaccount shu ju ku , cong whitehouse.gov cun qu expenses shu ju ku he cong suo you 3 tai zhu ji cun qu customer shu ju ku 。 ta xiang yao cong suo you 3 tai zhu ji shang shi yong kou ling stupid。 wei le shi yong GRANT yu ju she zhi ge yong hu de quan xian , yun xing zhe xie ming ling : shell> mysql --user=root mysql mysql> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ON bankaccount.* TO custom@localhost IDENTIFIED BY 'stupid'; mysql> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ON expenses.* TO custom@whitehouse.gov IDENTIFIED BY 'stupid'; mysql> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ON customer.* TO custom@'%' IDENTIFIED BY 'stupid'; tong guo zhi jie xiu gai shou quan biao she zhi yong hu quan xian , yun xing zhe xie ming ling ( zhu yi , zai jie shu shi FLUSH PRIVILEGES): shell> mysql --user=root mysql mysql> INSERT INTO user (Host,User,Password) VALUES('localhost','custom',PASSWORD('stupid')); mysql> INSERT INTO user (Host,User,Password) VALUES('server.domain','custom',PASSWORD('stupid')); mysql> INSERT INTO user (Host,User,Password) VALUES('whitehouse.gov','custom',PASSWORD('stupid')); mysql> INSERT INTO db (Host,Db,User,Select_priv,Insert_priv,Update_priv,Delete_priv, Create_priv,Drop_priv) VALUES ('localhost','bankaccount','custom','Y','Y','Y','Y','Y','Y'); mysql> INSERT INTO db (Host,Db,User,Select_priv,Insert_priv,Update_priv,Delete_priv, Create_priv,Drop_priv) VALUES ('whitehouse.gov','expenses','custom','Y','Y','Y','Y','Y','Y'); mysql> INSERT INTO db (Host,Db,User,Select_priv,Insert_priv,Update_priv,Delete_priv, Create_priv,Drop_priv) VALUES('%','customer','custom','Y','Y','Y','Y','Y','Y'); mysql> FLUSH PRIVILEGES;
󰈣󰈤
  免责声明:本文仅代表作者个人观点,与王朝网络无关。王朝网络登载此文出于传递更多信息之目的,并不意味着赞同其观点或证实其描述,其原创性以及文中陈述文字和内容未经本站证实,对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺,请读者仅作参考,并请自行核实相关内容。
 
 
华丽的模特拍摄(8)
华丽的模特拍摄(7)
华丽的模特拍摄(6)
华丽的模特拍摄(5)
八里沟
朝阳宫
天下峨眉 云上金顶
老家(四)
 
>>返回首页<<
 
 
 为你推荐
 
 
 
 转载本文
 UBB代码 HTML代码
复制到剪贴板...
 
 热帖排行
 
 
 
 
 
©2005- 王朝网络 版权所有