程序師世界是廣大編程愛好者互助、分享、學習的平台,程序師世界有你更精彩!
首頁
編程語言
C語言|JAVA編程
Python編程
網頁編程
ASP編程|PHP編程
JSP編程
數據庫知識
MYSQL數據庫|SqlServer數據庫
Oracle數據庫|DB2數據庫
 程式師世界 >> 數據庫知識 >> MYSQL數據庫 >> 關於MYSQL數據庫 >> 新版Mysql密碼算法不同導致“Client does not support authentication protocol requested by server”錯誤

新版Mysql密碼算法不同導致“Client does not support authentication protocol requested by server”錯誤

編輯:關於MYSQL數據庫
一、軟件獲取
  apache_1.3.6.tar.gzPHP-3.0.8.tar.gzMySQL-3.22.21-pc-Linux-gnu-i686.
tar.gzPHPMyAdmin_2.0.1.tar.gz 從http://www.Htmlwizard.Net/PHPMyAdmin/取
得注意:以上均為源代碼而非RPM包
  二、軟件安裝
  以root登錄,將以上文件均拷貝至/root下1.安裝MySQL
  #tar -zvxf mysql-3.22.21-pc-Linux-gnu-i686.tar.gz 產生MySQL-3.22.
21-pc-Linux-gnu-i686目錄#mv MySQL-3.22.21-pc-Linux-gnu-i686
/usr/local/mysql 移到/usr/local/mysql#cd /usr/local/MySQL#./configure
--prefix=/usr/local/mysql#cdMySQL安裝完畢(我下載的是bin包)
  2.安裝apache及PHP3
  #tar xvzf apache_1.3.6.tar.gz 產生apache_1.3.6目錄#tar xvzf PHP-3.
0.8.tar.gz 產生PHP-3.0.8目錄#cd apache_1.3.6#./configure
--prefix=/usr/local/apache 把Apache的安裝目錄定為/usr/local/apache#cd .
./PHP-3.0.8#./configure --with-mysql=/usr/local/MySQL --with-apache=..
/apache_1.3.6 --enable-track-vars
  配置支持MySQL、作為apache功能模塊、跟蹤變量有效#make; make
installPHP安裝完畢#cd ../apache_1.3.6#./configure
--prefix=/usr/local/apache --activate-module=src/modules/php3/libPHP3.
a#make; make installapache安裝完畢#cd ../php-3.0.8#cp PHP3.ini-dist
/usr/local/lib/php3.ini 把PHP.ini文件拷到/usr/local/lib/目錄下.#cd
/usr/local/apache/conf#vi httpd.conf找到AddType application/x-httpd-PHP3
.PHP3把它前頭的#號給刪了當然也可加一行AddType
application/x-httpd-PHP3 .ASP這樣用FrontPage編輯會方便一點3.安裝
PHPMyAdminL
  #cd#tar -zvxf phpMyAdmin_2.0.1.tar.gz 產生PHPMyAdmin-2.0.1目錄#mv
phpMyAdmin_2.0.1 /usr/local/apache/htdocs/PHPMyAdmin 移到
/usr/local/MySQL#cd /usr/local/apache/htdocs/PHPMyAdmin#chmod a+r * 置為
可讀

  三、軟件運行
  啟動MySQL#cd /usr/local/mysql/#bin/safe_MySQLd &測試:
  #bin/mysql -u root 默認沒有設口令mysql>use mysql 打開MySQL數據庫
mysql>select * from user; 從表user中讀數據,別忘加;號MySQL>exit這樣就算
可以了,先不急著加口令
  啟動Apache/usr/local/apache/bin/apachectl start測試:
  #telnet localhost 80Trying 127.0.0.1...Connected to localhost.Escape
character is '^]'.HEAD / HTTP /1.1 輸入並加兩次回車
  HTTP/1.1 200 OKDate: Wed, 23 Jun 1999 02:51:27 GMTServer: apache/1.
3.6 (Unix) PHP/3.0.8Last-ModifIEd: Wed,
  1. 上一頁:
  2. 下一頁:
Copyright © 程式師世界 All Rights Reserved