(1)% n" e% p/ A( D _1 Z5 i! ]
php逅ysql箇2銵errors : (discuz蝬脤箇曄舫亙逅ysql航炊銵冽,芾撖思駁叮ysqlphp蝔撘靘皜祈岫)8 Y) G( L6 V, x8 R: |; q
6 L- I6 d4 _( D' g% {2 @! tmysqli_real_connect(): Server sent charset (255) unknown to the client. Please, report to the developers3 k1 ~+ H, n" ]8 d. R2 C0 R' C
mysqli_real_connect(): (HY000/2054): Server sent charset unknown to the client. Please, report to the developers- j, U5 M5 u7 m, @5 ]' S4 C/ {9 {
:' C- G- k! v4 M; G
決ySQL 8.0.21銝哨caching_sha2_password舫隤頨思遢撽霅隞塚銝臭誑敺mysql_native_password隞亙php銝詨捆臭誑蝝php嚗銋臭誑靽格遍ySQL蝵柴 曆犖瘙箏靽格遍ySQL蝵:; u% E' s n2 a: x/ m
vi /etc/my.cnf 乩:
$ T3 V ^" X: U" F n; u7 k[mysqld]
4 O& a4 S5 k+ B
# z, @" r" o; }* s, mcharacter-set-server=utf8
9 W5 K" b8 ^2 S; \+ ~default_authentication_plugin=mysql_native_password
$ y( s4 n9 H. X( Hvalidate_password.policy=LOW
) f+ c- ?! n, `6 z[mysql] ~- V" L' ~, T& O" r
default-character-set=utf8
* ?5 a% g4 u0 D. _: p- ~+ k3 X3 D _$ _ T1 p, J9 M0 `1 n
[client] G$ i* @0 E& I4 c: \# a$ w) u
default-character-set=utf8% R( W1 @3 n+ q7 D$ A3 } H
+ e; ^. ^7 k. U" D$ i# w' ]! H
嗅mysqld( s0 w, m3 o. f9 D! c2 l* ]" r
service mysqld restart
% e) e4 H0 H; w2 B- ^' f3 M
8 R j# y+ L5 U& ~5 ~- H& l敺航賡銝雿:
5 [- ~/ \ _0 K9 n9 Nmysql -u roor -p * J1 X5 l3 ^# \8 {! _* R
SHOW VARIABLES LIKE 'validate_password%';
+ ~* k! a4 O2 m- o# l$ k0 rSET GLOBAL validate_password_policy=LOW;ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '雿撖蝣';摰!!
1 W& s5 O9 k( S; Y. s
* }: Y( [3 _5 M9 v9 e: {% r閮: mysqld,/var/log/mysql/mysqld.log蝝:閮: 臭誑撖急皰hp蝔撘隞交葫閰 ~~~* a4 h0 i: H9 i
- <?. f: w' A( `- {. @
- $hostname = "x.x.x.x";
; W8 P2 i9 t/ \0 {) z) {1 } - $database = "db_name";
+ o% f2 ]# _% \( @& | D' _ - $username = "user_name";
: N% t" @, }# A5 x - $password = "pwd";
; l3 r2 m% k0 P - % L0 R0 P& w9 ]% b( `3 Y: i$ Y8 e
- $conn = mysqli_connect($hostname, $username, $password,$database) or trigger_error(mysql_error(),E_USER_ERROR);
# v: N. G( H/ d. P9 z' i - mysqli_query($conn ,"SET NAMES utf8");
' t9 v0 C5 `- ?& ~ ^ L7 d: ? - ' ^' G% D3 Y m: P- a
- $sql = "select count(*) as total from " . "table_name";6 d8 R3 k& ^* o( ?
- $rec = mysqli_fetch_assoc(mysqli_query( $conn,$sql));1 {7 `6 X, x% e' y8 L
- echo $rec['total'];9 k( R: W+ Q2 m- O2 J% A
- mysqli_close($conn);
4 b: |3 C& m" M! O) U7 A( F& u2 p& w - ?>
銴鋆賭誨蝣摰g砍梯批捆閬蝛擃 999999999999 舐閬踝函嗅蝛 0 : [5 s3 Y( o# q$ G9 r4 W, Z
# N) x7 V, y$ n) K4 ?- ~+ e/ C% }( k# ]+ t
酥hp 7.2.24 connect to mysql server,箇 : - PHP Fatal error: Uncaught Error: Call to undefined function mysqli_connect() in /test/connectmysql8.php:9
. \$ w1 s- u, y9 @: w' N - Stack trace:; Z/ l# ~& v4 P0 G) X9 d( L
- #0 {main}
2 E, j3 t9 [1 f/ o - thrown in /test/connectmysql8.php on line 9
+ _6 l2 y c8 D0 b+ {/ X
, U/ ^( A! d. ]! J% B- Fatal error: Uncaught Error: Call to undefined function mysqli_connect() in /test/connectmysql8.php:9' t" }6 \% X* @# B9 b- o: o! o |5 p
- Stack trace:
& P( T+ a3 R% z7 g0 B - #0 {main}! E5 a5 B `* E# N. d
- thrown in /test/connectmysql8.php on line 9
銴鋆賭誨蝣 舐祉訾憿,芾 yum install php-mysqlnd yum install php-mysqli 喳
4 h+ F$ p& E( P( `, Q" e( L
. Q* p y, M& V1 [' O/ b/ _, G/ h9 L; M7 N2 i# S
[Warning] [MY-013242] [Server] --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.9 E/ L2 g) t5 y! `1 B+ s/ u! u
隤芣: 砌賜批撱箄降"UTF8MB4",血⊥
( c& ?7 [/ G& ~: x
" |: ]' T9 F) ^1 R% m# m6 r* j5 |(2)
8 g* e! u6 B- a9 h3 C S(1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'system>0' at line 1/ e' ?& R7 a7 |$ E* B8 ]9 J7 o
SELECT COUNT(*) FROM common_usergroup WHERE type='special' and system>0
+ R ~5 c. E$ m0 s& Y8 p [
* [7 G, O' [6 K5 ^% P(1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'groups = '' AND starttime<=1532077291 AND (endtime>=1532077291 OR endtime=0) ORD' at line 1
! u) b$ U6 U: P Z8 \9 K1 fSELECT * FROM forum_announcement WHERE type!=2 AND groups = '' AND starttime<=1532077291 AND (endtime>=1532077291 OR endtime=0) ORDER BY displayorder, starttime DESC, id DESC LIMIT 1
5 o" @9 y$ x: k
& n9 h: n. U2 ^& t5 f( x撤ySQL 8.0+撠systemgroups雿箔萄嚗隞乩賜湔亙沒QL銝剖systemgroups拙閰雿箸豢摨怒豢銵具豢銵典畾萎葉隞餅銝蝔桐蝙剁憒豢摨怠豢銵典豢銵典畾萄雿輻其systemgroups雿箏摮嚗敹雿輻其撠撘撘刻絲靘撖思`system``groups`/ L8 V& l5 i. ]) B d! ]2 W1 m
, L* ]7 ?. L" g" o; y
蝚砌航炊閬曉蚤iscuz!桅銝剔source\class\table\table_common_usergroup.php嚗
3 L9 X L! y# ^9 d6 b1 b撠隞嗡葉system券冽寞`system`嚗靽摮敺唬喳唳函詨桅喳胯$ e2 u) P: `: S$ e2 E( J* ?
, W {: V$ g b0 s1 K. q# Y
蝚砌航炊閬曉蚤iscuz!桅銝銝剔source\class\table\table_forum_announcement.php嚗
4 p( s, Y6 a" ~; Z& l: G0 S$ N撠隞嗡葉groups券冽寧槁groups`嚗靽摮敺唬喳唳函詨桅喳胯1 `" j! N" U t" O
" V; t: @: ]/ Z# e; _2 X, x
憒決ySQL 8+啣銝摰鋆Discuz!嚗典鋆閬蝯夷nstall\data\install.sql隞嗡葉瘝撘system銝瘛餃銝撠撘靽摮唬喳唳函詨桅嚗血銋箇鋤QL隤瘜航炊; T3 ?5 |0 E# D; i' L+ v- X4 A
5 }( E# |, K' G, y! @
箔踹隤瘜航炊嚗典神SQL隤交嚗銝摰閬箸豢摨怠豢銵典豢銵典畾萄券冽溶銝撠撘嚗Discuz!璅撖急臬銝憒亦
' E* c( {0 F A0 i/ H ~隞乩: 蝝 MySQL 8.0+ 敺Discuz! 湔啁楨摮箇鋤QL隤瘜航炊, L$ O- k9 f9 O1 \ S- n- W
2 Y9 a- C( a [4 g
/ q% o0 L* D/ g) q
3 u1 g* `8 U6 P) R/ X4 b* F2 v
a* \1 W1 x( h0 N4 j |
|