linux下Mysql數(shù)據(jù)庫遠程連接操作

1、目錄安裝NavicatforMySQL2MySQL遠程連接12MySQL遠程連接2411MySQL數(shù)據(jù)庫設(shè)置密碼方式：b在以下解壓出來的文件夾中雙擊.exe可執(zhí)行文件MySQL遠程連接步驟安裝NavicatforMySQLa解壓以下壓縮包cktforMySQL.rip機遙業(yè)ZU用品丈怦21,047KB根據(jù)提示安裝，選擇"注冊''，將key.txt文件中的注冊碼輸入完成安裝注冊碼：NAVH-WK6A-DMVK-DKW3出現(xiàn)以上界面，表示安裝成功MySQL遠程連接1在MySQL數(shù)據(jù)庫沒有設(shè)置密碼的情況下#mysql回車|rontgocihioRt導(dǎo)mysqIWe1cDin

2、etotheMySQLworntor.Commandsendwiih:org»YcurA'iSQLcunntclioniJisL：Sci,YP-rv<rinn.5.0.37-ccmmunitj.MySQJ.CnrmiuriiFdi1inn（GPL）T>pehelp；'or'hforheIp,Type'c'toclearthebuffer.m”ql|mysql>showdatabases;mysq1>shovdatabases：Databaseh*informalionschemacwbbsmysqlIredmooroat

3、est51'owsinset(0*05sec)mysal>|mysql>usemysql;ttisq1>usemys<|1；ReadingtableinformationforcompletionoftableandcolumnnameiYoucanturnoffthisfeaturetogotaquickerstartupwith一八Databaserhangt?dth51>mysql>showtables;mysq1>showtab1es；Tabies_in_my£qlcoluTns_priIdbFun匚he1p_rtegnryl

4、ielp_keyvvDrdhelprelationIhelp_topichostmysql>selecthost,userfromuser;mysq1>selecthost,userfromuser；Hhhostuser1irJgodhost1godbostrootloca1host1localhost十rootp.4rowsinset（0.01sec）mysq1>mysql>updateusersethost=%'whereuser-rootroot'；for ke y 1mysql>updateuserseth口st=%,whereuser=E

5、RROR_1062（23000）：Duplicateentry'-raotmysql>J出現(xiàn)此錯誤不管mysql>flushprivileges;mysql>flushprivileges：QueryOK,0iowsaffected（0.00sec）mysql>MySQL遠程連接2如果mysql數(shù)據(jù)庫設(shè)置密碼那么輸入mysql-uroot-p回車，輸入密碼，進入mysql,root«godhost-mysql-uroot-pEnterpassword：WelcometotheMySQLmonitorCommandsondwith；orYour.'

6、;4ySQLcjnnectionidi&2crvursion*3,0.邙munityMySQLCummunilyEdition（GFL,Pype'help；har'h'forheIp+Type'c*1aclearth&butferr剩余操作步驟與沒有密碼操作步驟一樣3測試連接在windows翻開之前安裝的NavicatforMySQL軟件義蚌區(qū)曼若陰榭峽工A田窖匚也卒劫目J在彈出的窗口中輸入linux下的Ip點擊連接雙擊mysql文巧電）皇吉它）收讖再也J工具！©Q（VI附電（1國連報B192.IBB.L.m_33(E日bbn雙擊表，即

7、可看到數(shù)據(jù)庫r*£uilc_LfiJp_citc«g)&r7lielii_he5wwihelp_relation.Ehe】_tepicIrhowlr«dn，ano& tastDrccsjriviatle2_priwtlHfl_TCTLfitjffle_zcine_leap_5&icojLdi:ms_zC'nertunotina_zci.cr-anzl11ox1iie_zorije_translCjob_QBf磨此時，在linux環(huán)境下，輸入exit退出mysql,再次輸入mysql進入niysqI>exitrootgodhos

8、t=|#mysq1AccometotheMySQLtronitor.Commsnclsendwith；org,YourSQLconnctionidis6Serverersion*5.0<ST-cotntnunity也SQLCommunityEdition(GTypohelp；or'h'forht?1p*Typy'cIdcloarih白buffe*nysql>同的,皿工為口輸入showdatabasesmysqlJshow databasesJ_-1DatabasellL1i nfoinmat i on_schenia十口 j TrLJ_ri2 rowsmys

9、ql>i1n set (0.00 sec)少 了 mysql數(shù)據(jù)庫以上原因用戶沒有對mysql數(shù)據(jù)庫的使用權(quán)限了解決方法:方法1.關(guān)閉mysql#servicemysqlstop|口門t科gclh6mt.'-servi-esq!stopShuttingdownMySQL.|門F匈gmlhrml*|ttB3 .新開一個端口輸入mysql-urootmysqlrootf=mysqI一utootmysqlriu-adlugIabltjiniuririatijn1'uj'cumpltitkenoftablyaiidCDluitiiiYoucanturnoffthisfea

10、turetogetaquickerstartupwithAifetrnmetd?heY,£qLiron11r.r+CDmirandsendwith:org.YourMySULconnectionidis】Ser'.Hi'version'5.0.3'-ctJiuniuriEL丫丸3QLCurniruniLyEditinn（GPL）ypchelp:orFh'forhelp.TypocFtoclearthebuffer+mysql>|mysql>deletefromuserwhereUSER='mysq1>deletefro

11、muserwhereUSER=，'；Qu曰ryOK,2poavsaffected（0.00sec）mysql>mysql>FLUSHPRIVILEGES;mysql>FLUSHPRIVILEGES：Quc?ry0k.0rowsaffueled（0.00sec）Tnysql>mysql>qnisql>qByeroot（&godhost!4 .重新啟動MySql效勞servicemysqlstarrjrdhnt.vir.rmysqJst門rtStartingMySQL確定5 .重新進入mysql,輸入showdatabases檢查是否有mysql

12、數(shù)據(jù)庫Imat用gcd卜口5t"mysq1iurootpEnterpasswordMwlcc力士totheSQLtnonitor.Cojrunandsendth：org.YourMySQLcotineclionidis2Servervurjion*,5.0.37-commutiityMySQLCommunilyLdiLion(GPL)IXpc'he1p+fmr'hFnrheIp>Typoc'tnc-leiTthehuffc?r.mysq1>showdatabases"IuDatabaseHbinformaticn_schemacssbbs

13、mysqlredmoonoaItest|dF5rowsinset(0.04sec)在以上步驟4中可能出現(xiàn)以下情況：此時關(guān)機重啟linux系統(tǒng)rootgodhost *|F shutdown h now在重開的linux下，重啟mysql效勞I rnntriEndhosT -" flet'V i cr rnysq 1 tar t StHi't i ng My SUI,進入mysqlIrootgodhost -mysq1Icomc io the M>SGL raonitur. Your MySQL connect ion id is I St r ur stTHi：

14、”： ，： .0,胃7m門!nutCnwmndt； end 懦ilh ； or1 g.ly MySQL Cbmmunily Editiun (GPLmysql>sho*databases：Databaseinformation_schemacwbbs用戶重新?lián)碛惺筸ysql的權(quán)限mysqlfrdmoonoatest5rowsinset(0.06sec)方法二：1 .關(guān)閉mysql效勞#servicemysqlstopIrooll*icetn>sq1與1_口pShutxingdownVySQL»roothost-1如2 .屏蔽權(quán)限#mysqld_safe-skip-gran

15、t-table|rootgodhost尸mysqld_sa£e一skip-granttableStartingmysqldtJaemonttilhdatabasesfromib/mysql3 .新開一個端口輸入#mysql-urootmysqlmysql>UPDATEuserSETPassword=PASSWORD('密碼')whereUSER='root'mysql>UFQAIEuserSEIPasswprdASSIOKDt'000')wherelSER='root：Qu白口OK,1rouaffected(10.0

16、0sec)Rhitmatched»2Ch口力酢6；1Warnings：0mysq1>mysql>FLUSHPRIVILEGES;mysql>FLUSHPRIVILEGES；QueryOKf0rowsaffected(0,00sec)mysql>IImysql>qrnysql>qBy巳rootgodhost¥，4 .重新啟動mysql效勞5 .輸入mysql-uroot-p回車輸入密碼；輸入showdatabases檢查是否有mysql數(shù)據(jù)庫在以上步驟4中假設(shè)出現(xiàn)與方法一同樣的情況，啟動mysql失敗，那么關(guān)機重啟linux系統(tǒng)MySQL數(shù)據(jù)庫設(shè)置密碼方式：自己設(shè)置的密碼#mysqladmin-urootpassword"000回車然后輸入mysql-uroot-p回車，輸入剛剛設(shè)置的密碼進入mysql數(shù)據(jù)庫MySQL設(shè)置密碼：輸入mysqladmin-urootpassword“000root©godhost=mysqladminurootpassword'000"rootgodhost輸入mysql-ur