| 订阅 | 在线投稿
分享
 
 
当前位置: 王朝网络 >> mysql >> chu xue zhe zai shi yong MySQL shi bi xu le jie de zhu yi shi xiang

chu xue zhe zai shi yong MySQL shi bi xu le jie de zhu yi shi xiang

2008-06-20 06:02:53 编辑來源:互联网 评论
 
 
 
本文为【初学者在使用MySQL时必须了解的注意事项】的拼音翻译版
  chu xue zhe zai shi yong MySQL shi bi xu le jie de zhu yi shi xiang :
  1. ru guo ke hu duan he fu wu qi duan de lian jie xu yao kua yue bing tong guo bu ke xin ren de wang luo , na me jiu xu yao shi yong SSH sui dao lai jia mi gai lian jie de tong xin 。
  2. yong set password yu ju lai xiu gai yong hu de mi ma , san ge bu zhou , xian “mysql -u root” deng lu shu ju ku xi tong , ran hou “mysql> update mysql.user set password=password(’newpwd’)”, zui hou zhi xing “flush privileges” jiu ke yi le 。
  3. xu yao ti fang de gong ji you , fang tou ting 、 cuan gai 、 hui fang 、 ju jue fu wu deng , bu she ji ke yong xing he rong cuo fang mian 。 dui suo you de lian jie 、 cha xun 、 qi ta cao zuo shi yong ji yu ACL ji fang wen kong zhi lie biao de an quan cuo shi lai wan cheng 。 ye you yi xie dui SSL lian jie de zhi chi 。
  4. chu le root yong hu wai de qi ta ren he yong hu bu yuan xu fang wen mysql zhu shu ju ku zhong de user biao ;
  jia mi hou cun fang zai user biao zhong de jia mi hou de yong hu mi ma yi dan xie lu , qi ta ren ke yi sui yi yong gai yong hu ming / mi ma xiang ying de shu ju ku ;
  5. yong grant he revoke yu ju lai jin xing yong hu fang wen kong zhi de gong zuo ;
  6. bu shi yong ming wen mi ma , er shi shi yong md5() he sha1() deng dan xiang de ha xi han shu lai she zhi mi ma ;
  7. bu xuan yong zi dian zhong de zi lai zuo mi ma ;
  8. cai yong fang huo qiang lai qu diao 50% de wai bu wei xian , rang shu ju ku xi tong duo zai fang huo qiang hou mian gong zuo , huo fang zhi zai DMZ qu yu zhong ;
  9. cong yin te wang shang yong nmap lai sao miao 3306 duan kou , ye ke yong telnet server_host 3306 de fang fa ce shi , bu neng yuan xu cong fei xin ren wang luo zhong fang wen shu ju ku fu wu qi de 3306 hao TCP duan kou , yin ci xu yao zai fang huo qiang huo lu you qi shang zuo she ding ;
  10. wei le fang zhi bei e yi chuan ru fei fa shen shu , li ru where ID=234, bie ren que shu ru where ID=234 OR 1=1 dao zhi quan bu xian shi , suo yi zai web de biao dan zhong shi yong ’’ huo "" lai yong zi fu chuan , zai dong tai URL zhong jia ru " dai biao shuang yin hao 、# dai biao jing hao 、' dai biao dan yin hao ; chuan di wei jian cha guo de zhi gei mysql shu ju ku shi fei chang wei xian de ;
  11. zai chuan di shu ju gei mysql shi jian cha yi xia da xiao ;
  12. ying yong cheng xu xu yao lian jie dao shu ju ku ying gai shi yong yi ban de yong hu zhang hao , zhi kai fang shao shu bi yao de quan xian gei gai yong hu ;
  13. zai ge bian cheng jie kou (C C++ PHP Perl Java JDBC deng ) zhong shi yong te ding ‘ tao tuo zi fu ’ han shu ;
  14. xue hui shi yong tcpdump he strings gong ju lai cha kan chuan shu shu ju de an quan xing , li ru tcpdump -l -i eth0 -w -src or dst port 3306 | strings。 yi pu tong yong hu lai qi dong mysql shu ju ku fu wu ;
  15. bu shi yong dao biao de lian jie fu hao , xuan yong de shen shu --skip-symbolic-links;
  16. que xin zai mysql mu lu zhong zhi you qi dong shu ju ku fu wu de yong hu cai ke yi dui wen jian you du he xie de quan xian ;
  17. bu xu jiang process huo super quan xian fu gei fei guan li yong hu , gai mysqladmin processlist ke yi lie ju chu dang qian zhi xing de cha xun wen ben ;super quan xian ke yong yu qie duan ke hu duan lian jie 、 gai bian fu wu qi yun xing shen shu zhuang tai 、 kong zhi kao bei fu zhi shu ju ku de fu wu qi ;
  18.file quan xian bu fu gei guan li yuan yi wai de yong hu , fang zhi chu xian load data ’/etc/passwd’ dao biao zhong zai yong select xian shi chu lai de wen ti ;
  19. ru guo bu xiang xin DNS fu wu gong si de fu wu , ke yi zai zhu ji ming cheng yuan xu biao zhong zhi she zhi IP shu zi di zhi ;
  20. shi yong max_user_connections bian liang lai shi mysqld fu wu jin cheng , dui yi ge zhi ding zhang hu xian ding lian jie shu ;
  21.grant yu ju ye zhi chi zi yuan kong zhi xuan xiang ;
  22. qi dong mysqld fu wu jin cheng de an quan xuan xiang kai guan ,--local-infile=0 huo 1 ruo shi 0 ze ke hu duan cheng xu jiu wu fa shi yong local load data le , fu quan de yi ge li zi grant insert(user) on mysql.user to ’user_name’@’host_name’; ruo shi yong --skip-grant-tables xi tong jiang dui ren he yong hu de fang wen bu zuo ren he fang wen kong zhi , dan ke yi yong mysqladmin flush-privileges huo mysqladmin reload lai kai qi fang wen kong zhi ; mo ren qing kuang shi show databases yu ju dui suo you yong hu kai fang , ke yi yong --skip-show-databases lai guan bi diao 。
  23. peng dao Error 1045(28000) Access Denied for user ’root’@’localhost’ (Using password:NO) cuo wu shi , ni xu yao chong xin she zhi mi ma , ju ti fang fa shi : xian yong --skip-grant-tables shen shu qi dong mysqld, ran hou zhi xing mysql -u root mysql,mysql>update user set password=password(’newpassword’) where user=’root’;mysql>Flush privileges;, zui hou chong xin qi dong mysql jiu ke yi le 。【原文】【汉音对照
 
 
 
 
 
 
 
 
 
日版宠物情人插曲《Winding Road》歌词

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

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

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

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

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

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

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

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

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

 
 
chu xue zhe zai shi yong MySQL shi bi xu le jie de zhu yi shi xiang : 1. ru guo ke hu duan he fu wu qi duan de lian jie xu yao kua yue bing tong guo bu ke xin ren de wang luo , na me jiu xu yao shi yong SSH sui dao lai jia mi gai lian jie de tong xin 。 2. yong set password yu ju lai xiu gai yong hu de mi ma , san ge bu zhou , xian “mysql -u root” deng lu shu ju ku xi tong , ran hou “mysql> update mysql.user set password=password(’newpwd’)”, zui hou zhi xing “flush privileges” jiu ke yi le 。 3. xu yao ti fang de gong ji you , fang tou ting 、 cuan gai 、 hui fang 、 ju jue fu wu deng , bu she ji ke yong xing he rong cuo fang mian 。 dui suo you de lian jie 、 cha xun 、 qi ta cao zuo shi yong ji yu ACL ji fang wen kong zhi lie biao de an quan cuo shi lai wan cheng 。 ye you yi xie dui SSL lian jie de zhi chi 。 4. chu le root yong hu wai de qi ta ren he yong hu bu yuan xu fang wen mysql zhu shu ju ku zhong de user biao ; jia mi hou cun fang zai user biao zhong de jia mi hou de yong hu mi ma yi dan xie lu , qi ta ren ke yi sui yi yong gai yong hu ming / mi ma xiang ying de shu ju ku ; 5. yong grant he revoke yu ju lai jin xing yong hu fang wen kong zhi de gong zuo ; 6. bu shi yong ming wen mi ma , er shi shi yong md5() he sha1() deng dan xiang de ha xi han shu lai she zhi mi ma ; 7. bu xuan yong zi dian zhong de zi lai zuo mi ma ; 8. cai yong fang huo qiang lai qu diao 50% de wai bu wei xian , rang shu ju ku xi tong duo zai fang huo qiang hou mian gong zuo , huo fang zhi zai DMZ qu yu zhong ; 9. cong yin te wang shang yong nmap lai sao miao 3306 duan kou , ye ke yong telnet server_host 3306 de fang fa ce shi , bu neng yuan xu cong fei xin ren wang luo zhong fang wen shu ju ku fu wu qi de 3306 hao TCP duan kou , yin ci xu yao zai fang huo qiang huo lu you qi shang zuo she ding ; 10. wei le fang zhi bei e yi chuan ru fei fa shen shu , li ru where ID=234, bie ren que shu ru where ID=234 OR 1=1 dao zhi quan bu xian shi , suo yi zai web de biao dan zhong shi yong ’’ huo "" lai yong zi fu chuan , zai dong tai URL zhong jia ru " dai biao shuang yin hao 、# dai biao jing hao 、' dai biao dan yin hao ; chuan di wei jian cha guo de zhi gei mysql shu ju ku shi fei chang wei xian de ; 11. zai chuan di shu ju gei mysql shi jian cha yi xia da xiao ; 12. ying yong cheng xu xu yao lian jie dao shu ju ku ying gai shi yong yi ban de yong hu zhang hao , zhi kai fang shao shu bi yao de quan xian gei gai yong hu ; 13. zai ge bian cheng jie kou (C C++ PHP Perl Java JDBC deng ) zhong shi yong te ding ‘ tao tuo zi fu ’ han shu ; 14. xue hui shi yong tcpdump he strings gong ju lai cha kan chuan shu shu ju de an quan xing , li ru tcpdump -l -i eth0 -w -src or dst port 3306 | strings。 yi pu tong yong hu lai qi dong mysql shu ju ku fu wu ; 15. bu shi yong dao biao de lian jie fu hao , xuan yong de shen shu --skip-symbolic-links; 16. que xin zai mysql mu lu zhong zhi you qi dong shu ju ku fu wu de yong hu cai ke yi dui wen jian you du he xie de quan xian ; 17. bu xu jiang process huo super quan xian fu gei fei guan li yong hu , gai mysqladmin processlist ke yi lie ju chu dang qian zhi xing de cha xun wen ben ;super quan xian ke yong yu qie duan ke hu duan lian jie 、 gai bian fu wu qi yun xing shen shu zhuang tai 、 kong zhi kao bei fu zhi shu ju ku de fu wu qi ; 18.file quan xian bu fu gei guan li yuan yi wai de yong hu , fang zhi chu xian load data ’/etc/passwd’ dao biao zhong zai yong select xian shi chu lai de wen ti ; 19. ru guo bu xiang xin DNS fu wu gong si de fu wu , ke yi zai zhu ji ming cheng yuan xu biao zhong zhi she zhi IP shu zi di zhi ; 20. shi yong max_user_connections bian liang lai shi mysqld fu wu jin cheng , dui yi ge zhi ding zhang hu xian ding lian jie shu ; 21.grant yu ju ye zhi chi zi yuan kong zhi xuan xiang ; 22. qi dong mysqld fu wu jin cheng de an quan xuan xiang kai guan ,--local-infile=0 huo 1 ruo shi 0 ze ke hu duan cheng xu jiu wu fa shi yong local load data le , fu quan de yi ge li zi grant insert(user) on mysql.user to ’user_name’@’host_name’; ruo shi yong --skip-grant-tables xi tong jiang dui ren he yong hu de fang wen bu zuo ren he fang wen kong zhi , dan ke yi yong mysqladmin flush-privileges huo mysqladmin reload lai kai qi fang wen kong zhi ; mo ren qing kuang shi show databases yu ju dui suo you yong hu kai fang , ke yi yong --skip-show-databases lai guan bi diao 。 23. peng dao Error 1045(28000) Access Denied for user ’root’@’localhost’ (Using password:NO) cuo wu shi , ni xu yao chong xin she zhi mi ma , ju ti fang fa shi : xian yong --skip-grant-tables shen shu qi dong mysqld, ran hou zhi xing mysql -u root mysql,mysql>update user set password=password(’newpassword’) where user=’root’;mysql>Flush privileges;, zui hou chong xin qi dong mysql jiu ke yi le 。
󰈣󰈤
  免责声明:本文仅代表作者个人观点,与王朝网络无关。王朝网络登载此文出于传递更多信息之目的,并不意味着赞同其观点或证实其描述,其原创性以及文中陈述文字和内容未经本站证实,对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺,请读者仅作参考,并请自行核实相关内容。
 
 
情人节的清纯女生(9)
情人节的清纯女生(8)
情人节的清纯女生(7)
情人节的清纯女生(6)
山东蓬莱海边组照
一探哲蚌 II
一探哲蚌 III
古长城的一角
 
>>返回首页<<
 
 
 为你推荐
 
 
 
 转载本文
 UBB代码 HTML代码
复制到剪贴板...
 
 热帖排行
 
 
 
 
 
©2005- 王朝网络 版权所有