tid=21196& 查看CentOS自带mysql是否已安裝: yum list installed | grep mysql 7 F \% W. a. w9 H: ~
若有自带安装的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,若有多個依賴文件则依次卸載。
: ~/ p. U' v9 ?" f查看yum庫上的mysql版本信息: yum list | grep mysql 或 yum -y list mysql*
7 G: w3 |0 X0 |" `7 {使用yum安装mysql資料庫: yum -y install mysql-server mysql mysql-devel 注:安装mysql只是安装了資料庫,只有安装mysql-server才相當于安装了server及client。
3 H/ ]+ `, Y& d: w$ p! P0 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
( @4 J3 b2 v8 t- m設定 /etc/my.cnf
( }5 r. }6 M# V4 v( ^( m [mysqld]
5 Z2 g" z* u' @( n3 r( {datadir=/var/lib/mysql9 c( ?* L1 O7 }6 y8 q& D1 N
socket=/var/lib/mysql/mysql.sock4 {8 h$ ~6 I2 I% y9 E H/ ]0 ^
# Default to using old password format for compatibility with mysql 3.x
% Q+ ^. M7 ~# n4 X: ?7 V5 u) ]# clients (those using the mysqlclient10 compatibility package).
# e1 G( A5 j3 Q, ^3 k5 kold_passwords=1( O; K" ?) u1 u6 E! |0 G8 ~' u
default-character-set = utf8
& A+ @3 f2 ~) h( b1 I4 \* B, k% D* T/ x4 [3 l' l* [: }
[mysql.server]
7 M7 \ Q5 j: d0 |$ n7 i0 v" juser=mysql
6 E2 V/ A' G& T( m* ~* Y. G6 s1 Ibasedir=/var/lib
0 d) t! H& ~4 v* k) ~* G. @8 o" N/ \
4 o+ t3 }' `8 V0 A8 }3 Y[mysqld_safe]
( h0 h$ v7 {3 s4 |& nlog-error=/var/log/mysqld.log" z9 c& n7 Z1 }7 @
pid-file=/var/run/mysqld/mysqld.pid
' W1 }) t0 I& T+ W" v. E6 m
2 ~, W5 p7 C+ _: ]" R[mysql]; i; }. {/ O: |8 k
default-character-set = utf8; u3 k% S7 i: y$ L$ D: D
設定 MySQL 服務隨系統一起啟動3 ^# }' U9 r- U h& k( d
# chkconfig mysqld on' w% z8 W; x: G9 @) K6 k3 l. ^
3 ~; P. E Z- p, `) h- v& n2 X確認 MySQL 自動啟動有打開
; X, j0 F+ F- i( Y$ g3 d # chkconfig --list mysqld9 ^( d1 Q0 T7 `/ W
如果2--5為on的狀態就OK
; H) H9 s9 b! F0 U& ? mysqld 0: off 1: off 2: on 3: on 4: on 5: on 6: off
$ Q1 G" }" F& y6 f; ~: c9 T0 Z& k/ ^/ N 啟動 MySQL 服務. C' ?& s; y" v: k0 {
# 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
0 T3 o2 v, B, d6 i+ ^2 U
啟動 MySQL 以後,必須設定 root 的密碼% A3 i; `$ L8 q
# mysqladmin -u root password 'Your Password' 或者執行指令 # /usr/bin/mysql_secure_installation 試 root 是否可成功登入 mysql: mysql -u root -p Enter password: (輸入root 密碼) 升級 MySQL database至最新 # mysql_upgrade -u root -p 輸入密碼 5 K/ e1 h( _4 U- A" p6 G
[重新安裝mysql] 參考http://tecadmin.net/remove-mysql-completely-from-linux-system/ 註: 以yum安裝在CentOS 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: K, m1 b# W( ?8 ^& y7 b
mysql_install_db --user=mysql --ldata=/var/lib/mysql/ ===>check /var/lib/mysql/內已建立許多DB0 S: ~$ B3 w+ W5 S9 T
9 b j. Q# ^+ A( O' T0 \" T7 Z
升級成最新版: https://www.cadch.com/modules/news/article.php?storyid=227 |