摰鋆摰Mysql 敺閮剖 :, X& z% J8 ~3 S }0 [$ c& m
脖甇亥身摰 MySQL
$ d; H, u5 R# U% mA.: `8 `, L" N& \" I0 o. k. N
閮剖php.ini(/etc/php.ini)
* u0 w! Q3 G" Nphp.ini+ X. y( W) e m% Q) `
1 memory_limit = 128M //PHP舐刻園銝+ l6 }9 _* _8 F8 O* r7 V5 j
2 display_errors = Off //憿舐內航炊閮
. l( ? U/ @4 @4 W3 date.timezone = Asia/Taipei //(銵閬閮剖嚗銝賀HP雿輻典唳賣豢航炊閮)
f! X6 q& w7 U$ B, `9 Y4 session.cookie_lifetime = 0 //session摮瘣餅(桐蝘嚗0隞銵典瘣餉喟閬賢券)
" |& m5 t1 c2 V( n+ R, J3 K; H7 l9 Y; y
B.# a1 `: q& p/ ?/ L) o* V
閮剖my.cnf(/etc/my.cnf)# _. q" d. Z; z7 J1 I# p% e4 \
my.cnf :
% y2 ^ y0 P. \+ H' P5 G- c8 g! S: U1 log-error=/var/log/mysqld.log //亥摮曆蝵, g+ D! l4 |' e
2 connect_timeout = 15 //蝺timeout
% y* I2 A9 K: x: S% {2 X; A9 k+ i3 max_connections = 3000 //憭折蝺) L) p: X, e: L7 T
4. service mysqld restart# R _2 z7 u Z% T
- G& U4 ~" U9 c u9 f$ Q
, K0 \6 b. P; w- t, L/ X G
C.
( S6 h0 P* X7 | H; f閮剖 MySQL 鞈摨怎恣 root 撣單嗥撖蝣潘瑁sudo mysql_secure_installation嚗隞雿摨銝撟曆辣鈭
/ d8 e' y/ q- I1. Enter current password for root (enter for none): // 湔交 Enter嚗粹閮剜撖蝣4 {+ Y) q4 M6 ~- p q% p
2. Set root password? [Y/n] //頛詨 Y 靘閮剖撖蝣$ o. G& S/ z* e1 A6 b- b
3. New password: // 頛詨 root 啣蝣
$ B- \5 H5 V X; d9 s+ r1 s4. Re-enter new password: // 銝甈∟撓 root 啣蝣
4 q! q- h9 Q: a* o/ r9 v. ]5. Remove anonymous users? [Y/n] //閮 Yes 嚗湔交 Enter; `, i+ {0 d* H; C
6. Disallow root login remotely? [Y/n] //閮 Yes 嚗湔交 Enter$ a, l" [. o. y' C% A
7. Remove test database and access to it? [Y/n] //閮 Yes 嚗湔交 Enter9 T# V. H0 [$ E/ T, Z* r8 h
8. Reload privilege tables now? [Y/n] //閮 Yes 嚗湔交 Enter
3 O% m/ {$ Q; d, _0 ?3 O. W; P0 a/ a$ @, g R) V. |1 j6 @
, T& m$ `# |' t8 | @& @& q亥拍典閮剖 root 撖蝣潛餃 MySQL嚗瑁sudo mysql -u root -p嚗撖蝣潭迤蝣箏停脣乓mysql>璅蝷箇泵% v V* N$ o6 [) J' ]
瑁豢閬券鞈摨# w' B0 _6 M0 T) @$ i
mysql> use mysql
/ d: \1 w% m+ s
8 o4 p. s) F% C4 L- Y! }0 A: v 瑁select host,user from user ;閬蝯撠暹瑁
; [! h" h. `8 B( Kmysql> select host,user from user ;- P) p1 E d H/ Z
+-----------+------+( j' W1 X( J; P
| host | user |3 K7 z/ d; o5 ^- i7 `2 P6 P
+-----------+------+
: [3 l% w: S. L8 ] ?7 b! V| 127.0.0.1 | root |. d* w- e Y8 R' u7 Q
| localhost | root |
9 e |, k% p* G9 I+-----------+------+
' i' M2 v0 D7 \7 z" _$ w2 rows in set (0.00 sec)
" [4 i3 L% s' W9 `
' z6 _5 ~8 b* Q 啣銝雿輻刻
' v y1 k! c6 C) r% Sinsert into user (host,user,password) values ('%','your_account',password('your_password'));
7 N1 Q7 j1 ?$ n7 f5 {" C! b* l) A; a: s
餅閰脖蝙刻蝞∠甈嚗璅雿賣颲行蝡航 嚗 root 蝡舐餃亥◤鈭嚗
, r. \! N, k- a$ Q, VGRANT ALL ON *.* TO 'your_account'@140.112.1.1 IDENTIFIED BY 'your_password' WITH GRANT OPTION;
+ z* o; y4 U' ?* m銝嗅撣唾嚗芣臭祈摨思蝙刻撣唾嚗銝瘝隞颱甈
! ^9 R5 {% H% O7 {" n0 g. A餉閮剖1 d) v1 t ~( k, v) `& @, m! Q- {
FLUSH PRIVILEGES;
) S* ]8 Q* y7 e e {% J摰鋆摰Phpmyadmin ,run http://www.domain.com/dbadmin show error : The mbstring extension is missing. Please check your PHP configuration.
4 i: o2 D7 p' g( Y( Z隢摰鋆) q1 B6 S' V& u( o7 u, p+ l
7 {) q3 _7 q( \8 h5 R5 Q: M2 o! oyum -y install php-mbstring5 S7 m2 n) N2 Y( y
- S* L4 }4 |! z' {- }+ R4 |
亙箇曄撩撠mcrypt嚗隢摰鋆
5 h/ b8 M) }+ \. D. G
0 h6 M9 K& T: G5 d6 Qyum -y install mcrypt5 j: Z1 j5 @: S4 r* e6 {
service nginx restart
! q& V$ [* I% h% cLogin phpadmin 敺箇 error:蝻箏 mysqli 游憟隞嗚隢瑼Ｘ PHP 閮剖Solution:7 J! k7 X1 x4 u$ ?( _4 Y" @: L; v
php -m | grep mysqli ===> confirm mysqli module is installed4 D- c1 J9 E* v" L5 p
php -i | grep extension_dir ===> 撠曉辣隡貊桅( H* G0 _) O v- C" O* ^
yum -y install php-mysql ( yum install php5-mysqli) ===> ok4 n3 m, D& E1 f
蝻箏 mcrypt 游憟隞嗚隢瑼Ｘ PHP 閮剖) x7 _8 a. W: w' c/ O5 [
yum install php-mcrypt: E) s- l! b) l+ C8 [ r5 p0 l
yum install libmcrypt libmcrypt-devel ===> ok' y- V! j( o2 h
" z* D' O& p& r; I$ N7 |, O( w5 \
4 a/ }/ N; Q! s8 B' F
|
|
潸” 2015-6-21 23:10:33
嗉
鈭
霈
