酥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').
, c$ x; M5 t; W ?* ?
$ n% v7 f, N X臬歉hp 5.3隞亙撖蝣潭16雿蝺函Ⅳ,啁php 5.3隞亙41雿蝺函Ⅳ,mysql 5.2 隞亙閮凋16蝣,隞交甇斤車航炊.
; {4 j8 _% {: M閮箸瑚銝mysql: (php 5.6.38 , mysql 5.1.73)
1 N5 T# x* ~3 _餃叮ysql 嗅頛詨 : & b0 g- m( ~! d2 j8 E
mysql> SHOW VARIABLES LIKE 'old_passwords';
% _! Q( \$ @# R* `, L7 r+------------------+-------+
: J. I# G6 l) x6 t| Variable_name | Value |
4 J) O% v e% Q5 p6 @. D: ]( i+------------------+-------+
' U; V# E* k H| old_passwords | ON |
, T+ m0 m9 A7 R+------------------+-------+
- @, c' c. F% ?1 row in set (0.00 sec)- w# X& H' U3 ^: d; e/ G1 f5 }
, O8 B7 K6 R6 o: Wold_password ==> ON 撠梯”蝷 /etc/my.cnf 鋆 old_passwords=1 閮剖16蝣,撠摰閮剔 0 嗅mysqld ==> service mysqld restart
* w! s3 _- l) U7 X mysql prompt銝頛詨:
+ G' @6 q; }( |$ i% o/ @' umysql> SET old_passwords=FALSE;
; `- _) E9 m( X+ f* h瑼Ｘ叮ysql.user 瘥撖蝣潮瑕漲:
" Z4 \; y/ r2 `6 J/ O/ xmysql> SELECT 'User', 'Host', Length('Password') FROM mysql.user;
0 \2 v( ?' n8 N憒瘝寞41雿,Length('Password')甈雿閰脤賣160(銵函內瘝閮剖蝣)
1 J+ x4 p; i! ^4 a5 ]: c& U+ C4 d5 c+ v1 g' y; j7 f
閮剖靘撖蝣:. e% ]2 B( V; j7 z
mysql> SET PASSWORD FOR 'root'@'192.168.1.1' = PASSWORD('靘撖蝣'); // 撠敹閬詨靘 撣唾@IP 湔,銝閬寥臭
" v+ H# v% d+ K% }% K+ g! bmysql> flush privileges;5 |# U- J) x2 ?4 v7 W' Z7 Z# m
: N4 D2 k) @$ p* P$ a$ n6 @5 W$ T
頛詨 SELECT 'User', 'Host', Length('Password') FROM mysql.user; 瑼Ｘ亙蝣澆漲,撠勗舐潛曉寧root 撖蝣潮瑕漲撌脫寧41蝣
2 u$ v; K! f2 p( d. x4 Z# J瘜冽:
- S5 _+ B k& I* Z4 X憒撣唾憭芸,臭誑啣憿閮剖蝣,粹閮剖蝣 SET PASSWORD FOR 芷撠亙蝣,銝 old_passwords=0 撠撖蝣潮敶梢===========================================================================
" T; g2 [& q$ O' H* z/ Z鄉ysql蝝 8.0.21,php逅ysql箇2銵errors:7 |% u5 U7 \) |" \( d4 G$ S
mysqli_real_connect(): Server sent charset (255) unknown to the client. Please, report to the developers
5 S+ i# R! _& ?9 Z& Qmysqli_real_connect(): (HY000/2054): Server sent charset unknown to the client. Please, report to the developers5 |' A6 k2 F6 W$ a- E' P- @
:
# I: o% ?5 U' Z決ySQL 8.0.21銝哨caching_sha2_password舫隤頨思遢撽霅隞塚銝臭誑敺mysql_native_password隞亙php銝詨捆臭誑蝝php嚗銋臭誑靽格遍ySQL蝵柴 曆犖瘙箏靽格遍ySQL蝵: H4 v8 L: j" q3 x
vi /etc/my.cnf 乩:5 O1 J. M. T5 @2 p. B& B
[mysqld]
8 R9 @. Z @( J* u% Y
& N0 l) L+ A/ W' d- h) V/ N; Dcharacter-set-server=utf8
9 t. w p* z5 G$ N$ e& c7 T% \. Sdefault_authentication_plugin=mysql_native_password! P) U; t" _1 T4 m( O
/ e7 U9 m/ h$ J! ^
[mysql]; O1 I7 e7 ?$ h2 b: C
default-character-set=utf8/ I: w" z) z, r+ l" h! ~# v5 b
) y* q5 y9 V5 V/ w% @[client]; n8 ^0 }- z# i) Q
default-character-set=utf88 X0 H) M# d' Q3 x5 _
2 u( i: u, a8 A" O嗅mysqld7 G; Y3 H/ s [& r
service mysqld restart
2 @% x: [ U% P3 n; [摰!!
+ t+ p- g; m- e3 j4 B% v
# ]. k7 Q- J2 W. c: |4 d; D7 I; F# g0 K
|
|
潸” 2018-10-11 12:57:07
嗉
鈭
霈
