亦CentOS芸蒂mysql臬血歇摰鋆: yum list installed | grep mysql
$ H! }& Q. x& e3 |/ f9 G交芸蒂摰鋆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嚗交憭靘鞈湔隞嗅靘甈∪貉 : X4 n7 m9 x7 ^( I3 L8 o
亦yum摨思mysql砌縑: yum list | grep mysql yum -y list mysql*
5 s7 [5 }7 I Q% C# z! d5 n5 {. { ^雿輻肘um摰鋆mysql鞈摨: yum -y install mysql-server mysql mysql-devel 瘜剁摰鋆mysql芣臬鋆鈭鞈摨嚗芣摰鋆mysql-server貊嗡摰鋆鈭serverclient 8 S# ^& C! k8 R) \7 O/ Z+ o! x2 C7 N. I
憒頛詨 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
$ J$ v! m' c: p$ L閮剖 /etc/my.cnf
$ w! U+ q8 s( j [mysqld]
1 P. A' M2 r- r; ydatadir=/var/lib/mysql
, d5 M8 b/ X+ t7 \socket=/var/lib/mysql/mysql.sock {$ |0 L4 d( ~6 F, j5 [
# Default to using old password format for compatibility with mysql 3.x1 j% q" _4 c8 ~% \
# clients (those using the mysqlclient10 compatibility package).( H) o% Y6 y# J3 V& v# A0 F0 s
old_passwords=1
* P5 ~5 _8 q9 e/ F y3 r9 Cdefault-character-set = utf8
1 N' H+ ~3 B/ u
. v; e2 W" I5 ?6 X; R$ q* Q[mysql.server]* x, P/ }+ J2 z1 f, m4 O3 ~
user=mysql
% C T4 ` h, f, f3 m& n! sbasedir=/var/lib8 q$ a5 w* @2 ~% Q7 U! c
8 s; t' x; O' W6 T( D3 J% Z[mysqld_safe]9 ~: y. D: ?6 [0 q: x
log-error=/var/log/mysqld.log
' t* Y& f% m" p8 T5 h7 ?" Qpid-file=/var/run/mysqld/mysqld.pid
+ h- A1 f+ l4 V4 g- k
4 d. U0 u" j! @3 Z7 N2 ]' R[mysql]! M1 F* }9 z& z% D I- j
default-character-set = utf8
& X) c7 N; U. m: B3 \4 P" Y; H 閮剖 MySQL 函頂蝯曹韏瑕
4 E( H9 |$ c( D( `( E4 h# chkconfig mysqld on
9 U0 B; d% q4 m* P- v9 X! \ ^1 {2 O+ N5 ~& z- X5 S5 t( d
蝣箄 MySQL 芸
+ g7 o% d5 |$ p' k2 L # chkconfig --list mysqld
0 z3 d) g" |( f. k+ ?' A: g 憒2--5榣n撠屠K+ A0 d+ v' R8 a3 ]1 o: q
mysqld 0: off 1: off 2: on 3: on 4: on 5: on 6: off
8 V1 N x5 s, s! F* B {- z MySQL 4 [( J8 E6 L. g$ ~# L
# 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
2 }" K: \2 |. P8 r4 B9 Z# |
MySQL 隞亙嚗敹閮剖 root 撖蝣( W/ a5 k# Z$ q+ i, G8 P# P
# 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 頛詨亙蝣 & s, n# P3 Y @1 K& m* f
[啣鋆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
8 a! E4 k1 Z2 J5 S' Smysql_install_db --user=mysql --ldata=/var/lib/mysql/ ===>check /var/lib/mysql/批歇撱箇閮勗DB. `1 C* C) U" e
# N, _* q: F# _; M) o# N1 \
蝝啁: https://www.cadch.com/modules/news/article.php?storyid=227 |