酥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').
5 j- u: Z0 j4 l& j! J9 e D p$ w" Y3 N6 {
臬歉hp 5.3隞亙撖蝣潭16雿蝺函Ⅳ,啁php 5.3隞亙41雿蝺函Ⅳ,mysql 5.2 隞亙閮凋16蝣,隞交甇斤車航炊.
* Y3 ^% A( X0 o3 a6 j) ^% f8 ` x X閮箸瑚銝mysql: (php 5.6.38 , mysql 5.1.73)
; \( z6 x# o3 H6 R! r& I$ O3 H& t [9 w餃叮ysql 嗅頛詨 : + `0 C) ^: w: O
mysql> SHOW VARIABLES LIKE 'old_passwords';
, B0 p u3 R8 a c* b _: v+------------------+-------+8 l9 b4 b, A2 i% L# e8 w
| Variable_name | Value |
. X* p2 c: J. {2 N- {& D7 h+------------------+-------+
. j6 ]- e5 C6 S/ g1 z2 w' k| old_passwords | ON |9 r, [ i4 f ?/ n
+------------------+-------+% H: u3 l* p' U* O
1 row in set (0.00 sec)
9 a( N) z; I. y0 K {# h3 s, O( L% ?7 T
old_password ==> ON 撠梯”蝷 /etc/my.cnf 鋆 old_passwords=1 閮剖16蝣,撠摰閮剔 0 嗅mysqld ==> service mysqld restart$ g8 k& n1 T+ O( z; c' A& j
mysql prompt銝頛詨:1 u8 C. _5 r7 }3 H( ~" b
mysql> SET old_passwords=FALSE; 6 n: P ]5 p# Q: }# f% W+ R
瑼Ｘ叮ysql.user 瘥撖蝣潮瑕漲:
" g% f1 ]7 k& t0 _5 }* N& e, `4 y* Lmysql> SELECT 'User', 'Host', Length('Password') FROM mysql.user;% G! I' N8 z. R1 u) Z$ ^( S2 ~$ Y
憒瘝寞41雿,Length('Password')甈雿閰脤賣160(銵函內瘝閮剖蝣) L5 q$ g& ~& K! u
$ m5 A3 O& X& d0 z5 i閮剖靘撖蝣:
( Z( n' K; \7 Umysql> SET PASSWORD FOR 'root'@'192.168.1.1' = PASSWORD('靘撖蝣'); // 撠敹閬詨靘 撣唾@IP 湔,銝閬寥臭; `2 W8 d& O n' R$ g
mysql> flush privileges;4 T& s: ~9 [/ ]- h8 b1 `& H* V& S
! i$ c: i" x s% o/ C( u頛詨 SELECT 'User', 'Host', Length('Password') FROM mysql.user; 瑼Ｘ亙蝣澆漲,撠勗舐潛曉寧root 撖蝣潮瑕漲撌脫寧41蝣
2 K4 S, n1 p7 [# h$ f% _瘜冽:
+ d7 D! |( t5 Z; s( I# O5 d憒撣唾憭芸,臭誑啣憿閮剖蝣,粹閮剖蝣 SET PASSWORD FOR 芷撠亙蝣,銝 old_passwords=0 撠撖蝣潮敶梢===========================================================================
, `. s) m; j% W# E1 M鄉ysql蝝 8.0.21,php逅ysql箇2銵errors:
, h' k( t X/ vmysqli_real_connect(): Server sent charset (255) unknown to the client. Please, report to the developers
3 J+ Q9 | M# ^3 I, q+ Tmysqli_real_connect(): (HY000/2054): Server sent charset unknown to the client. Please, report to the developers
3 H# z0 `9 ^/ I* n, i:
5 N$ i' M: o! E9 F決ySQL 8.0.21銝哨caching_sha2_password舫隤頨思遢撽霅隞塚銝臭誑敺mysql_native_password隞亙php銝詨捆臭誑蝝php嚗銋臭誑靽格遍ySQL蝵柴 曆犖瘙箏靽格遍ySQL蝵:& [0 X1 n/ Y- P6 d! f! C& g( u6 z$ D
vi /etc/my.cnf 乩:* b! `- j2 V# ]/ T7 U) q
[mysqld]& D4 n9 s, }# P. |4 o$ V
: Q* O: ?' X( k a2 x- b1 l- y
character-set-server=utf81 w$ B! h' h# s3 v
default_authentication_plugin=mysql_native_password( G7 y5 L& W% K: N, M7 V. q
: J) ?- J5 f% O4 k3 w* X
[mysql]4 L! e7 H7 ~: S( T. t/ P
default-character-set=utf8
& \, z3 n% L* ?$ o f3 h! }, \
1 T% R. W" Z' L1 u! _[client]
) c, M; F# s3 ?5 [& p* ? {4 adefault-character-set=utf8
& M* _+ I, f ~- [$ e+ U+ P& J" X1 N7 p- U1 y& M4 h" f* X
嗅mysqld
4 ] Z7 k7 l! I( m$ c3 zservice mysqld restart
9 b2 A4 y& ]1 M' ]摰!!
+ a' |& Y- B" T. q1 l* `* o1 V2 |3 q. R
2 N# T/ i) ?2 t) ~3 L0 a$ R |
|
潸” 2018-10-11 12:57:07
嗉
鈭
霈
