摰鋆摰Mysql 敺閮剖 :+ F. A9 B; y2 j1 f% K) ^9 ~
脖甇亥身摰 MySQL
- R! _, V' D6 }( N1 y0 EA.' M! Q" w& m' M* n5 W6 \
閮剖php.ini(/etc/php.ini)
' S" F6 ^/ ?) w- u1 ]2 r2 Z/ wphp.ini- j, b- f( u4 i: T D( V8 |3 f
1 memory_limit = 128M //PHP舐刻園銝
$ w; Z% a. e2 `0 L2 display_errors = Off //憿舐內航炊閮1 J% J/ s8 w: }+ i
3 date.timezone = Asia/Taipei //(銵閬閮剖嚗銝賀HP雿輻典唳賣豢航炊閮)) j1 N; U7 Z2 N R% {
4 session.cookie_lifetime = 0 //session摮瘣餅(桐蝘嚗0隞銵典瘣餉喟閬賢券)
6 v1 |) v f4 H1 C0 S' V/ d$ h7 E' Y/ [0 J/ y
B.
. o3 l) I1 r* z- ` [2 D閮剖my.cnf(/etc/my.cnf)8 P; Y3 o( [ O
my.cnf :
3 D \+ j* c1 s2 I. ^/ O( f; A1 log-error=/var/log/mysqld.log //亥摮曆蝵
- w5 ]( U, ~" U6 E; |4 F1 K$ ~+ M/ R. T' @2 connect_timeout = 15 //蝺timeout; q- V( A2 a# P- _: q
3 max_connections = 3000 //憭折蝺
( ~( e% u" ` A7 E C& I+ A4. service mysqld restart) C* ]4 f* p9 u3 p
% G% c( X+ l, K7 X) |; W, Q+ f2 B5 ?- ?+ F3 k. \# x
C.
+ t- E C7 q* i: U2 `8 N7 A! I8 a閮剖 MySQL 鞈摨怎恣 root 撣單嗥撖蝣潘瑁sudo mysql_secure_installation嚗隞雿摨銝撟曆辣鈭% H5 H1 k" P& L8 Z0 v) h' G! [4 M
1. Enter current password for root (enter for none): // 湔交 Enter嚗粹閮剜撖蝣 R! Z4 c& i# f! ?# m
2. Set root password? [Y/n] //頛詨 Y 靘閮剖撖蝣
/ u1 F% k: k5 G% f- |3. New password: // 頛詨 root 啣蝣4 k3 y! l4 P! y4 [# s7 B* c
4. Re-enter new password: // 銝甈∟撓 root 啣蝣) H* c& t! _! _! J( L
5. Remove anonymous users? [Y/n] //閮 Yes 嚗湔交 Enter+ m7 u/ H% V! T; `+ j
6. Disallow root login remotely? [Y/n] //閮 Yes 嚗湔交 Enter
7 \* l% {: l& R! e; L" q7. Remove test database and access to it? [Y/n] //閮 Yes 嚗湔交 Enter
; N6 m9 z, x3 X s9 h2 q8. Reload privilege tables now? [Y/n] //閮 Yes 嚗湔交 Enter+ l! O7 I) N# |; I9 J
5 w. ^9 W) X" f$ s
- ]- h7 O# g2 ^! A亥拍典閮剖 root 撖蝣潛餃 MySQL嚗瑁sudo mysql -u root -p嚗撖蝣潭迤蝣箏停脣乓mysql>璅蝷箇泵
4 \" C q; M6 W# L8 g- O# B% @ 瑁豢閬券鞈摨
: U' G/ C' z: |% Rmysql> use mysql; Y8 V" y$ M8 I& A8 d4 H* r8 |- a) I
; T3 g. W3 ^3 Y. m# K8 h# a. i N 瑁select host,user from user ;閬蝯撠暹瑁
! A8 ^3 d. }2 W- vmysql> select host,user from user ;: Q2 L) {1 k! P
+-----------+------+3 c+ j t: ]. R4 {* M
| host | user |# X9 P$ d" ?) E' r# b
+-----------+------+
# J8 ^. i/ h7 g| 127.0.0.1 | root |
/ v8 y6 J* w: A8 [8 @" H! y| localhost | root |
; V# n+ x8 [4 p/ P- }+-----------+------+
* m5 I% \) n, Z3 O2 rows in set (0.00 sec)
6 d2 |9 D/ ^7 x
3 v2 o/ E7 z; m8 \3 g9 t# ?, s 啣銝雿輻刻" p5 e. b$ y: x! ~
insert into user (host,user,password) values ('%','your_account',password('your_password'));" O2 ?5 b+ x0 f
: `1 V5 e" M3 M餅閰脖蝙刻蝞∠甈嚗璅雿賣颲行蝡航 嚗 root 蝡舐餃亥◤鈭嚗 4 O: l, L7 V6 b6 _, K0 P
GRANT ALL ON *.* TO 'your_account'@140.112.1.1 IDENTIFIED BY 'your_password' WITH GRANT OPTION;
- e& M) @8 P/ D# e( y: w* v銝嗅撣唾嚗芣臭祈摨思蝙刻撣唾嚗銝瘝隞颱甈
/ c% C1 t# N% |. r7 H0 {% H餉閮剖
8 G' I+ X9 E0 ]2 Z' R2 u7 _FLUSH PRIVILEGES;
& [: f7 U+ Y) y! }摰鋆摰Phpmyadmin ,run http://www.domain.com/dbadmin show error : The mbstring extension is missing. Please check your PHP configuration.9 L6 @1 h4 G& u6 G: j
隢摰鋆& O* H1 t2 a* s- J% c
' M' \2 L5 C" p, h! Q2 o/ m ]yum -y install php-mbstring
+ x( r; a1 ?. s0 i/ B) g, ~' b3 f
亙箇曄撩撠mcrypt嚗隢摰鋆
4 x7 K( ^0 g |. s5 U& b1 L
9 x7 N+ Q& [0 I4 ~* p/ J/ `yum -y install mcrypt" N, k7 A) ~4 T$ M/ f. t
service nginx restart! z1 n2 u4 W9 x0 K9 M: `
Login phpadmin 敺箇 error:蝻箏 mysqli 游憟隞嗚隢瑼X PHP 閮剖Solution:
6 F* |6 j$ h) kphp -m | grep mysqli ===> confirm mysqli module is installed% Q* q3 w/ V; }" [
php -i | grep extension_dir ===> 撠曉辣隡貊桅6 `: t0 U4 {" w& C
yum -y install php-mysql ( yum install php5-mysqli) ===> ok4 R# j; x% E% B- R' ^
蝻箏 mcrypt 游憟隞嗚隢瑼X PHP 閮剖
1 q- Y$ \# O! ], {+ o8 ayum install php-mcrypt2 V* }9 ?: w9 R/ j% Z/ s2 {: \
yum install libmcrypt libmcrypt-devel ===> ok8 N# F- }2 F6 X" \5 {8 u* v
3 A) P. s/ ?+ p& E( s
' j$ t2 t/ r( f4 P6 M4 g( H$ D |
|