tid=21196& 查看CentOS自带mysql是否已安裝: yum list installed | grep mysql + Z: m2 M/ M0 i' P
若有自带安装的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,若有多個依賴文件则依次卸載。 / d2 b) S; E: U# a
查看yum庫上的mysql版本信息: yum list | grep mysql 或 yum -y list mysql*
$ T4 l+ N2 I3 A( g6 {; C4 C; \使用yum安装mysql資料庫: yum -y install mysql-server mysql mysql-devel 注:安装mysql只是安装了資料庫,只有安装mysql-server才相當于安装了server及client。 5 K7 C1 W, }: Z6 A U* }
假如輸入 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
U& i2 x: P6 ^4 \; F# Q& L0 P& M設定 /etc/my.cnf9 c# @. t6 ]8 y7 w+ B
[mysqld]$ R" \# H# F5 R( [$ u/ |' C
datadir=/var/lib/mysql
) s& x T3 y a& W6 M; b9 V% Ksocket=/var/lib/mysql/mysql.sock
2 m3 Z$ h q# D E# F9 H# Default to using old password format for compatibility with mysql 3.x
& K# a$ I8 ^9 q4 S- n# clients (those using the mysqlclient10 compatibility package).9 E- J* r/ I4 C' ~0 C
old_passwords=1
/ x# ~4 v6 M6 |default-character-set = utf8
# A) k- K: ^, n' z. I; H! G+ Q( H$ E4 c. j/ U. i3 C% j
[mysql.server]
; M/ [" ]5 C+ u( z1 \% d( quser=mysql
0 w1 j6 g& y% q3 `, l, dbasedir=/var/lib
7 S! g; w3 Z0 h2 g: P Q- K- i+ `$ r- [) i' c; G) l, h+ i
[mysqld_safe]
; C1 d8 s$ x1 E* Z ^log-error=/var/log/mysqld.log
) t& X% V9 ~3 h+ U* ^ x1 jpid-file=/var/run/mysqld/mysqld.pid
. U5 ~% o' V: {/ y8 n) ]
4 D' D! ~3 m0 l1 M& Z[mysql]9 J( n& X% f6 C6 M/ z- {- O0 b
default-character-set = utf8
# Z0 p/ J1 }- T) b3 |, j+ @ 設定 MySQL 服務隨系統一起啟動
, B4 l- W1 i3 f. K& c& G3 T# chkconfig mysqld on
2 r5 r1 D0 o; `8 @' L
4 \' y: Y) s) U9 l* T確認 MySQL 自動啟動有打開: i1 ?9 v5 p. Z v
# chkconfig --list mysqld0 E% ?" l* ] X/ o! T- m
如果2--5為on的狀態就OK1 u( w+ Q0 \, l& F( R7 @; j: P. ~ o
mysqld 0: off 1: off 2: on 3: on 4: on 5: on 6: off
: | `! O7 s, R6 N, Z0 H6 F2 i 啟動 MySQL 服務
+ a/ p& a3 {7 k: h$ H # 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 7 `2 \. @1 _6 y- D0 M9 [( [: Y
啟動 MySQL 以後,必須設定 root 的密碼, Y7 f7 Z* G8 o
# 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 輸入密碼 : g% I) R1 ?4 q6 b% @) Q5 l
[重新安裝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
; f+ M3 n& t4 y+ F# imysql_install_db --user=mysql --ldata=/var/lib/mysql/ ===>check /var/lib/mysql/內已建立許多DB, p0 c/ b* }, A& v
1 ?' J6 V( S Z) x
升級成最新版: https://www.cadch.com/modules/news/article.php?storyid=227 |