查看CentOS自带mysql是否已安裝:
yum list installed | grep mysql
2 ?) A8 E" v9 z6 H9 D若有自带安装的mysql,如何卸载CentOS系统自带mysql資料庫?
yum -y remove mysql-libs.x86_64,若有多個依賴文件则依次卸載。
* i5 a# h+ r$ ^! j9 x2 G查看yum庫上的mysql版本信息:
yum list | grep mysql 或 yum -y list mysql*
使用yum安装mysql資料庫:
yum -y install mysql-server mysql mysql-devel
注:安装mysql只是安装了資料庫,只有安装mysql-server才相當于安装了server及client。
- C: \5 u4 Y; A% T6 X. {& p6 ^假如輸入 mysql 出現 error:
rpm -qi mysql-server
設定 /etc/my.cnf, i ^2 k; ]' Z$ U$ I3 I; f
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
default-character-set = utf8
[mysql.server] c' t. U( \& e
user=mysql
basedir=/var/lib
) x4 E# v) i% W7 W; T
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
[mysql]
default-character-set = utf84 B; ^6 p2 ^+ n3 p+ z9 q
設定 MySQL 服務隨系統一起啟動- v; G$ T5 {3 R9 ]! B4 r2 U. e3 G
# chkconfig mysqld on
( n5 P) }/ A4 s0 u
確認 MySQL 自動啟動有打開
# chkconfig --list mysqld
如果2--5為on的狀態就OK1 D4 l( C& p. U* P4 P( H
mysqld 0: off 1: off 2: on 3: on 4: on 5: on 6: off. Q" a& O4 ^; M. b% V$ E' D8 C- k
啟動 MySQL 服務
# 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
/ |$ R* ]. j Z' Q- `6 ^# Z2 `
啟動 MySQL 以後,必須設定 root 的密碼: K1 \- i" ~8 C' M; Z
# 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
輸入密碼
/ \- h# r* Y4 J- t G# |1 h _
[重新安裝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/mysql160414 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 exist160414 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 disabled160414 10:07:57 InnoDB: Mutexes and rw_locks use InnoDB's own implementation160414 10:07:57 InnoDB: Compressed tables use zlib 1.2.3160414 10:07:57 InnoDB: Using Linux native AIO160414 10:07:57 InnoDB: Initializing buffer pool, size = 128.0M160414 10:07:57 InnoDB: Completed initialization of buffer pool160414 10:07:57 InnoDB: highest supported file format is Barracuda.160414 10:07:57 InnoDB: Waiting for the background threads to start160414 10:07:58 InnoDB: 5.5.49 started; log sequence number 1595675160414 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: 3306160414 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
mysql_install_db --user=mysql --ldata=/var/lib/mysql/ ===>check /var/lib/mysql/內已建立許多DB
$ G+ a% |3 k I) S6 P! Y
升級成最新版:
https://www.cadch.com/modules/news/article.php?storyid=227
歡迎光臨 52AV手機A片王|52AV.ONE (https://nhkie.com/) | Powered by Discuz! X3.2 |