摰鋆摰Mysql 敺閮剖 :
9 N2 N- K4 }) E1 _$ K, |脖甇亥身摰 MySQL) b: h8 a6 x1 v, [
A.( T, A: [& F4 {0 s, Z
閮剖php.ini(/etc/php.ini). D8 F- B6 M* w! b
php.ini! P, w4 n$ O1 [8 `+ [
1 memory_limit = 128M //PHP舐刻園銝
& Y1 f) z o! B y2 display_errors = Off //憿舐內航炊閮1 }' F' q1 X6 x
3 date.timezone = Asia/Taipei //(銵閬閮剖嚗銝賀HP雿輻典唳賣豢航炊閮)
% E4 d: v, E1 [0 p5 E4 session.cookie_lifetime = 0 //session摮瘣餅(桐蝘嚗0隞銵典瘣餉喟閬賢券)6 }, h; b) t8 g4 l' V! @/ d6 ?
9 I# R1 q: f- N% ?B.# Q# m: F, I4 c, G7 R
閮剖my.cnf(/etc/my.cnf)& U" L5 F' e- q; |
my.cnf : " w+ \! m( Z! f) W! u
1 log-error=/var/log/mysqld.log //亥摮曆蝵) @3 @% o. y, y! ]% N# S$ W0 m
2 connect_timeout = 15 //蝺timeout; h( i8 L6 Y+ p! k" W1 x( m" w" F
3 max_connections = 3000 //憭折蝺
}2 N1 p/ [1 J# @1 C5 G2 d4. service mysqld restart, y/ i, j" |( Q5 n& ?. w8 p8 g3 [
7 j! o; X* F1 N# `4 G2 d( H. H) [% ^7 ^' y4 r1 i9 V
C.1 f# F0 P3 V/ E
閮剖 MySQL 鞈摨怎恣 root 撣單嗥撖蝣潘瑁sudo mysql_secure_installation嚗隞雿摨銝撟曆辣鈭
- ^3 {+ V" { G4 q: N1. Enter current password for root (enter for none): // 湔交 Enter嚗粹閮剜撖蝣( m9 m. y( L0 z# U/ \4 y' H2 D1 W
2. Set root password? [Y/n] //頛詨 Y 靘閮剖撖蝣% ^, j& C( Z) ^7 J& _! Q
3. New password: // 頛詨 root 啣蝣
: k+ p, A9 v: g: [) ~2 [4. Re-enter new password: // 銝甈∟撓 root 啣蝣6 T; n; o( x2 |$ T- N
5. Remove anonymous users? [Y/n] //閮 Yes 嚗湔交 Enter
+ |$ a: q1 j r7 x3 [) q6. Disallow root login remotely? [Y/n] //閮 Yes 嚗湔交 Enter1 R: v6 x6 w4 `
7. Remove test database and access to it? [Y/n] //閮 Yes 嚗湔交 Enter. i7 D |0 o' ]+ I) u! ]5 Y# L
8. Reload privilege tables now? [Y/n] //閮 Yes 嚗湔交 Enter
" I& D! O1 Q2 Z0 [8 f6 x1 [5 x1 u6 T+ k) [- N f
* x8 {6 l1 O, U6 D
亥拍典閮剖 root 撖蝣潛餃 MySQL嚗瑁sudo mysql -u root -p嚗撖蝣潭迤蝣箏停脣乓mysql>璅蝷箇泵/ i. O A% O' H. m" P9 c0 B; n
瑁豢閬券鞈摨
! E2 {9 C. H6 pmysql> use mysql! A2 K6 h+ B1 h) h8 [
3 M E d0 j9 _6 |( f9 O 瑁select host,user from user ;閬蝯撠暹瑁
& o$ j( l5 k: Gmysql> select host,user from user ;
+ }% @4 w' U6 w) U V+-----------+------+
0 R5 ^5 t( v8 R| host | user |
* J1 Y) x4 X* H& O, e, ]* z- n+-----------+------+3 @5 u' _4 A$ `+ _
| 127.0.0.1 | root |
. S% ?* E) f. T4 f| localhost | root |
* R2 m/ \2 S. y4 K+-----------+------+
; Z1 e: D# L m$ ?* g1 l2 rows in set (0.00 sec)* u% }; O6 D7 y1 d
6 p9 ]8 r1 b' P3 D" O
啣銝雿輻刻
5 t# ~! \( \6 t, J& n7 {insert into user (host,user,password) values ('%','your_account',password('your_password'));* G3 d4 z4 A7 S8 k$ y% g* T
7 v/ d- U2 C5 s8 l4 y# }+ |餅閰脖蝙刻蝞∠甈嚗璅雿賣颲行蝡航 嚗 root 蝡舐餃亥◤鈭嚗 9 i! ~& M! M, i
GRANT ALL ON *.* TO 'your_account'@140.112.1.1 IDENTIFIED BY 'your_password' WITH GRANT OPTION;
* I, \* {6 G& c: C: C [銝嗅撣唾嚗芣臭祈摨思蝙刻撣唾嚗銝瘝隞颱甈7 z O) J1 ~8 [0 a
餉閮剖: _8 R* h( a, z# L; `
FLUSH PRIVILEGES;9 E$ x8 l& L2 h) f
摰鋆摰Phpmyadmin ,run http://www.domain.com/dbadmin show error : The mbstring extension is missing. Please check your PHP configuration.# ]% p0 N+ o9 ^7 ^
隢摰鋆" ]5 V* G5 N; _6 P; l8 u
: f) \0 ?/ z3 @* V8 v3 `yum -y install php-mbstring! J! a7 x4 l7 H j% D
3 ^) |) X% G* Q6 Q
亙箇曄撩撠mcrypt嚗隢摰鋆
0 a% i% e& w( o5 `
5 h, ~( _! g, R- @' o% S/ U9 dyum -y install mcrypt# V2 s# c' O6 u
service nginx restart( k* A& I; |, M& N
Login phpadmin 敺箇 error:蝻箏 mysqli 游憟隞嗚隢瑼X PHP 閮剖Solution:4 w' v( }/ X3 |/ F7 Z- ?
php -m | grep mysqli ===> confirm mysqli module is installed
3 R/ l0 H5 b, {8 Cphp -i | grep extension_dir ===> 撠曉辣隡貊桅
! K& R4 O) r7 Z2 f* S- F1 dyum -y install php-mysql ( yum install php5-mysqli) ===> ok8 s& D1 M0 q! m) J
蝻箏 mcrypt 游憟隞嗚隢瑼X PHP 閮剖
; w" F5 @' c5 p. P1 ~( jyum install php-mcrypt
9 V$ [4 r( T! h$ J8 z; u @3 Ryum install libmcrypt libmcrypt-devel ===> ok/ L7 y, m7 F0 ]( C2 S% }. X6 ~
, w( f, z+ {6 U( s6 B8 ~$ x+ [% r
; ]: M& a8 S/ }' ?; u/ x- @) G
|
|