|
亦CentOS芸蒂mysql臬血歇摰鋆: yum list installed | grep mysql # M% U) b# U3 |' Q/ V) e% M1 X
交芸蒂摰鋆mysql嚗憒雿貉蝸CentOS蝟餌芸蒂mysql鞈摨恬 mysql-libs.x86_64 5.1.73-5.el6_6 @anaconda-CentOS-201508042137.x86_64/6.7 yum -y remove mysql-libs.x86_64嚗交憭靘鞈湔隞嗅靘甈∪貉
& W7 Z7 a, ?5 n亦yum摨思mysql砌縑: yum list | grep mysql yum -y list mysql* 7 i6 d+ T' `. S( A
雿輻肘um摰鋆mysql鞈摨: yum -y install mysql-server mysql mysql-devel 瘜剁摰鋆mysql芣臬鋆鈭鞈摨嚗芣摰鋆mysql-server貊嗡摰鋆鈭serverclient
% X' L8 y: V/ o. ~: g2 P2 _憒頛詨 mysql 箇 error: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) 銵函內芸 mysqld 隞亥撓 service mysqld start,敺擐砌箇曆誑銝閮,雿銝鈭函閮: - To start mysqld at boot time you have to copy
- support-files/mysql.server to the right place for your system
- PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
- To do so, start the server, then issue the following commands:
- /usr/bin/mysqladmin -u root password 'new-password'
- /usr/bin/mysqladmin -u root -h video.yocoolnet.com password 'new-password'
- Alternatively you can run:
- /usr/bin/mysql_secure_installation
- which will also give you the option of removing the test
- databases and anonymous user created by default. This is
- strongly recommended for production servers.
- See the manual for more instructions.
- You can start the MySQL daemon with:
- cd /usr ; /usr/bin/mysqld_safe &
- You can test the MySQL daemon with mysql-test-run.pl
- cd /usr/mysql-test ; perl mysql-test-run.pl
亦摰鋆mysql唳桀砌縑: rpm -qi mysql-server
[2 J9 T5 t _閮剖 /etc/my.cnf
/ @7 K& [; U+ K [mysqld]% N/ c- ~1 {, ~' n1 G& u5 ~4 H! I
datadir=/var/lib/mysql
5 ]1 h L, K& a" n& q8 Hsocket=/var/lib/mysql/mysql.sock
2 ?$ K7 T& D1 P W. ]" H; L7 C# Default to using old password format for compatibility with mysql 3.x
+ u! |2 n3 ]8 K4 t6 h; N2 c- z8 b# [# clients (those using the mysqlclient10 compatibility package).
7 k( k, Y0 D4 [old_passwords=1# G3 |& ?/ a5 C# x1 W- N- d! ?- ]
default-character-set = utf8
) F7 a3 R& @, W: J; c9 d
9 k- T: F* X& w" i6 T[mysql.server]
& W+ R9 a& @0 N( t: wuser=mysql
+ s+ z: A1 t7 ebasedir=/var/lib
, p% q% U9 L4 C6 c# K5 W; T. k9 h# g2 A
[mysqld_safe]
/ m+ P- Q7 |% a( x2 E) [$ O3 Olog-error=/var/log/mysqld.log
, r+ h; k: w+ |" Q% v/ n6 Jpid-file=/var/run/mysqld/mysqld.pid
0 o) S4 s% _1 c2 A2 ^* M8 a# o; }5 a/ c$ g, \0 j
[mysql]1 A3 X$ A' |( T% t o/ W
default-character-set = utf8( a: p/ g2 P7 A7 Q
閮剖 MySQL 函頂蝯曹韏瑕% L9 K: T" }: \7 f# C
# chkconfig mysqld on; S' n+ F" |9 S2 l! [& V3 I
1 U S6 k% x, b5 D, _ _
蝣箄 MySQL 芸! Q7 r" N0 u0 [) }
# chkconfig --list mysqld
+ e4 {4 @1 q( _# f0 f. Q& M 憒2--5榣n撠屠K
7 v1 V; X( d8 l+ I mysqld 0: off 1: off 2: on 3: on 4: on 5: on 6: off5 Q6 [# F, X$ e0 v
MySQL
1 z* q) W' t0 @6 P, n # service mysqld start /usr/bin/mysqld_safe & 蝣箄 MySQL 臬血歇 #service mysqld status mysqld (pid 33778) is running... cd /usr/mysql-test ; perl mysql-test-run.pl
* L; P. G$ v. q! ?5 d: K
MySQL 隞亙嚗敹閮剖 root 撖蝣
& U9 }% O1 @$ S8 F # mysqladmin -u root password 'Your Password' 瑁隞 # /usr/bin/mysql_secure_installation 閰 root 臬血舀餃 mysql: mysql -u root -p Enter password: (頛詨叵oot 撖蝣) 蝝 MySQL database單 # mysql_upgrade -u root -p 頛詨亙蝣 7 A1 j* M5 v; Q0 A& j' T4 H+ `
[啣鋆mysql] http://tecadmin.net/remove-mysql-completely-from-linux-system/ 閮: 隞句um摰鋆每entOS 5.11/i386 箇暸航炊,see /var/log/mysqld.log : 160414 10:07:57 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 160414 10:07:57 [Note] /usr/libexec/mysqld (mysqld 5.5.49) starting as process 9426 ... 160414 10:07:57 [Note] Plugin 'FEDERATED' is disabled. /usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist 160414 10:07:57 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. 160414 10:07:57 InnoDB: The InnoDB memory heap is disabled 160414 10:07:57 InnoDB: Mutexes and rw_locks use InnoDB's own implementation 160414 10:07:57 InnoDB: Compressed tables use zlib 1.2.3 160414 10:07:57 InnoDB: Using Linux native AIO 160414 10:07:57 InnoDB: Initializing buffer pool, size = 128.0M 160414 10:07:57 InnoDB: Completed initialization of buffer pool 160414 10:07:57 InnoDB: highest supported file format is Barracuda. 160414 10:07:57 InnoDB: Waiting for the background threads to start 160414 10:07:58 InnoDB: 5.5.49 started; log sequence number 1595675 160414 10:07:58 InnoDB: !!! innodb_force_recovery is set to 1 !!! 160414 10:07:58 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 160414 10:07:58 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 160414 10:07:58 [Note] Server socket created on IP: '0.0.0.0'. 160414 10:07:58 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist :mysqld⊥芸撱箇 /var/lib/mysql/鞈摨,甇日撱箇DB
) b- i2 s6 k8 y: ]* d. K+ Xmysql_install_db --user=mysql --ldata=/var/lib/mysql/ ===>check /var/lib/mysql/批歇撱箇閮勗DB `) M) P; S2 |8 H; f7 Y, j3 z; @+ d
# |0 {$ }0 g C( Y4 h
蝝啁: https://www.cadch.com/modules/news/article.php?storyid=227 |
潸” 2015-10-30 17:31:21
嗉
鈭
霈
