摰鋆摰Mysql 敺閮剖 :
S0 S2 P2 z: d0 _脖甇亥身摰 MySQL! P$ K: m2 O1 }# }6 E. v0 O
A.! n' Z7 L" H6 F9 V; W$ ~
閮剖php.ini(/etc/php.ini)
0 l; r( B) [0 S: Vphp.ini4 ]! k' ?0 R& L
1 memory_limit = 128M //PHP舐刻園銝: j8 N: g6 J! v7 U1 S
2 display_errors = Off //憿舐內航炊閮
- D( p# Y) ?4 ?0 D" m) P3 date.timezone = Asia/Taipei //(銵閬閮剖嚗銝賀HP雿輻典唳賣豢航炊閮)3 ?) R$ V: l) p, V$ J- R9 h
4 session.cookie_lifetime = 0 //session摮瘣餅(桐蝘嚗0隞銵典瘣餉喟閬賢券)
1 F3 i X2 D4 W3 {. s( }3 W# I. n" v! P7 }0 b+ I) A3 \
B.
! v# j% o- ~8 U5 w4 B閮剖my.cnf(/etc/my.cnf)# _. }6 U5 d3 r R8 a5 |, ]. l
my.cnf :
! I% z6 d7 ?4 ]( `: ?1 log-error=/var/log/mysqld.log //亥摮曆蝵
( g# F# X! q- S2 @2 connect_timeout = 15 //蝺timeout- C9 b4 H! \3 N' a; A
3 max_connections = 3000 //憭折蝺, K! @+ X2 `" X) k6 E, z1 [
4. service mysqld restart' e; v9 p- f4 Z4 Q2 t; U! f9 x; f
( X& C% @5 z. A# B; O0 C
& P7 [& F# x& \C.
3 _5 J2 q' y" a( s; {( D# f9 s閮剖 MySQL 鞈摨怎恣 root 撣單嗥撖蝣潘瑁sudo mysql_secure_installation嚗隞雿摨銝撟曆辣鈭! B3 E7 P5 v- \3 X6 U5 _3 g: }' u Z+ P/ G
1. Enter current password for root (enter for none): // 湔交 Enter嚗粹閮剜撖蝣
6 O, D% A4 h' U2. Set root password? [Y/n] //頛詨 Y 靘閮剖撖蝣
1 [, K6 U2 U: X# }. A7 ~3. New password: // 頛詨 root 啣蝣
: D" M7 O# m2 \3 X( P5 P4 x( \4. Re-enter new password: // 銝甈∟撓 root 啣蝣
5 S, \5 f" X* v" a" j5. Remove anonymous users? [Y/n] //閮 Yes 嚗湔交 Enter
4 H5 m9 c) u- v9 Q7 Z! X/ `+ e6. Disallow root login remotely? [Y/n] //閮 Yes 嚗湔交 Enter& u& b ~! d% _+ }
7. Remove test database and access to it? [Y/n] //閮 Yes 嚗湔交 Enter
" w$ \ E+ o: ^8. Reload privilege tables now? [Y/n] //閮 Yes 嚗湔交 Enter
4 h; G. I: h8 a7 H9 `, }- j% @- }8 B0 O2 s" S. S1 t+ s+ Y2 {
& s% P% V1 ]5 |' [9 n. [
亥拍典閮剖 root 撖蝣潛餃 MySQL嚗瑁sudo mysql -u root -p嚗撖蝣潭迤蝣箏停脣乓mysql>璅蝷箇泵
* i% ]- Q3 F2 p& m 瑁豢閬券鞈摨
. K4 y6 `- t, ]mysql> use mysql
; Z ]+ K4 F d) b3 H
7 Y- Q" z6 [0 z3 L 瑁select host,user from user ;閬蝯撠暹瑁, c( h7 }$ p! {- J. L. E* A4 n
mysql> select host,user from user ;
( D! E; a6 L% Y- M& w+ M4 k) {+ k+-----------+------+) a! O4 u( N" ~2 e' `
| host | user |
3 k; F" _, T# \) L+-----------+------+
6 }5 c/ M. _2 k, r| 127.0.0.1 | root |+ R: x5 z* J3 g. @; F
| localhost | root |
- e; g2 O/ y- e7 X) P+-----------+------+ F& h' n& S, S3 b- q
2 rows in set (0.00 sec)
. t0 A# c) \% U9 l+ l3 v; g! N, d2 i( @. [' F& k/ b7 F5 x
啣銝雿輻刻% t; \7 r8 A0 C- @: B$ ] R8 Y
insert into user (host,user,password) values ('%','your_account',password('your_password'));9 h) f9 j! D2 m! Z$ i+ Q
3 w, m) C9 w. j# K6 ^/ G餅閰脖蝙刻蝞∠甈嚗璅雿賣颲行蝡航 嚗 root 蝡舐餃亥◤鈭嚗
0 N/ n" U; {. p. r& K& rGRANT ALL ON *.* TO 'your_account'@140.112.1.1 IDENTIFIED BY 'your_password' WITH GRANT OPTION;
_1 q: X' d/ m& @! X0 x/ [銝嗅撣唾嚗芣臭祈摨思蝙刻撣唾嚗銝瘝隞颱甈' w2 d) b! g; N4 q: P0 `1 c
餉閮剖
3 J* a/ {+ g' t1 Y; r- X7 d% U9 W' d. }FLUSH PRIVILEGES;
2 p( d3 ]% M1 b: P& \摰鋆摰Phpmyadmin ,run http://www.domain.com/dbadmin show error : The mbstring extension is missing. Please check your PHP configuration.; S, h) k$ g, K4 J% u% i
隢摰鋆
" x# F) ]9 x0 p2 S7 E; w
- K) \" @5 }( r$ y) Kyum -y install php-mbstring
7 u/ k3 O& o- ]+ ^
9 Z% r# T* x( Z: E亙箇曄撩撠mcrypt嚗隢摰鋆
- m" ^7 G# x5 `: h* c( U5 k
) ^' n/ e+ A& O, pyum -y install mcrypt
) Y. b! J" l# f* x( Fservice nginx restart( q: ^# m( `. K$ X+ n8 g. E! h
Login phpadmin 敺箇 error:蝻箏 mysqli 游憟隞嗚隢瑼Ｘ PHP 閮剖Solution:
1 a1 V1 ?( A2 J" {0 ]0 iphp -m | grep mysqli ===> confirm mysqli module is installed
0 K& W6 o: |; J# G D2 {1 S% |php -i | grep extension_dir ===> 撠曉辣隡貊桅
0 `4 f2 r; {0 k8 Dyum -y install php-mysql ( yum install php5-mysqli) ===> ok
. b- w3 B' @' x; X+ N( k& I5 E蝻箏 mcrypt 游憟隞嗚隢瑼Ｘ PHP 閮剖% `2 M8 Q: f6 U; b. ^) {4 X
yum install php-mcrypt0 Y) x8 F ]7 T0 V4 \+ g4 G
yum install libmcrypt libmcrypt-devel ===> ok
6 G$ q0 v5 D7 d0 z9 a* z4 @* T( p
" n0 D2 q2 H% [3 L |
|
潸” 2015-6-21 23:10:33
嗉
鈭
霈
