酥hp 5.5隞乩 銝 mysql 5.2 嚗叮ysql隞 mysqli_connect() Ｙ航炊mysqli_connect(): mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication. Please use an administration tool to reset your password with the command SET PASSWORD = PASSWORD('your_existing_password').
2 h9 D3 `, b3 G- _2 W
2 K. m5 Q$ ?3 W臬歉hp 5.3隞亙撖蝣潭16雿蝺函Ⅳ,啁php 5.3隞亙41雿蝺函Ⅳ,mysql 5.2 隞亙閮凋16蝣,隞交甇斤車航炊.
! g- _# U+ k( {7 L- C+ r D9 d閮箸瑚銝mysql: (php 5.6.38 , mysql 5.1.73)
1 P" e# [7 a# Z; [: j: p5 L餃叮ysql 嗅頛詨 :
* p7 R, H b$ D S! s. smysql> SHOW VARIABLES LIKE 'old_passwords';
& L6 f; o' n; T f0 t H5 }+------------------+-------+
( J" k+ u3 D1 h9 [4 R+ C* ^| Variable_name | Value |) V- {2 c3 }+ n
+------------------+-------+# R, j: h% {. z
| old_passwords | ON |- K) n9 u9 r/ c4 V. I
+------------------+-------+: p f9 p! [5 Q% k3 F$ c# ]* W3 z5 l
1 row in set (0.00 sec)! ?* w) I+ l r* }, t* L0 g% a9 ~/ |, Z
% l5 G+ d+ E9 ?3 A+ T4 [old_password ==> ON 撠梯”蝷 /etc/my.cnf 鋆 old_passwords=1 閮剖16蝣,撠摰閮剔 0 嗅mysqld ==> service mysqld restart
4 y. H+ e8 M7 C W mysql prompt銝頛詨:2 u9 t: J, K$ ]6 w2 S$ y
mysql> SET old_passwords=FALSE; ) R% m* s# Q5 O
瑼Ｘ叮ysql.user 瘥撖蝣潮瑕漲:
; ?+ t7 p0 I* _+ f) p$ Wmysql> SELECT 'User', 'Host', Length('Password') FROM mysql.user;
1 P$ N- m( @3 z: \. x8 |, G7 N憒瘝寞41雿,Length('Password')甈雿閰脤賣160(銵函內瘝閮剖蝣)
|/ L4 u# I7 ^# T. x% L# k( P, b4 O3 l: e4 z7 a9 z
閮剖靘撖蝣:
$ j4 q- f4 ]% C, Jmysql> SET PASSWORD FOR 'root'@'192.168.1.1' = PASSWORD('靘撖蝣'); // 撠敹閬詨靘 撣唾@IP 湔,銝閬寥臭! E: T5 \4 d5 `5 R$ O
mysql> flush privileges;+ L; W9 Z( V5 o( p# n- k( t
4 k( E8 @( q0 f
頛詨 SELECT 'User', 'Host', Length('Password') FROM mysql.user; 瑼Ｘ亙蝣澆漲,撠勗舐潛曉寧root 撖蝣潮瑕漲撌脫寧41蝣
C/ M. V2 |' w瘜冽:0 a- d. g& h6 r
憒撣唾憭芸,臭誑啣憿閮剖蝣,粹閮剖蝣 SET PASSWORD FOR 芷撠亙蝣,銝 old_passwords=0 撠撖蝣潮敶梢===========================================================================6 t# K, Q; C$ I0 K* w: [# A
鄉ysql蝝 8.0.21,php逅ysql箇2銵errors:
- W1 q6 Q& T7 e1 M: Lmysqli_real_connect(): Server sent charset (255) unknown to the client. Please, report to the developers$ D# c: n6 L8 f* F2 q
mysqli_real_connect(): (HY000/2054): Server sent charset unknown to the client. Please, report to the developers' r! t9 Y2 \, U/ O1 Y2 E
:
2 L3 y- A; v7 U% O" X決ySQL 8.0.21銝哨caching_sha2_password舫隤頨思遢撽霅隞塚銝臭誑敺mysql_native_password隞亙php銝詨捆臭誑蝝php嚗銋臭誑靽格遍ySQL蝵柴 曆犖瘙箏靽格遍ySQL蝵:
4 x n* N U( o+ t4 W* z( L5 uvi /etc/my.cnf 乩:
W, b% Y6 Y: v) W' p B) R9 ?[mysqld]: A- ?% f+ b- P6 B2 h
6 D/ l+ O) v0 M7 f& x1 a3 t
character-set-server=utf8
" r( F6 p$ H3 |, B2 Bdefault_authentication_plugin=mysql_native_password
7 I2 P0 m% w1 n3 C1 W; V/ w, T6 s# n
[mysql]
) k) H5 x$ |6 J- N$ xdefault-character-set=utf8
+ c8 B) f/ l p, N- }+ A
: e `/ t+ x9 { T[client]% T6 `' l1 w) e# @0 T* e$ p3 R
default-character-set=utf8, { f9 b3 r* h9 ?/ o' J
4 ^, G3 F/ b, z
嗅mysqld
$ V$ A& r1 h' ?2 o; U1 cservice mysqld restart
* F2 {5 y/ {! Z摰!!, |+ y1 w( \; ]* h
5 O4 }; j- b5 D7 S/ B) Q) T$ O0 M
. A) S" k( S- f5 g( E' q, w ^ |
|
潸” 2018-10-11 12:57:07
嗉
鈭
霈
