linux下Mysql数据库远程连接操作

1、目录安装NavicatforMySQL2MySQL远程连接12MySQL远程连接2411MySQL数据库设置密码方式：b在以下解压出来的文件夹中双击.exe可执行文件MySQL远程连接步骤安装NavicatforMySQLa解压以下压缩包cktforMySQL.rip机遥业ZU用品丈怦21,047KB根据提示安装，选择"注册''，将key.txt文件中的注册码输入完成安装注册码：NAVH-WK6A-DMVK-DKW3出现以上界面，表示安装成功MySQL远程连接1在MySQL数据库没有设置密码的情况下#mysql回车|rontgocihioRt导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出现此错误不管mysql>flushprivileges;mysql>flushprivileges：QueryOK,0iowsaffected（0.00sec）mysql>MySQL远程连接2如果mysql数据库设置密码那么输入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软件义蚌区曼若阴榭峡工A田窖匚也卒劫目J在弹出的窗口中输入linux下的Ip点击连接双击mysql文巧电）皇吉它）收谶再也J工具！©Q（VI附电（1国连报B192.IBB.L.m_33(E日bbn双击表，即

7、可看到数据库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环境下，输入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数据库以上原因用户没有对mysql数据库的使用权限了解决方法:方法1.关闭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、数据库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中可能出现以下情况：此时关机重启linux系统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用户重新拥有使mysql的权限mysqlfrdmoonoatest5rowsinset(0.06sec)方法二：1 .关闭mysql效劳#servicemysqlstopIrooll*icetn>sq1与1_口pShutxingdownVySQL»roothost-1如2 .屏蔽权限#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数据库在以上步骤4中假设出现与方法一同样的情况，启动mysql失败，那么关机重启linux系统MySQL数据库设置密码方式：自己设置的密码#mysqladmin-urootpassword"000回车然后输入mysql-uroot-p回车，输入刚刚设置的密码进入mysql数据库MySQL设置密码：输入mysqladmin-urootpassword“000root©godhost=mysqladminurootpassword'000"rootgodhost输入mysql-ur