摰鋆摰Mysql 敺閮剖 :& ^. V4 [2 f7 ?
脖甇亥身摰 MySQL0 C! \2 b2 P8 n
A.
7 ^7 ?* ^& X4 |& k閮剖php.ini(/etc/php.ini)* ]/ g' ~! T0 P5 k
php.ini6 S6 X5 [1 W+ O. W0 G4 o7 ~- q, Y
1 memory_limit = 128M //PHP舐刻園銝: ]& ?- V- _" ?1 T2 t
2 display_errors = Off //憿舐內航炊閮1 f# d. q! m G0 ?; {
3 date.timezone = Asia/Taipei //(銵閬閮剖嚗銝賀HP雿輻典唳賣豢航炊閮)
* l! g. J. Q( D; y$ }8 `4 session.cookie_lifetime = 0 //session摮瘣餅(桐蝘嚗0隞銵典瘣餉喟閬賢券)
, e. Z* R' B D( y8 p; u1 a' N% c' |* D) H$ g8 p5 P3 \, E- F5 G
B.
4 ]/ t5 A/ Y+ o. ]2 b* B8 r4 G/ ?閮剖my.cnf(/etc/my.cnf)
- t# {. _; l( C: m& |1 }my.cnf :
( {+ H, o8 X: O7 e1 log-error=/var/log/mysqld.log //亥摮曆蝵
3 x Y5 Z( q- @% C7 z- n- d2 connect_timeout = 15 //蝺timeout2 a' F. q5 d# Z3 s. d ]4 F
3 max_connections = 3000 //憭折蝺
. F! j$ a n _2 W$ ^. z4. service mysqld restart
% p5 `' k2 N7 k3 i3 t
$ r- T: ~) ~+ Q& C0 \8 S/ i7 R* A! {
- ]9 b$ i! Y3 p4 _/ n5 H6 {C.
. T" l; }7 M# I5 @閮剖 MySQL 鞈摨怎恣 root 撣單嗥撖蝣潘瑁sudo mysql_secure_installation嚗隞雿摨銝撟曆辣鈭
& S( g0 {% O: N3 q3 v. ~4 D1 C1. Enter current password for root (enter for none): // 湔交 Enter嚗粹閮剜撖蝣% q9 `% Y/ p. }# i1 V' d4 y8 Y
2. Set root password? [Y/n] //頛詨 Y 靘閮剖撖蝣
, O( y9 @5 _ `! i! C/ c3. New password: // 頛詨 root 啣蝣
9 }3 C! o: Y( j/ G: e+ R4. Re-enter new password: // 銝甈∟撓 root 啣蝣
3 Q5 e' ]$ z) J% h4 ^5. Remove anonymous users? [Y/n] //閮 Yes 嚗湔交 Enter
8 V$ w/ y$ ]6 d9 |6. Disallow root login remotely? [Y/n] //閮 Yes 嚗湔交 Enter9 b. u# d3 B2 p4 d& l
7. Remove test database and access to it? [Y/n] //閮 Yes 嚗湔交 Enter0 I' |8 G, p1 O& [/ n* }8 z. S$ a
8. Reload privilege tables now? [Y/n] //閮 Yes 嚗湔交 Enter4 D7 R* X' ]+ u/ P) R( A
; f. C ~$ X! J6 q7 ]* R
: J- l3 Z( @6 M# k1 ~) c& f亥拍典閮剖 root 撖蝣潛餃 MySQL嚗瑁sudo mysql -u root -p嚗撖蝣潭迤蝣箏停脣乓mysql>璅蝷箇泵
8 w2 w! Z! C0 @ x1 d/ _ 瑁豢閬券鞈摨
; N$ \0 Y, N; t1 H7 mmysql> use mysql' O0 m1 F/ S, I
/ m& }5 ?6 {& Q- g; |3 n 瑁select host,user from user ;閬蝯撠暹瑁
% ^. R1 h; m- \) w. Nmysql> select host,user from user ;0 @7 o6 M8 H2 e; E
+-----------+------+) H' m. u3 L/ R/ O
| host | user |% j5 F/ u* C. p1 G
+-----------+------+, e0 e2 {/ i8 I
| 127.0.0.1 | root |# M: ]5 e4 l. }* {' K1 i
| localhost | root |! o. X, S( i$ n% M7 A
+-----------+------+/ w8 f+ t+ Y8 E
2 rows in set (0.00 sec)
, E* A5 j8 k% T o7 R- A( S5 t9 Z% S5 h9 S7 Q: C y
啣銝雿輻刻
: c8 C- Z: }5 O. I! ?6 ~/ M" g5 Ainsert into user (host,user,password) values ('%','your_account',password('your_password'));
& B; k) s d! H* J' |3 g- f# W" p8 I7 J. V
餅閰脖蝙刻蝞∠甈嚗璅雿賣颲行蝡航 嚗 root 蝡舐餃亥◤鈭嚗
c# ~ {* `* Y, l4 l* Y2 X) GGRANT ALL ON *.* TO 'your_account'@140.112.1.1 IDENTIFIED BY 'your_password' WITH GRANT OPTION;) I! a# K( b9 H- ^2 S, _( K
銝嗅撣唾嚗芣臭祈摨思蝙刻撣唾嚗銝瘝隞颱甈
1 L2 u6 p) l: F' x餉閮剖4 J) ^. t6 j/ f7 |; z
FLUSH PRIVILEGES;
8 K' i1 h. l- x4 I4 f摰鋆摰Phpmyadmin ,run http://www.domain.com/dbadmin show error : The mbstring extension is missing. Please check your PHP configuration.% q/ n& c# b- T r4 y" Y x
隢摰鋆. N! Y8 y" F) l9 Z+ H" y l
, X/ r. P: _2 l9 Z
yum -y install php-mbstring
; Q7 D3 o% b: B5 z- d; w9 E7 j' B* N# u3 ]/ ]- h' x0 {
亙箇曄撩撠mcrypt嚗隢摰鋆
4 E. c @: P9 u3 z6 k0 \
% B, G J f7 o0 ryum -y install mcrypt
7 u9 d; E% V* g! \service nginx restart
. ?. o, M; d9 ]! t. ]9 aLogin phpadmin 敺箇 error:蝻箏 mysqli 游憟隞嗚隢瑼X PHP 閮剖Solution:2 T4 T7 j' J( k9 r; N
php -m | grep mysqli ===> confirm mysqli module is installed5 ~$ r. c& k( ?2 \! |+ c) A
php -i | grep extension_dir ===> 撠曉辣隡貊桅/ ~ }6 W1 }4 d* g! Q
yum -y install php-mysql ( yum install php5-mysqli) ===> ok
! \1 z0 j% N7 v+ G/ A* S* {6 {6 O5 d; E蝻箏 mcrypt 游憟隞嗚隢瑼X PHP 閮剖: q) K9 [; t' V+ q! J% t" |1 E
yum install php-mcrypt
' [! F4 E( s* S0 i: @yum install libmcrypt libmcrypt-devel ===> ok" u. C, X$ n( D+ S
. T( @1 P" b3 {7 e; c T+ L% E6 }& ?, y# l# n4 D/ e
|
|