摰鋆摰Mysql 敺閮剖 :
# s; ~( Q% M' y8 ~5 e脖甇亥身摰 MySQL
1 a8 H' ^+ l2 H* ?" {A.9 B0 N" X& v# i& x O
閮剖php.ini(/etc/php.ini)
' T$ j. c& J, S& W$ U; Cphp.ini
! P/ M! }6 D$ B8 h/ u1 f1 memory_limit = 128M //PHP舐刻園銝
5 y0 Y: l9 t% u) g* X2 f2 display_errors = Off //憿舐內航炊閮; |( m' x$ N* i h5 v6 x" U
3 date.timezone = Asia/Taipei //(銵閬閮剖嚗銝賀HP雿輻典唳賣豢航炊閮)
, p( `+ b3 q! x/ r" u. ^/ P4 session.cookie_lifetime = 0 //session摮瘣餅(桐蝘嚗0隞銵典瘣餉喟閬賢券)1 l6 J% j, Z6 S. i2 }
. ~) L5 q- y1 ~! V$ SB.
+ \( x: j; J, g* A7 v閮剖my.cnf(/etc/my.cnf)3 `* x$ U0 Y4 }$ ^- Z8 P
my.cnf : - n' Z- i2 }6 C) V6 E) \
1 log-error=/var/log/mysqld.log //亥摮曆蝵8 q( n" k+ U" I5 Q7 ~
2 connect_timeout = 15 //蝺timeout* g4 U' Q0 u# ~$ i1 B, f+ _
3 max_connections = 3000 //憭折蝺8 g: f/ ^3 u" l+ B- X' ]
4. service mysqld restart
, z. x/ }7 r5 @
2 @+ H8 Z. I% E1 r+ ?' G- p0 }: x% y( }% x6 r" U% U
C.
$ W( T5 f7 E) S: i9 {% {# ~5 e {閮剖 MySQL 鞈摨怎恣 root 撣單嗥撖蝣潘瑁sudo mysql_secure_installation嚗隞雿摨銝撟曆辣鈭
' J+ G/ {% ]' m/ P- z7 E, b8 D1. Enter current password for root (enter for none): // 湔交 Enter嚗粹閮剜撖蝣
0 J# W$ V; H# d# _% A1 z$ c- R2. Set root password? [Y/n] //頛詨 Y 靘閮剖撖蝣; C/ o, R/ G w* k* Y/ F/ ?
3. New password: // 頛詨 root 啣蝣
n' ] }6 F8 H) B6 M; V% s4 ]4. Re-enter new password: // 銝甈∟撓 root 啣蝣, o" w7 W( ?; X1 f
5. Remove anonymous users? [Y/n] //閮 Yes 嚗湔交 Enter' Z9 L4 U9 Z7 z
6. Disallow root login remotely? [Y/n] //閮 Yes 嚗湔交 Enter1 ?) O7 z$ R1 \, V; Y, P
7. Remove test database and access to it? [Y/n] //閮 Yes 嚗湔交 Enter
; ], w v% a" G8 K8 _7 n% y2 u/ g8. Reload privilege tables now? [Y/n] //閮 Yes 嚗湔交 Enter6 _. X: J% u. O
3 ?% A$ N3 b2 E( c# B# k+ `
8 v3 @; E$ B9 y% n! v亥拍典閮剖 root 撖蝣潛餃 MySQL嚗瑁sudo mysql -u root -p嚗撖蝣潭迤蝣箏停脣乓mysql>璅蝷箇泵6 m' g& B" R+ v8 ~% r( ~% I+ n
瑁豢閬券鞈摨2 R" Q' Y& v l- J
mysql> use mysql
, Q M0 d- W+ v* M: o- j' s2 q( u
瑁select host,user from user ;閬蝯撠暹瑁/ F) h1 L& ]1 R
mysql> select host,user from user ;
$ r! v1 I' E2 R$ H+ ]5 ?* I) `+-----------+------+5 X7 m% a; ^; I
| host | user |
# k0 c; I! {0 C: i+-----------+------+4 G+ y9 _) c; E& l0 a k! z
| 127.0.0.1 | root |
3 @' M2 n. m8 T3 |. K' [| localhost | root |
5 ^( h' V. z h1 Y0 N* v/ J+-----------+------+
' b& X) |: }1 m# X2 c2 rows in set (0.00 sec)
$ W$ I1 [( [; h; t& U7 d4 W k1 A9 }4 U- l: A
啣銝雿輻刻
9 z8 c5 l! \3 xinsert into user (host,user,password) values ('%','your_account',password('your_password'));0 H/ v: o- v0 B; N+ \
[/ _6 ?0 }6 \
餅閰脖蝙刻蝞∠甈嚗璅雿賣颲行蝡航 嚗 root 蝡舐餃亥◤鈭嚗
I1 F6 |2 A' H1 L9 v+ k x- ]GRANT ALL ON *.* TO 'your_account'@140.112.1.1 IDENTIFIED BY 'your_password' WITH GRANT OPTION;
7 ?1 R; l; |8 z6 y7 \銝嗅撣唾嚗芣臭祈摨思蝙刻撣唾嚗銝瘝隞颱甈0 C6 R3 |" ?0 m" g Q6 {4 U
餉閮剖. V: z- P' ^ L. v: m) f* a& A
FLUSH PRIVILEGES;
0 U0 @: {' g0 E3 Z' q5 c- U7 {摰鋆摰Phpmyadmin ,run http://www.domain.com/dbadmin show error : The mbstring extension is missing. Please check your PHP configuration.
9 P: O4 T2 q- h隢摰鋆
; r& { F- s) X" |; d5 B- H 7 }& M' w# C7 m% H7 U
yum -y install php-mbstring3 d$ G5 |: J/ x# o1 F
3 k, }6 Y6 Z/ Y; ^2 G5 j
亙箇曄撩撠mcrypt嚗隢摰鋆
, \/ o+ E, S6 E \1 z' O
, ]" @3 I0 p) i# ?yum -y install mcrypt8 S6 `) K( J' G! Y# f
service nginx restart8 N) {* w0 E* g6 z7 O$ M1 k
Login phpadmin 敺箇 error:蝻箏 mysqli 游憟隞嗚隢瑼Ｘ PHP 閮剖Solution:: [) v$ o& u* @0 Z+ L! e" {
php -m | grep mysqli ===> confirm mysqli module is installed
% X" s- A! {$ V3 U+ ^php -i | grep extension_dir ===> 撠曉辣隡貊桅) P" [$ n: a. M/ N$ a
yum -y install php-mysql ( yum install php5-mysqli) ===> ok
1 m4 }* ?5 Z4 J3 q蝻箏 mcrypt 游憟隞嗚隢瑼Ｘ PHP 閮剖/ L4 w8 {. T) K
yum install php-mcrypt
# y: L' k* a; v9 H }; L5 yyum install libmcrypt libmcrypt-devel ===> ok. C% j# a7 c g! J9 A2 B; ~
) m# G0 [. I! M4 y4 d: L
8 V. q6 m9 c, o: k+ |* O' @+ ~1 I |
|
潸” 2015-6-21 23:10:33
嗉
鈭
霈
