亦CentOS芸蒂mysql臬血歇摰鋆: yum list installed | grep mysql - m! U$ m7 w/ I0 P0 w
交芸蒂摰鋆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嚗交憭靘鞈湔隞嗅靘甈∪貉
7 J h/ i' k7 L亦yum摨思mysql砌縑: yum list | grep mysql yum -y list mysql* 7 Z, W6 ?. C+ r6 g$ ~& d2 g+ ~
雿輻肘um摰鋆mysql鞈摨: yum -y install mysql-server mysql mysql-devel 瘜剁摰鋆mysql芣臬鋆鈭鞈摨嚗芣摰鋆mysql-server貊嗡摰鋆鈭serverclient
" h5 q1 k5 l9 f t7 _% I& b* y憒頛詨 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 ! c( S0 D, o# i {& W: Y' H* ?
閮剖 /etc/my.cnf
4 K2 A0 _! ?0 L* l$ P5 E4 ?0 U [mysqld]1 E, I$ z( ?, h4 a! W- {8 N
datadir=/var/lib/mysql
4 j/ s9 w& Y6 B; x9 X6 usocket=/var/lib/mysql/mysql.sock
4 v \' S( H7 f8 w5 Q# Default to using old password format for compatibility with mysql 3.x3 P( K- ]2 X& Y; s9 Z: _
# clients (those using the mysqlclient10 compatibility package).
: ~2 i' h D0 Qold_passwords=1' S9 m8 p0 ^7 S4 c4 ]8 L$ @
default-character-set = utf8
- r7 [6 [' F1 G+ w$ G7 _( ]+ k' X7 L8 n- k1 E
[mysql.server]) p; j+ {8 }; n! v" I; _6 ~+ e
user=mysql( e. P& Q( F% A& s! q% l
basedir=/var/lib, l* n/ v& N& A' i
' R6 h3 E* o/ K- B& l
[mysqld_safe]
" `* L5 Z; y3 E. H. M( R; ?log-error=/var/log/mysqld.log L( }! R9 \ e9 I3 ?0 r0 x
pid-file=/var/run/mysqld/mysqld.pid
+ ~+ Z- G) s% y" s. s2 n6 M" f
: q* d8 B9 |" G9 R[mysql]
, U* q3 H* i8 P% D6 @& r! ^% |default-character-set = utf82 p7 H5 ?4 E3 C' {! c
閮剖 MySQL 函頂蝯曹韏瑕
) g7 q4 Y/ n+ n: N# chkconfig mysqld on
; F/ p/ G8 b- G; U- v/ J9 t5 \% q& T; i& I' h+ b- j
蝣箄 MySQL 芸' R/ e- |" f0 ^4 [" W" s" R
# chkconfig --list mysqld" D4 Y5 u! V; A3 f; A) r
憒2--5榣n撠屠K# r/ Z5 g" h7 i# x
mysqld 0: off 1: off 2: on 3: on 4: on 5: on 6: off
, ^. B7 m; d9 ^: e" |! h MySQL
* B1 h4 X9 |/ v- D # 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 + v) m% h; R- o
MySQL 隞亙嚗敹閮剖 root 撖蝣6 |6 g" S3 B8 p0 j+ u
# 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 頛詨亙蝣 4 @0 J5 S( }8 {7 ? c3 N9 A5 W" B) T
[啣鋆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# p3 c$ Q5 {- f, i* a8 `" k% B1 b
mysql_install_db --user=mysql --ldata=/var/lib/mysql/ ===>check /var/lib/mysql/批歇撱箇閮勗DB/ j* [( y) ?* W P$ v
! k' N5 H g& J1 r% x) i4 O
蝝啁: https://www.cadch.com/modules/news/article.php?storyid=227 |