mysql初次不能登錄解決方法

#1.停止mysql數(shù)據(jù)庫/etc/init.d/mysqld?stop  #2.執(zhí)行如下命令mysqld_safe?--user=mysql?--skip-grant-tables?--skip-networking?&  #3.使用root登錄mysql數(shù)據(jù)庫mysql?-u?root?mysql  #4.更新root密碼mysql>?UPDATE?user?SET?Password=PASSWORD('newpassword')?where?USER='root';  #最新版MySQL請采用如下SQL：mysql>?UPDATE?user?SET?authentication_string=PASSWORD('newpassword')?where?USER='root';  #5.刷新權(quán)限?mysql>?FLUSH?PRIVILEGES;  #6.退出mysqlmysql>?quit  #7.重啟mysql/etc/init.d/mysqld?restart  #8.使用root用戶重新登錄mysqlmysql?-uroot?-p?  Enter?password:?

需要手動增加可以遠(yuǎn)程訪問數(shù)據(jù)庫的用戶。  方法一、本地登入mysql，更改?"mysql"?數(shù)據(jù)庫里的?"user"?表里的?"host"?項(xiàng)，將"localhost"改為"%"#mysql?-u?root?-prootmysql>use?mysql;  mysql>update?user?set?host?=?'%'?where?user?=?'root';  mysql>select?host,?user?from?user;  方法二、直接授權(quán)(推薦)  　　從任何主機(jī)上使用root用戶，密碼：youpassword（你的root密碼）連接到mysql服務(wù)器：  MySQL登錄時(shí)出現(xiàn)?Access?denied?for?user?'root'@'xxx.xxx.xxx.xxx'?(using?password:?YES)?的原因及解決辦法。#?mysql?-u?root?-h?192.168.194.142?-pEnter?password:?  ERROR?1045?(28000):?Access?denied?for?user?'root'@'192.168.194.142'?(using?password:?YES)    【解決辦法】1.?先用localhost登錄#?mysql?-u?root?-pEnter?password:?  2.?執(zhí)行授權(quán)命令  mysql>?grant?all?privileges?on?*.*?to?root@'%'?identified?by?'123';  Query?OK,?0?rows?affected?(0.07?sec)3.?退出再試  mysql>?quit  Bye  再試登錄：#?mysql?-u?root?-h?192.168.194.142?-pEnter?password:?  Welcome?to?the?MySQL?monitor.??Commands?end?with?;?or?g.  Your?MySQL?connection?id?is?3Server?version:?5.6.33?MySQL?Community?Server?(GPL)  Copyright?(c)?2000,?2016,?Oracle?and/or?its?affiliates.?All?rights?reserved.  Oracle?is?a?registered?trademark?of?Oracle?Corporation?and/or?itsaffiliates.?Other?names?may?be?trademarks?of?their?respective  owners.  Type?'help;'?or?'h'?for?help.?Type?'c'?to?clear?the?current?input?statement.  mysql>?  成功啦！    下面詳細(xì)說說如何給用戶授權(quán)。  mysql>?grant?權(quán)限1,權(quán)限2,?...?權(quán)限n?on?數(shù)據(jù)庫名稱.表名稱?to?用戶名@用戶地址?identified?by?'連接口令';  權(quán)限1，權(quán)限2，...?權(quán)限n?代表?select、insert、update、delete、create、drop、index、alter、grant、references、reload、shutdown、process、file?等14個(gè)權(quán)限。  當(dāng)權(quán)限1，權(quán)限2，...?權(quán)限n?被?all?privileges?或者?all?代替時(shí)，表示賦予用戶全部權(quán)限。  當(dāng)?數(shù)據(jù)庫名稱.表名稱?被?*.*?代替時(shí)，表示賦予用戶操作服務(wù)器上所有數(shù)據(jù)庫所有表的權(quán)限。  用戶地址可以是localhost，也可以是IP地址、機(jī)器名和域名。也可以用?'%'?表示從任何地址連接。  '連接口令'?不能為空，否則創(chuàng)建失敗。    舉幾個(gè)例子：  mysql>?grant?select,insert,update,delete,create,drop?on?vtdc.employee?to?joe@10.163.225.87?identified?by?‘123′;  給來自10.163.225.87的用戶joe分配可對數(shù)據(jù)庫vtdc的employee表進(jìn)行select,insert,update,delete,create,drop等操作的權(quán)限，并設(shè)定口令為123。    mysql>?grant?all?privileges?on?vtdc.*?to?joe@10.163.225.87?identified?by?‘123′;  給來自10.163.225.87的用戶joe分配可對數(shù)據(jù)庫vtdc所有表進(jìn)行所有操作的權(quán)限，并設(shè)定口令為123。    mysql>?grant?all?privileges?on?*.*?to?joe@10.163.225.87?identified?by?‘123′;  給來自10.163.225.87的用戶joe分配可對所有數(shù)據(jù)庫的所有表進(jìn)行所有操作的權(quán)限，并設(shè)定口令為123。    mysql>?grant?all?privileges?on?*.*?to?joe@localhost?identified?by?‘123′;  給本機(jī)用戶joe分配可對所有數(shù)據(jù)庫的所有表進(jìn)行所有操作的權(quán)限，并設(shè)定口令為123。    FLUSH?PRIVILEGES;