- 準(zhǔn)備安裝環(huán)境
CentOS6.7 Final
MySQL-5.5.48-1.linux2.6.x86_64.rpm-bundle.tar
- 上傳MySQL安裝包到CentOS上
執(zhí)行rz
,就可以從本地選擇要上傳的文件了。
默認(rèn)上傳至服務(wù)器的usr/local
目錄下 - 設(shè)置執(zhí)行權(quán)限
chmod u+x MySQL-5.5.48-1.linux2.6.x86_64.rpm-bundle.tar
- 執(zhí)行解壓命令
tar -xvf MySQL-5.5.48-1.linux2.6.x86_64.rpm-bundle.tar
拣宰,得到如下文件:
MySQL-client-5.5.48-1.linux2.6.x86_64.rpm
MySQL-shared-compat-5.5.48-1.linux2.6.x86_64.rpm
MySQL-test-5.5.48-1.linux2.6.x86_64.rpm
MySQL-server-5.5.48-1.linux2.6.x86_64.rpm
MySQL-embedded-5.5.48-1.linux2.6.x86_64.rpm
MySQL-devel-5.5.48-1.linux2.6.x86_64.rpm
MySQL-shared-5.5.48-1.linux2.6.x86_64.rpm
- 設(shè)置執(zhí)行權(quán)限
chmod u+x MySQL-server-5.5.48-1.linux2.6.x86_64.rpm
chmod u+x MySQL-client-5.5.48-1.linux2.6.x86_64.rpm
-
安裝
rpm -ivh MySQL-server-5.5.48-1.linux2.6.x86_64.rpm
,有時候會出現(xiàn)下面的消息:
image.png 卸載沖突
rpm -e mysql-libs-5.1.73-5.el6_6.x86_64 --nodeps
依次安裝
rpm -ivh MySQL-server-5.5.48-1.linux2.6.x86_64.rpm
rpm -ivh MySQL-client-5.5.48-1.linux2.6.x86_64.rpm
初始化MySQL服務(wù),
/usr/bin/mysql_secure_installation
啟動MySQL服務(wù)毯焕,
service mysql start
install & start
試著遠(yuǎn)程連接挽拂,比如從本地使用客戶端
Navicat
連接垒玲,報錯:
Host 'xxx.xx.xxx.xxx' is not allowed to connect to this MySQL server
連接服務(wù)器唱歧,
mysql -u root - p
Enter password:
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
(授權(quán)朦乏,用戶root使用password從任何主機(jī)連接到mysql服務(wù)器球及。)
flush privileges;