摰鋆摰Mysql 敺閮剖 :( v6 u, Z8 ?/ X
脖甇亥身摰 MySQL2 l2 W1 b% O0 N: p+ D/ I3 W
A.* y0 k5 H; R! c, O7 I c( C; r
閮剖php.ini(/etc/php.ini): Z* T+ O. p0 v/ c4 F: q
php.ini
3 Y& w' x" U7 b6 x1 memory_limit = 128M //PHP舐刻園銝6 i& X& F4 p4 Z3 }# h
2 display_errors = Off //憿舐內航炊閮6 o1 U5 n+ x/ y. M/ X, {
3 date.timezone = Asia/Taipei //(銵閬閮剖嚗銝賀HP雿輻典唳賣豢航炊閮)' S% P4 A9 N. C& W7 k4 X0 d$ m
4 session.cookie_lifetime = 0 //session摮瘣餅(桐蝘嚗0隞銵典瘣餉喟閬賢券)
" {1 u4 D& A' H( j; O; O& q( f# l& m* h' W4 g0 H1 R$ E/ A6 d( P
B.
, ?" C, j5 m. Z1 j1 S4 b) Y閮剖my.cnf(/etc/my.cnf)
+ [) J; U8 `7 v1 w1 f3 Hmy.cnf : 0 L: ]2 D2 B: G/ z3 t' c
1 log-error=/var/log/mysqld.log //亥摮曆蝵$ O+ }1 t: R2 _- V4 p
2 connect_timeout = 15 //蝺timeout4 u' o* o. t# i, h( R$ n6 A& W0 }# M
3 max_connections = 3000 //憭折蝺; Y$ f s& l h; n5 M
4. service mysqld restart7 v; W a6 p- f2 u& `. ]
1 N8 s2 A0 L0 v" m) h- B! Q
9 x/ x8 m f& a6 ~! }C.
. D1 }' y. `$ s4 P; s' y# m閮剖 MySQL 鞈摨怎恣 root 撣單嗥撖蝣潘瑁sudo mysql_secure_installation嚗隞雿摨銝撟曆辣鈭, O! W, @" n* I: a5 K- z" P0 ^
1. Enter current password for root (enter for none): // 湔交 Enter嚗粹閮剜撖蝣4 V5 z8 F3 e1 T6 V t
2. Set root password? [Y/n] //頛詨 Y 靘閮剖撖蝣; \; g1 ~3 ?& b# q
3. New password: // 頛詨 root 啣蝣. i8 W: ^" A; o/ I
4. Re-enter new password: // 銝甈∟撓 root 啣蝣4 w; k. Y3 g/ [9 t# H
5. Remove anonymous users? [Y/n] //閮 Yes 嚗湔交 Enter! W$ T# R" h. g% N' J3 l
6. Disallow root login remotely? [Y/n] //閮 Yes 嚗湔交 Enter
$ ^. z3 w; D9 V7. Remove test database and access to it? [Y/n] //閮 Yes 嚗湔交 Enter0 }) t! {( o5 C8 }7 l$ F+ U! L
8. Reload privilege tables now? [Y/n] //閮 Yes 嚗湔交 Enter4 ^, {! {% |0 H: e% o* h! R
3 z9 t# y, g- C( M9 h
8 i1 _) v! E" s, C( a2 F4 Q# c亥拍典閮剖 root 撖蝣潛餃 MySQL嚗瑁sudo mysql -u root -p嚗撖蝣潭迤蝣箏停脣乓mysql>璅蝷箇泵3 Y# [4 W, B! E( G: [2 x. R
瑁豢閬券鞈摨
, A! r1 C2 g$ u2 zmysql> use mysql
1 B0 w( \" v7 f4 E* X9 r
4 J- K6 I' W4 `; T 瑁select host,user from user ;閬蝯撠暹瑁
6 R5 M) n4 I D" wmysql> select host,user from user ;
: b* W" x8 \* Y4 b, R1 y' K+-----------+------+5 J% b% \: \, D7 j. v
| host | user |
* a( Z5 y5 n$ K- h, Z2 G8 P+-----------+------+
0 h( ~1 g, j8 v8 `' F G| 127.0.0.1 | root |2 ^0 D- I# A( J. c0 W( \
| localhost | root |
+ Y: y; z' `" Y) T+-----------+------+
/ l+ U: I7 {: F# G9 k2 rows in set (0.00 sec)
, g6 U# r+ B7 L. _* b
& `, a) I1 e/ g( E$ D' {: a5 o 啣銝雿輻刻
3 T' j: F4 d8 K# V" p- d2 linsert into user (host,user,password) values ('%','your_account',password('your_password'));# u) Y9 [( x) C% R0 s
$ A0 b8 T D. O
餅閰脖蝙刻蝞∠甈嚗璅雿賣颲行蝡航 嚗 root 蝡舐餃亥◤鈭嚗 4 p8 H& ~3 f2 f- j
GRANT ALL ON *.* TO 'your_account'@140.112.1.1 IDENTIFIED BY 'your_password' WITH GRANT OPTION;' B3 X4 i; `/ M
銝嗅撣唾嚗芣臭祈摨思蝙刻撣唾嚗銝瘝隞颱甈7 l' ^: y6 k# Y1 P. ^( x! e0 d
餉閮剖
0 _0 m v; c; E7 L" ]6 pFLUSH PRIVILEGES;
- n3 m: t) q8 ?6 ]摰鋆摰Phpmyadmin ,run http://www.domain.com/dbadmin show error : The mbstring extension is missing. Please check your PHP configuration.
% Q# E a5 e* e/ s7 A9 x隢摰鋆
7 q3 m/ W% l+ ^7 q
4 Y }9 E, C# b" Fyum -y install php-mbstring
) D$ o1 z, M, h' R" X( M/ C* R; b2 ^& k
亙箇曄撩撠mcrypt嚗隢摰鋆+ b5 S! F" ~% F, s1 g" Z% ~
; e4 Y3 I+ k' H: O: A, hyum -y install mcrypt
! B8 B2 l6 z- g" M/ jservice nginx restart7 l) }( w4 |5 x) _" @3 \
Login phpadmin 敺箇 error:蝻箏 mysqli 游憟隞嗚隢瑼X PHP 閮剖Solution:
. G1 |' z1 g% k3 S! _php -m | grep mysqli ===> confirm mysqli module is installed
]4 z7 M0 W" @2 a$ a' iphp -i | grep extension_dir ===> 撠曉辣隡貊桅! g- ~% x! P0 p! `1 r5 R; Q/ x
yum -y install php-mysql ( yum install php5-mysqli) ===> ok
( U8 {1 I. d, [, v0 N蝻箏 mcrypt 游憟隞嗚隢瑼X PHP 閮剖+ Y s2 ]8 u% O- Q
yum install php-mcrypt
6 w8 T- S9 c2 K+ o% _yum install libmcrypt libmcrypt-devel ===> ok
1 i- v" ]3 P; d8 _* w Q# B2 N' u& }
9 {8 m( u( G" I |
|