摰鋆摰Mysql 敺閮剖 :
$ J& d) @& j( Z1 r) v. P脖甇亥身摰 MySQL
! }$ O- G3 q5 ^$ f+ aA.5 L8 w' L" U; Q. t, i7 r% B' ~7 E/ Z& e
閮剖php.ini(/etc/php.ini)
9 E4 o- F0 a) v T; }php.ini
2 W& D7 D& z0 Z+ Q* v7 C1 memory_limit = 128M //PHP舐刻園銝
& p% i: \7 c( f) V+ f2 display_errors = Off //憿舐內航炊閮
" z( ?: i( x" q# |0 |1 i3 date.timezone = Asia/Taipei //(銵閬閮剖嚗銝賀HP雿輻典唳賣豢航炊閮)$ ~% u' q+ k4 b) z
4 session.cookie_lifetime = 0 //session摮瘣餅(桐蝘嚗0隞銵典瘣餉喟閬賢券), R: ^5 `9 ~% L
+ L% Y2 X4 ?8 B3 k$ r
B.0 o& W1 F6 z. @' ^, J
閮剖my.cnf(/etc/my.cnf)
0 F9 D5 F! u. v1 Y9 m; V8 @/ ]my.cnf :
& D1 Z- {! t: K2 n7 C- s) i1 log-error=/var/log/mysqld.log //亥摮曆蝵1 P/ `2 ]% x% ~) d( w6 r
2 connect_timeout = 15 //蝺timeout
! _% `# U( k8 w/ X/ k. C# O1 {5 o3 max_connections = 3000 //憭折蝺- g. G2 o! J" q6 u
4. service mysqld restart
c2 ?* ]& ?9 L4 X$ U
: e4 \+ v& V0 t1 N* y! N+ ^8 N8 _; Z
8 P1 d) D% _# D) x- {; s2 jC.
2 r8 Q; g" v6 _& j# }- \. ~, e# T1 f# d閮剖 MySQL 鞈摨怎恣 root 撣單嗥撖蝣潘瑁sudo mysql_secure_installation嚗隞雿摨銝撟曆辣鈭
/ Z( w1 K# ~8 @1 s% A2 g1. Enter current password for root (enter for none): // 湔交 Enter嚗粹閮剜撖蝣
5 A. F t+ A$ M( @& J; ~& m1 F2. Set root password? [Y/n] //頛詨 Y 靘閮剖撖蝣2 Y p4 k& D$ o% h9 r: ^
3. New password: // 頛詨 root 啣蝣
8 S, Y4 Z6 G- P! E+ F9 E4. Re-enter new password: // 銝甈∟撓 root 啣蝣: O, k& H! Q- ?& ?+ @0 ]1 H' P' @2 E
5. Remove anonymous users? [Y/n] //閮 Yes 嚗湔交 Enter
4 Z3 o% m% {- \5 V* |6. Disallow root login remotely? [Y/n] //閮 Yes 嚗湔交 Enter6 Z% P% p) f2 J& ^7 M
7. Remove test database and access to it? [Y/n] //閮 Yes 嚗湔交 Enter. Z6 @, S3 Y# k1 R8 |* ]; E2 E; @8 b
8. Reload privilege tables now? [Y/n] //閮 Yes 嚗湔交 Enter
A( a: {2 A# c8 F6 O' T4 k
5 M, ]6 r/ y' f1 }1 P/ ^6 r: ~, d4 M3 C. |8 i3 A- i! {: o
亥拍典閮剖 root 撖蝣潛餃 MySQL嚗瑁sudo mysql -u root -p嚗撖蝣潭迤蝣箏停脣乓mysql>璅蝷箇泵* V. b4 g- A/ h0 G" X) u( R u
瑁豢閬券鞈摨5 y! C5 [% ?- o: O
mysql> use mysql7 [* s5 O2 V! D
) O% `/ Y7 \3 P9 M7 s+ G
瑁select host,user from user ;閬蝯撠暹瑁 Q! @/ [( F2 ]5 J5 A
mysql> select host,user from user ;$ B! l6 h$ o4 ^* f g: ~
+-----------+------+- p6 P9 s5 Y* A# z) W+ A1 M
| host | user |1 N; c5 W; r2 E, H9 ^
+-----------+------+
2 w1 \2 Y H3 L$ Z4 d! h| 127.0.0.1 | root |
& Q/ a; y+ A4 b! _5 h! z6 ]4 ?, p| localhost | root |) {& ~* v; |" \8 z2 m9 h7 x! `
+-----------+------+
& n1 x f7 r; O' i2 rows in set (0.00 sec)5 O4 W9 G- @2 u+ `) R" o
* J$ t i U- I$ D3 g
啣銝雿輻刻
7 R/ l- b8 F0 d3 Q) `0 Z7 \insert into user (host,user,password) values ('%','your_account',password('your_password')); u. L2 {" g J2 |: v+ p9 e" B& W
7 H1 }0 ]6 W. X" X( ]* {- i( p
餅閰脖蝙刻蝞∠甈嚗璅雿賣颲行蝡航 嚗 root 蝡舐餃亥◤鈭嚗 % o/ ^7 S+ m- h4 x" C; W
GRANT ALL ON *.* TO 'your_account'@140.112.1.1 IDENTIFIED BY 'your_password' WITH GRANT OPTION;+ Q2 a! N2 c5 C$ \
銝嗅撣唾嚗芣臭祈摨思蝙刻撣唾嚗銝瘝隞颱甈$ B, Z; X- m+ _% w& V8 I5 k
餉閮剖* w" \2 v' O* J; V3 F8 K' E
FLUSH PRIVILEGES;& g9 h+ v4 \, N3 @* O
摰鋆摰Phpmyadmin ,run http://www.domain.com/dbadmin show error : The mbstring extension is missing. Please check your PHP configuration.
; B7 V3 y9 j$ X# `; V# T2 k隢摰鋆) P0 F1 b X* U* C; W6 v: z
, y- @0 \# f v2 X; c5 a1 |# _yum -y install php-mbstring6 ~0 X# J; P O. `1 C
3 U# ^- D; t: @8 C
亙箇曄撩撠mcrypt嚗隢摰鋆4 r1 Z6 F% ^- g7 m. Z3 C4 O
4 d$ _# w4 @) m4 F# N: k
yum -y install mcrypt
* ], b' [$ d1 F6 h: Hservice nginx restart" S& L* K4 c1 a
Login phpadmin 敺箇 error:蝻箏 mysqli 游憟隞嗚隢瑼X PHP 閮剖Solution:
Z- R2 I2 {( e I3 vphp -m | grep mysqli ===> confirm mysqli module is installed7 O8 o# w i% m9 H! ~& o0 G
php -i | grep extension_dir ===> 撠曉辣隡貊桅! b" W4 K" y6 r9 u/ U7 o
yum -y install php-mysql ( yum install php5-mysqli) ===> ok, a& b( h9 V6 l& a. M4 a
蝻箏 mcrypt 游憟隞嗚隢瑼X PHP 閮剖
9 D, S) [8 D L; _. [- M/ o8 Syum install php-mcrypt3 i- m7 X1 p; g+ n, I
yum install libmcrypt libmcrypt-devel ===> ok$ K# V, M: X3 u) }
' Q( N7 \. @3 l
$ I; T, K$ F, `4 T! w1 {! s
|
|