摰鋆摰Mysql 敺閮剖 :
: I6 S$ @" c& S; q脖甇亥身摰 MySQL4 C; z K; U9 E, G* h% ^
A. v' G# R2 z O0 o, R# C9 k
閮剖php.ini(/etc/php.ini)
1 ]& z# `% A/ Zphp.ini
- |: v+ X2 L1 |3 U1 memory_limit = 128M //PHP舐刻園銝( U+ o1 f% p% s4 @0 X1 W
2 display_errors = Off //憿舐內航炊閮. O. Q7 q O% C
3 date.timezone = Asia/Taipei //(銵閬閮剖嚗銝賀HP雿輻典唳賣豢航炊閮)
X9 E* ]3 ]" V _0 F$ d4 session.cookie_lifetime = 0 //session摮瘣餅(桐蝘嚗0隞銵典瘣餉喟閬賢券)
`. Z& f; w* F% e6 ^5 R# y9 }- a7 p+ L' ^$ q6 m& q) ]
B.7 W$ y5 d2 a* b% B9 F
閮剖my.cnf(/etc/my.cnf)" D+ O& o* ]7 m
my.cnf :
6 q3 Y5 D. |5 m1 \8 \; p1 log-error=/var/log/mysqld.log //亥摮曆蝵
' z/ b, w+ ?0 g8 d, {2 connect_timeout = 15 //蝺timeout! C) k: i# I i, o" @
3 max_connections = 3000 //憭折蝺
0 \; k u1 N. Q; I+ |# `9 c8 p4. service mysqld restart
! u3 b" x4 o, a+ K# E# N
( ^2 p6 ^& c; f+ \. z E
' J: k! Q y" V9 [, G) t& ] VC.0 M0 a( n) e1 Q3 g7 ]" @6 G' C+ s
閮剖 MySQL 鞈摨怎恣 root 撣單嗥撖蝣潘瑁sudo mysql_secure_installation嚗隞雿摨銝撟曆辣鈭
~ F W2 u! s1. Enter current password for root (enter for none): // 湔交 Enter嚗粹閮剜撖蝣
/ R2 _1 g+ j( h; y2. Set root password? [Y/n] //頛詨 Y 靘閮剖撖蝣
+ i# d6 Z: V1 F6 }# r3. New password: // 頛詨 root 啣蝣
0 r2 h# Q1 X" }4. Re-enter new password: // 銝甈∟撓 root 啣蝣
. ~# M. V7 s; K) e2 L" Y5. Remove anonymous users? [Y/n] //閮 Yes 嚗湔交 Enter
. q+ i0 P; j* W! v- f6. Disallow root login remotely? [Y/n] //閮 Yes 嚗湔交 Enter
& d* J9 S7 F, C7. Remove test database and access to it? [Y/n] //閮 Yes 嚗湔交 Enter
: b' l0 P$ W3 C8. Reload privilege tables now? [Y/n] //閮 Yes 嚗湔交 Enter
; |. \0 R& I7 p S. T. m" }+ j5 N1 _. I+ V" i. U5 k
+ {/ o0 ?; h2 n. X/ L
亥拍典閮剖 root 撖蝣潛餃 MySQL嚗瑁sudo mysql -u root -p嚗撖蝣潭迤蝣箏停脣乓mysql>璅蝷箇泵+ w- Y2 Y6 U k( }$ Q) u% U
瑁豢閬券鞈摨* @! o& n6 F# a3 F7 ?1 y, q
mysql> use mysql
3 j# M( x/ p4 A2 D' c
+ X" G6 ~9 _! n+ { F7 {7 t; D 瑁select host,user from user ;閬蝯撠暹瑁; u8 e# n: F3 x# z" w6 [- G J; ], N: `
mysql> select host,user from user ;& X: `3 ?: `: @0 ? B
+-----------+------+
- v" J$ [9 |5 C| host | user |
! J6 R! \6 o9 Y" Y: J. m+-----------+------+
( Z: K+ h% a2 C" H4 l| 127.0.0.1 | root |% ?5 T) @, F9 P: \+ b
| localhost | root |
9 |/ F: g2 M' l0 t/ g4 ]+-----------+------+6 h! B Y4 X: U7 v* ]1 K3 S
2 rows in set (0.00 sec)
# N8 D B; V$ X) U' n; f" g/ ?' N5 a3 T+ K6 p
啣銝雿輻刻
v# u8 Q& Z* Tinsert into user (host,user,password) values ('%','your_account',password('your_password'));
6 Q H0 l+ a0 C5 H) L
& u; N& h. ^/ W7 S1 Y% R餅閰脖蝙刻蝞∠甈嚗璅雿賣颲行蝡航 嚗 root 蝡舐餃亥◤鈭嚗 , u7 t/ f- m! D/ f
GRANT ALL ON *.* TO 'your_account'@140.112.1.1 IDENTIFIED BY 'your_password' WITH GRANT OPTION;( k. s( m- z3 ~! ?* ]- a
銝嗅撣唾嚗芣臭祈摨思蝙刻撣唾嚗銝瘝隞颱甈
( P# {: {9 g3 l4 @( d* |餉閮剖
4 W1 `8 h& H" pFLUSH PRIVILEGES;
! U9 N5 B3 d* m. M+ \/ [: P& h摰鋆摰Phpmyadmin ,run http://www.domain.com/dbadmin show error : The mbstring extension is missing. Please check your PHP configuration.: u2 p' G/ m* ?: Z- M" q) A
隢摰鋆 K A5 _; D& A
' j9 a) A: e# e$ Y* J
yum -y install php-mbstring
1 Y5 A' d, ?6 m$ F4 Q& B2 I4 ^7 X& E2 B+ Q9 J2 ^5 I$ P
亙箇曄撩撠mcrypt嚗隢摰鋆1 m, S) z: D- Z6 g9 t, M
( Z( {9 E$ u1 p* F+ A1 Q4 E# O1 S
yum -y install mcrypt
& K5 S* y3 H2 a5 M# ] N' w0 vservice nginx restart
- S1 q6 Y o7 H$ a: ALogin phpadmin 敺箇 error:蝻箏 mysqli 游憟隞嗚隢瑼X PHP 閮剖Solution:6 s x5 I* t4 r5 f1 z- N# ]
php -m | grep mysqli ===> confirm mysqli module is installed
% H: T1 ]$ S# F M! Cphp -i | grep extension_dir ===> 撠曉辣隡貊桅
7 x! t3 K0 ?8 k3 Z+ U# k; @! C7 zyum -y install php-mysql ( yum install php5-mysqli) ===> ok) A! e4 N2 p7 H U: q, ]; [' l- Q
蝻箏 mcrypt 游憟隞嗚隢瑼X PHP 閮剖% f0 K0 y- N2 _9 ~. }1 d) W
yum install php-mcrypt
; y9 p: B: O1 e9 f; E7 B3 ^3 _yum install libmcrypt libmcrypt-devel ===> ok
( \: X7 W O4 L- `3 s5 L9 d
2 ?* T( G4 |% y5 I6 M: N6 Z0 L6 O
|
|