亦CentOS芸蒂mysql臬血歇摰鋆: yum list installed | grep mysql
! y3 [/ u4 o! W8 M2 L交芸蒂摰鋆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嚗交憭靘鞈湔隞嗅靘甈∪貉
& l. Y5 o: u5 z, ^3 {: B2 V) b亦yum摨思mysql砌縑: yum list | grep mysql yum -y list mysql*
2 a. I) w/ J% t0 @雿輻肘um摰鋆mysql鞈摨: yum -y install mysql-server mysql mysql-devel 瘜剁摰鋆mysql芣臬鋆鈭鞈摨嚗芣摰鋆mysql-server貊嗡摰鋆鈭serverclient
( Y: I; c* P; E s# t; O8 {' |憒頛詨 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 4 S7 N* `4 q7 z5 r8 F
閮剖 /etc/my.cnf
( t# X! t0 n/ c2 { [mysqld]5 l/ q2 u( ]" }) E; V8 J
datadir=/var/lib/mysql4 o( s/ Q; K) L, a4 _" }
socket=/var/lib/mysql/mysql.sock! X- R. X3 P+ w# v
# Default to using old password format for compatibility with mysql 3.x
2 m. z G. r) ^& |# clients (those using the mysqlclient10 compatibility package).
& u: M# [6 _' b/ T9 v( o- yold_passwords=1
( j. n+ V$ e8 h+ V, _; J# jdefault-character-set = utf8" {! i6 a; u( I9 H: g; n
' s: P# Y! `; q1 o[mysql.server]
0 q8 U7 t. C9 g* r: N0 f% iuser=mysql: m! f' }/ d! n
basedir=/var/lib- n4 P2 E! A0 k0 d5 q9 I
; U3 ~ [; K7 _4 x( @& f6 w
[mysqld_safe]2 H4 I! C1 ?) [1 M) ?* [3 Q1 @
log-error=/var/log/mysqld.log
& G! `/ w" n3 ?$ ^1 Q3 _pid-file=/var/run/mysqld/mysqld.pid
2 `8 T; u: P: x1 ?, t$ j
j0 I( A( s5 G' [0 [' p[mysql]* e; j8 T: M% Z2 R
default-character-set = utf89 c2 o* d; L1 p5 o% ?( `2 J
閮剖 MySQL 函頂蝯曹韏瑕0 p2 M; W# [& `$ x P- P8 x! Q
# chkconfig mysqld on9 \4 m' k6 i+ v* t( g" k _
6 }) [5 b% N" C' C! \' s% U7 F7 V
蝣箄 MySQL 芸. V" p; o! Z$ O" V$ ^# E# ]1 ^) f
# chkconfig --list mysqld2 Z2 J5 E7 M: Z2 ~* i
憒2--5榣n撠屠K
@4 Q- I7 G+ j9 V4 W& {5 p mysqld 0: off 1: off 2: on 3: on 4: on 5: on 6: off
$ R1 t e- c" c' y/ y3 [" E MySQL , C, e7 z2 f1 {+ h2 v: i
# 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
. g% w, X9 `3 Z e0 `
MySQL 隞亙嚗敹閮剖 root 撖蝣
" K9 j( {# i' v% a: ~4 a # 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 頛詨亙蝣
# ]: Q/ m1 l) S3 W# d2 k
[啣鋆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: C8 t2 f: {- @: i/ V
mysql_install_db --user=mysql --ldata=/var/lib/mysql/ ===>check /var/lib/mysql/批歇撱箇閮勗DB
9 g1 y- L# B8 o3 e1 k
3 Q; G$ y7 y4 R. d G
蝝啁: https://www.cadch.com/modules/news/article.php?storyid=227 |