摰鋆摰Mysql 敺閮剖 : w$ {/ I0 s+ e7 G- _ D9 Q/ u
脖甇亥身摰 MySQL
! d$ {$ Y5 S" ~' O2 AA.
/ y& S% W$ Q/ {4 I. {! c& {) D閮剖php.ini(/etc/php.ini)
& Q$ L I4 h: M) f% M+ d3 zphp.ini
' o1 m/ h: c+ D1 memory_limit = 128M //PHP舐刻園銝
5 a8 F! ]" S# k9 u$ B' j: e5 H2 display_errors = Off //憿舐內航炊閮( l( C0 w$ _( x5 `* i% e
3 date.timezone = Asia/Taipei //(銵閬閮剖嚗銝賀HP雿輻典唳賣豢航炊閮)9 T$ b* i% T# l: h# S' A, t4 W
4 session.cookie_lifetime = 0 //session摮瘣餅(桐蝘嚗0隞銵典瘣餉喟閬賢券)
; k/ [6 I, r; i( K! u3 T
& E' `3 {- Z- c7 iB.* N- v! T9 G. N6 m
閮剖my.cnf(/etc/my.cnf)
# A- A2 v$ {, Q; O6 R! l& smy.cnf : ; `+ M! `- P% o, J1 P* f1 c& `
1 log-error=/var/log/mysqld.log //亥摮曆蝵 `% V7 } G2 t9 G5 L1 a8 L0 d' G
2 connect_timeout = 15 //蝺timeout( _' I, k5 n" J/ h! r% b' d
3 max_connections = 3000 //憭折蝺
; T `4 n3 @ d! \0 _4. service mysqld restart
* }2 v- C4 h% [* I% {
( m0 Q. H) E- g# A1 E% P& ^* D, ?; T4 \
C.4 s) O, V0 v+ e/ C! G
閮剖 MySQL 鞈摨怎恣 root 撣單嗥撖蝣潘瑁sudo mysql_secure_installation嚗隞雿摨銝撟曆辣鈭
" x$ H2 C- {3 d9 c3 k1. Enter current password for root (enter for none): // 湔交 Enter嚗粹閮剜撖蝣
3 K1 \' w0 `% l1 I7 y2. Set root password? [Y/n] //頛詨 Y 靘閮剖撖蝣$ T! T0 e" ?" Y
3. New password: // 頛詨 root 啣蝣
, J% S. j7 S7 I4. Re-enter new password: // 銝甈∟撓 root 啣蝣 y) p+ Q# }. A
5. Remove anonymous users? [Y/n] //閮 Yes 嚗湔交 Enter8 n! q. L2 M7 h. O$ s6 b/ r k
6. Disallow root login remotely? [Y/n] //閮 Yes 嚗湔交 Enter7 ]! c5 ~$ G# f6 Y# \0 u
7. Remove test database and access to it? [Y/n] //閮 Yes 嚗湔交 Enter
9 P' S; F# H2 }! M8. Reload privilege tables now? [Y/n] //閮 Yes 嚗湔交 Enter C# y7 |: P& V. n$ K) E
* @* h! x- |/ c
: \% w9 Y8 ?+ [9 T9 r亥拍典閮剖 root 撖蝣潛餃 MySQL嚗瑁sudo mysql -u root -p嚗撖蝣潭迤蝣箏停脣乓mysql>璅蝷箇泵
1 g( @- }8 m" p 瑁豢閬券鞈摨
0 h) i' ], [) `" ~mysql> use mysql
9 j* i, [6 ]& ?& H& E# @
$ n7 J+ x& L! c3 o2 V) w# r 瑁select host,user from user ;閬蝯撠暹瑁2 |# x% ~; J) Z9 @7 J
mysql> select host,user from user ;
* i5 u1 H) M; d. w( L8 U+-----------+------+$ J: i) s; J. c: W
| host | user |: ~& y( T4 I6 j$ o
+-----------+------+3 x3 L/ A: g+ V- Y+ l* V# f
| 127.0.0.1 | root |9 y9 S. o5 v& f7 I- x- [
| localhost | root |; y4 k3 }" V* h( |
+-----------+------+
; M" q* Y- k* C/ t2 rows in set (0.00 sec)
7 x! E3 L. v- h+ T; r: `4 r
0 P, P( o1 X5 T* Q, D) Z) z 啣銝雿輻刻
2 e8 I+ Y# o$ \; P) hinsert into user (host,user,password) values ('%','your_account',password('your_password'));4 E% r$ \( I- N+ S8 \0 S
) u; E& {, h K% ?: F0 K# X餅閰脖蝙刻蝞∠甈嚗璅雿賣颲行蝡航 嚗 root 蝡舐餃亥◤鈭嚗
* E# x- U- m) B1 a! TGRANT ALL ON *.* TO 'your_account'@140.112.1.1 IDENTIFIED BY 'your_password' WITH GRANT OPTION;/ {7 H. T4 L2 F& A0 K3 a
銝嗅撣唾嚗芣臭祈摨思蝙刻撣唾嚗銝瘝隞颱甈
9 c% n" z2 ~5 D& A2 [4 t, J餉閮剖2 f b7 s. ^/ v4 l: g2 X% \& b& \
FLUSH PRIVILEGES;
7 l* g3 y, ^+ Y- M摰鋆摰Phpmyadmin ,run http://www.domain.com/dbadmin show error : The mbstring extension is missing. Please check your PHP configuration.
, o$ Q& P, A$ x8 c/ P& `5 T隢摰鋆
: I% T& I" f/ b6 n6 H4 d a) ^
6 {7 {! w1 e5 Gyum -y install php-mbstring. y0 \6 U, q, t: w/ x
2 { J& G) K% C: U亙箇曄撩撠mcrypt嚗隢摰鋆
$ m- ?7 D7 E2 ?
+ Y; N! c5 T6 d1 P1 c5 z- y( eyum -y install mcrypt- k* T' K$ R' V! F; j& O- f0 T
service nginx restart
7 Y- z8 T3 J$ P; vLogin phpadmin 敺箇 error:蝻箏 mysqli 游憟隞嗚隢瑼Ｘ PHP 閮剖Solution:- W: P: K4 J2 t0 n, r* e" M
php -m | grep mysqli ===> confirm mysqli module is installed
; a/ x/ a6 l& F5 A, O" _7 I+ sphp -i | grep extension_dir ===> 撠曉辣隡貊桅
, |1 w! y7 m' a$ Y5 Z& n! o! f9 syum -y install php-mysql ( yum install php5-mysqli) ===> ok
: J3 O* }! e0 [# t$ O蝻箏 mcrypt 游憟隞嗚隢瑼Ｘ PHP 閮剖
2 {$ w; X0 Y8 r, zyum install php-mcrypt
% d+ Z7 E: q5 M3 |* Fyum install libmcrypt libmcrypt-devel ===> ok
: c$ P: p( a+ t2 F5 B9 _) p, u, r# U/ X; |/ }5 w3 K2 h9 l% a
8 {9 o, P) E$ W: ]' q |
|
潸” 2015-6-21 23:10:33
嗉
鈭
霈
