酥hp 5.5隞乩 銝 mysql 5.2 嚗叮ysql隞 mysqli_connect() Y航炊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').
! d @ |+ v# v- _) k3 h$ P7 l$ I& r$ f" \
臬歉hp 5.3隞亙撖蝣潭16雿蝺函Ⅳ,啁php 5.3隞亙41雿蝺函Ⅳ,mysql 5.2 隞亙閮凋16蝣,隞交甇斤車航炊.8 w( l+ p9 n) E+ u2 ^% M
閮箸瑚銝mysql: (php 5.6.38 , mysql 5.1.73)0 A0 }0 N# a3 D* y; @
餃叮ysql 嗅頛詨 : ) g* m0 t5 N0 Z4 B" j# h ]
mysql> SHOW VARIABLES LIKE 'old_passwords';) h+ `9 G5 C( ~" \: {, n+ x$ q. B
+------------------+-------+
2 I5 ^% S; c4 \6 V| Variable_name | Value |& x1 \6 c# N8 B! C y2 T
+------------------+-------+( W7 s" x3 Z& r
| old_passwords | ON |5 a" M1 C9 S" z% O6 c0 L9 U! h
+------------------+-------+
" j0 _4 ~. }8 `$ E2 z; ?1 row in set (0.00 sec)
! m& U+ p% h. N) ^
' W1 g- q7 H! ?# G4 C+ Wold_password ==> ON 撠梯”蝷 /etc/my.cnf 鋆 old_passwords=1 閮剖16蝣,撠摰閮剔 0 嗅mysqld ==> service mysqld restart& j" g% J8 @# w* d1 Y, O4 f
mysql prompt銝頛詨:4 O5 ~$ e( Z0 \8 F2 q" L- s+ j. Q
mysql> SET old_passwords=FALSE;
! [1 x' P% Z3 M& }* P; {1 `瑼X叮ysql.user 瘥撖蝣潮瑕漲:2 e1 z0 |9 R: F4 o$ `$ g$ x$ K
mysql> SELECT 'User', 'Host', Length('Password') FROM mysql.user;
4 M% h, ^0 D! o憒瘝寞41雿,Length('Password')甈雿閰脤賣160(銵函內瘝閮剖蝣)
! Q H$ V. ^; L; j. A2 Z
7 N$ O4 t0 z) _: X$ k1 P閮剖靘撖蝣:
* W) n6 A! N" j {6 `mysql> SET PASSWORD FOR 'root'@'192.168.1.1' = PASSWORD('靘撖蝣'); // 撠敹閬詨靘 撣唾@IP 湔,銝閬寥臭2 ~- F* I( z& j) j
mysql> flush privileges;# s9 h# U' Z+ w( A7 m7 {
6 x& {0 Q5 {- ~+ M( I& O頛詨 SELECT 'User', 'Host', Length('Password') FROM mysql.user; 瑼X亙蝣澆漲,撠勗舐潛曉寧root 撖蝣潮瑕漲撌脫寧41蝣( I8 j% p7 h( q7 ~/ d& \6 m
瘜冽:
7 u8 v/ y* l, s7 p- q憒撣唾憭芸,臭誑啣憿閮剖蝣,粹閮剖蝣 SET PASSWORD FOR 芷撠亙蝣,銝 old_passwords=0 撠撖蝣潮敶梢===========================================================================$ s4 u1 ]* W/ U- w$ r
鄉ysql蝝 8.0.21,php逅ysql箇2銵errors:
) e5 Z2 }6 F: D( d8 Z$ S# E# Hmysqli_real_connect(): Server sent charset (255) unknown to the client. Please, report to the developers
& v; [2 p6 D4 D# Q" Fmysqli_real_connect(): (HY000/2054): Server sent charset unknown to the client. Please, report to the developers8 M7 j- o) @4 a: b- @1 O
:
. i/ L G b6 Z2 j) v決ySQL 8.0.21銝哨caching_sha2_password舫隤頨思遢撽霅隞塚銝臭誑敺mysql_native_password隞亙php銝詨捆臭誑蝝php嚗銋臭誑靽格遍ySQL蝵柴 曆犖瘙箏靽格遍ySQL蝵:
' s" `0 u ]9 Vvi /etc/my.cnf 乩:1 B+ R& m8 r8 }" P$ j6 K9 A. c; G
[mysqld]
5 Q! ^# A% n: s5 `' ^& J: w% @" I6 b
character-set-server=utf85 d, s1 H, k; }! ?
default_authentication_plugin=mysql_native_password
* R9 u0 y% d; k0 M" C k( R y& \' Q' k' R
[mysql]
H3 C' ]. s% L+ O* ydefault-character-set=utf8
2 P1 n$ q; v# R+ x. }& w5 t' \# S8 v5 v( Y
[client]
- T/ o9 U! k" W) N7 g+ i' ]# ^default-character-set=utf8
y# Q/ p: s1 o% y- W+ V: G# z/ ]& F6 J9 Y+ [8 u
嗅mysqld
; _) o) \- ^2 e" }service mysqld restart0 S. m1 X% l9 i9 |) t
摰!!! } b' J! k$ s0 L- D
" }: w, M2 a+ x- a# \$ m
" e$ h+ p+ q/ u! H |
|