CentOS使用yum安裝mysql

IT_man

查看CentOS自带mysql是否已安裝:

yum list installed | grep mysql

若有自带安装的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，若有多個依賴文件则依次卸載。

查看yum庫上的mysql版本信息:

yum list | grep mysql 或 yum -y list mysql*

* L4 I! J4 l2 ^+ Y3 L+ r; }

使用yum安装mysql資料庫:

yum -y install mysql-server mysql mysql-devel

注：安装mysql只是安装了資料庫，只有安装mysql-server才相當于安装了server及client。

假如輸入 mysql  出現 error:

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)      表示未啟動 mysqld

所以輸入  service mysqld start,啟動後馬上出現以下訊息,提醒你的一些有用的訊息:

1. To start mysqld at boot time you have to copy
2. support-files/mysql.server to the right place for your system
4. PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
5. To do so, start the server, then issue the following commands:
7. /usr/bin/mysqladmin -u root password 'new-password'
8. /usr/bin/mysqladmin -u root -h video.yocoolnet.com password 'new-password'
10. Alternatively you can run:
11. /usr/bin/mysql_secure_installation
13. which will also give you the option of removing the test
14. databases and anonymous user created by default.  This is
15. strongly recommended for production servers.
17. See the manual for more instructions.
19. You can start the MySQL daemon with:
20. cd /usr ; /usr/bin/mysqld_safe &
22. You can test the MySQL daemon with mysql-test-run.pl
23. cd /usr/mysql-test ; perl mysql-test-run.pl

複製代碼

查看刚安装mysql数据库版本信息:

rpm -qi mysql-server

8 v+ e1 ~6 C# j. d" p& }

設定 /etc/my.cnf
3 ?1 D8 x+ D3 B4 W

[mysqld]
datadir=/var/lib/mysql
+ U! X% {. A; f, Dsocket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
* W& G  \( H6 b' h+ ~( R  l# clients (those using the mysqlclient10 compatibility package).
. T3 A# b1 C4 {6 t' S, H0 x& D$ Dold_passwords=1
" q0 `" S1 V9 Edefault-character-set = utf8
/ E. R! r0 h' w" x/ l4 \
) n5 U! V9 p) ~6 F9 w[mysql.server]
; u! H4 {9 B2 _& P; d& ouser=mysql
basedir=/var/lib
6 x' O$ N9 J% [0 @+ }2 k
[mysqld_safe]
8 v4 V: [5 s$ w9 J- Klog-error=/var/log/mysqld.log
+ a! ^# P3 k/ B% I. k) X5 Dpid-file=/var/run/mysqld/mysqld.pid
8 @! K% ^4 P$ ~6 ]1 W* k$ ?# v: f
, ?1 P. B% u. N9 `[mysql]
1 R4 z% K& k0 w$ u" Z) ?. Ydefault-character-set = utf8

設定 MySQL 服務隨系統一起啟動
# chkconfig mysqld on

確認 MySQL 自動啟動有打開

# chkconfig --list mysqld
7 W4 c+ z2 [- L% V% M

如果2--5為on的狀態就OK
+ V1 w. ]1 z6 y" H

mysqld 0: off 1: off 2: on 3: on 4: on 5: on 6: off

啟動 MySQL 服務
2 ^0 ?6 N' N( p! G

# 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

啟動 MySQL 以後，必須設定 root 的密碼
$ x$ h3 I- a* K4 B* X5 B

# 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

輸入密碼

7 N( ~* a. c' _+ w! L! D' z

[重新安裝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
mysql_install_db --user=mysql --ldata=/var/lib/mysql/  ===>check /var/lib/mysql/內已建立許多DB

升級成最新版:

https://www.cadch.com/modules/news/article.php?storyid=227