摰鋆摰Mysql 敺閮剖 :9 X6 h! L) j9 D
脖甇亥身摰 MySQL
, d: x( h% E/ `A.
: |% t9 @1 s. u, p, [閮剖php.ini(/etc/php.ini)+ v2 O+ y/ w. ?* N
php.ini& ^( \, } r X9 L; I' t
1 memory_limit = 128M //PHP舐刻園銝8 |) X7 R& C6 l4 z
2 display_errors = Off //憿舐內航炊閮; R/ y6 _7 e+ k( }
3 date.timezone = Asia/Taipei //(銵閬閮剖嚗銝賀HP雿輻典唳賣豢航炊閮)
$ Z, N1 d4 L8 q4 session.cookie_lifetime = 0 //session摮瘣餅(桐蝘嚗0隞銵典瘣餉喟閬賢券) G& C2 q+ |% L2 [, h& B; j3 c
* ~; F. F( K( a- JB.
8 [8 u* r1 l) `) S閮剖my.cnf(/etc/my.cnf)$ G M2 F+ \4 l& J$ B) v7 M
my.cnf :
, ^! z9 A9 K' R% }% f, Z X4 N- H1 log-error=/var/log/mysqld.log //亥摮曆蝵0 P C* y! Y6 Z. |
2 connect_timeout = 15 //蝺timeout H2 G. ~' R+ X! A( A
3 max_connections = 3000 //憭折蝺
5 N8 m7 N9 }2 {( D4. service mysqld restart
: z, p- Q& q7 B
: |+ Y, U0 g3 y" |. _
: B1 b. U) E$ _' p3 r2 a6 ^0 ?9 l, eC.
, l. `9 e7 I# @& M閮剖 MySQL 鞈摨怎恣 root 撣單嗥撖蝣潘瑁sudo mysql_secure_installation嚗隞雿摨銝撟曆辣鈭
# E# ~% B0 Z, }2 H& u: u1. Enter current password for root (enter for none): // 湔交 Enter嚗粹閮剜撖蝣
1 A9 t3 k, {4 I" P8 n' h2. Set root password? [Y/n] //頛詨 Y 靘閮剖撖蝣
. \- N8 p8 ~2 E7 R) i# j; y( v3. New password: // 頛詨 root 啣蝣
" z: i! D: y" R3 O% ]6 L- q4. Re-enter new password: // 銝甈∟撓 root 啣蝣( A3 L1 U4 a5 N: g# Y# P; x. C: K
5. Remove anonymous users? [Y/n] //閮 Yes 嚗湔交 Enter: B! r/ x; @' _) m4 K2 h* ^0 X
6. Disallow root login remotely? [Y/n] //閮 Yes 嚗湔交 Enter5 ]: K1 z7 ]0 e, H
7. Remove test database and access to it? [Y/n] //閮 Yes 嚗湔交 Enter
- v! f" [9 d$ L- Q, S: Q8. Reload privilege tables now? [Y/n] //閮 Yes 嚗湔交 Enter( v% k `$ c) U8 C
( ^" V( R) f$ }3 N* C+ o. n: l5 r" |# n W- I+ M
亥拍典閮剖 root 撖蝣潛餃 MySQL嚗瑁sudo mysql -u root -p嚗撖蝣潭迤蝣箏停脣乓mysql>璅蝷箇泵
" L5 L+ Y2 A, I: N* O 瑁豢閬券鞈摨$ c8 L* r4 j. T9 X n! G5 X4 `: I
mysql> use mysql
+ n' `5 C3 x( [4 u) `, d
& ^; N/ _! W# {4 r1 z3 l$ e; l 瑁select host,user from user ;閬蝯撠暹瑁$ J% J, Z! G0 M# ^
mysql> select host,user from user ;
5 H/ ]/ H# @" W# l$ {5 Y/ x( Q, b+-----------+------+
/ J) E! |5 I3 D| host | user |0 o( X* c' P0 y% p3 ~+ z
+-----------+------+
8 L; p/ g5 o: m, J| 127.0.0.1 | root |
: E; c" F( L ^. [6 ~5 Y% h$ I| localhost | root |4 [7 m. d* s' N8 ^2 q( \
+-----------+------+- Q7 d- r3 K1 q) ?, f! e
2 rows in set (0.00 sec)& x4 j" ^" T; C
- `/ W+ r- e) X" q 啣銝雿輻刻
7 z# V" T3 J; b9 R: q$ minsert into user (host,user,password) values ('%','your_account',password('your_password'));; e/ d) \" ^/ x# u
" h* X; Y7 D! t# Y& `1 t" w
餅閰脖蝙刻蝞∠甈嚗璅雿賣颲行蝡航 嚗 root 蝡舐餃亥◤鈭嚗
$ X9 e$ G9 W. _( |9 e+ p# @GRANT ALL ON *.* TO 'your_account'@140.112.1.1 IDENTIFIED BY 'your_password' WITH GRANT OPTION;
+ W& i: c/ r, P( Q6 @銝嗅撣唾嚗芣臭祈摨思蝙刻撣唾嚗銝瘝隞颱甈
0 x8 G* v% S5 C' I( b ?餉閮剖# H0 X9 j. n X; g' i, n( E
FLUSH PRIVILEGES;
1 ^% x% c A! o) a摰鋆摰Phpmyadmin ,run http://www.domain.com/dbadmin show error : The mbstring extension is missing. Please check your PHP configuration.1 P1 r. n, w6 I) T! x# ~
隢摰鋆
# `/ e% S* Q, T' Z, E4 L 2 z+ n0 f& _* s3 n7 `1 C* Q
yum -y install php-mbstring
M" j4 G0 t2 N; P
! P" t* s7 U! D4 c. t3 r亙箇曄撩撠mcrypt嚗隢摰鋆
7 x# O# t1 k$ `, S! ~ J1 X
# r% K- J' Q& j, b4 b7 uyum -y install mcrypt- B0 u& B6 N; s! [! g' C
service nginx restart
* q+ X6 Z, K7 uLogin phpadmin 敺箇 error:蝻箏 mysqli 游憟隞嗚隢瑼Ｘ PHP 閮剖Solution:2 R* V. h1 Z/ ]7 K9 I
php -m | grep mysqli ===> confirm mysqli module is installed! Q C! c+ ~ r: s5 Z0 _, Y
php -i | grep extension_dir ===> 撠曉辣隡貊桅9 {) P; Y$ t; |; h* {8 b
yum -y install php-mysql ( yum install php5-mysqli) ===> ok0 o3 h! ^% R/ q v
蝻箏 mcrypt 游憟隞嗚隢瑼Ｘ PHP 閮剖
, B& M: Q7 |: V; ]& \yum install php-mcrypt, U6 ? {8 r$ u: W2 b2 H0 e8 i
yum install libmcrypt libmcrypt-devel ===> ok* L2 {7 ]! u9 X
0 B4 V" s7 n' i7 X. m$ H' Y0 l" W" B6 H' A# v1 L
|
|
潸” 2015-6-21 23:10:33
嗉
鈭
霈
