centos 6.9安裝mysql的詳細教程
更新時間：2017年07月06日 08:47:05 作者：花弄影
這篇文章主要介紹了centos 6.9安裝mysql的詳細教程，非常不錯，具有參考借鑒價值,需要的朋友可以參考下
1、確認mysql是否已安裝，有下面的代碼可知
[root@cdh1 zjl]# yum list installed mysql* Loaded plugins: fastestmirror, refresh-packagekit, security Loading mirror speeds from cached hostfile * base: mirrors.zju.edu.cn * extras: mirrors.aliyun.com * updates: mirrors.aliyun.com Installed Packages MySQL-python.x86_64 1.2.3-0.3.c1.1.el6 @base mysql-libs.x86_64 5.1.73-8.el6_8 @anaconda-CentOS-201703281317.x86_64/6.9
2、卸載已安裝的mysql，建議使用yum命令，因為yum命令可以自動刪除與mysql相關的依賴；如果使用rpm命令，則還需要手動去刪除和mysql相關的文件，比較麻煩
[root@cdh1 zjl]# yum remove MySQL-python.x86_64 mysql-libs.x86_64
Loaded plugins: fastestmirror, refresh-packagekit, security
Setting up Remove Process
Resolving Dependencies
--> Running transaction check
---> Package MySQL-python.x86_64 0:1.2.3-0.3.c1.1.el6 will be erased
--> Processing Dependency: MySQL-python for package: cloudera-manager-agent-5.11.1-1.cm5111.p0.9.el6.x86_64
---> Package mysql-libs.x86_64 0:5.1.73-8.el6_8 will be erased
--> Processing Dependency: libmysqlclient.so.16()(64bit) for package: 2:postfix-2.6.6-8.el6.x86_64
--> Processing Dependency: libmysqlclient.so.16(libmysqlclient_16)(64bit) for package: 2:postfix-2.6.6-8.el6.x86_64
--> Processing Dependency: mysql-libs for package: 2:postfix-2.6.6-8.el6.x86_64
--> Running transaction check
---> Package cloudera-manager-agent.x86_64 0:5.11.1-1.cm5111.p0.9.el6 will be erased
---> Package postfix.x86_64 2:2.6.6-8.el6 will be erased
--> Processing Dependency: /usr/sbin/sendmail for package: redhat-lsb-core-4.0-7.el6.centos.x86_64
--> Processing Dependency: /usr/sbin/sendmail for package: cronie-1.4.4-16.el6_8.2.x86_64
--> Running transaction check
---> Package cronie.x86_64 0:1.4.4-16.el6_8.2 will be erased
--> Processing Dependency: cronie = 1.4.4-16.el6_8.2 for package: cronie-anacron-1.4.4-16.el6_8.2.x86_64
---> Package redhat-lsb-core.x86_64 0:4.0-7.el6.centos will be erased
--> Processing Dependency: redhat-lsb-core(x86-64) = 4.0 for package: redhat-lsb-printing-4.0-7.el6.centos.x86_64
--> Processing Dependency: redhat-lsb-core(x86-64) = 4.0-7.el6.centos for package: redhat-lsb-4.0-7.el6.centos.x86_64
--> Processing Dependency: redhat-lsb-core(x86-64) = 4.0 for package: redhat-lsb-graphics-4.0-7.el6.centos.x86_64
--> Running transaction check
---> Package cronie-anacron.x86_64 0:1.4.4-16.el6_8.2 will be erased
---> Package redhat-lsb.x86_64 0:4.0-7.el6.centos will be erased
--> Processing Dependency: redhat-lsb(x86-64) = 4.0-7.el6.centos for package: redhat-lsb-compat-4.0-7.el6.centos.x86_64
---> Package redhat-lsb-graphics.x86_64 0:4.0-7.el6.centos will be erased
---> Package redhat-lsb-printing.x86_64 0:4.0-7.el6.centos will be erased
--> Running transaction check
---> Package redhat-lsb-compat.x86_64 0:4.0-7.el6.centos will be erased
--> Processing Dependency: /etc/cron.d for package: crontabs-1.10-33.el6.noarch
--> Processing Dependency: /etc/cron.d for package: sysstat-9.0.4-33.el6.x86_64
--> Restarting Dependency Resolution with new changes.
--> Running transaction check
---> Package crontabs.noarch 0:1.10-33.el6 will be erased
---> Package sysstat.x86_64 0:9.0.4-33.el6 will be erased
--> Finished Dependency Resolution
Dependencies Resolved
====================================================================
Package Arch Version Repository
Size
====================================================================
Removing:
MySQL-python x86_64 1.2.3-0.3.c1.1.el6 @base 246 k
mysql-libs x86_64 5.1.73-8.el6_8 @anaconda-CentOS-201703281317.x86_64/6.9
4.0 M
Removing for dependencies:
cloudera-manager-agent x86_64 5.11.1-1.cm5111.p0.9.el6 @/cloudera-manager-agent-5.11.1-1.cm5111.p0.9.el6.x86_64
71 M
cronie x86_64 1.4.4-16.el6_8.2 @anaconda-CentOS-201703281317.x86_64/6.9
174 k
cronie-anacron x86_64 1.4.4-16.el6_8.2 @anaconda-CentOS-201703281317.x86_64/6.9
43 k
crontabs noarch 1.10-33.el6 @anaconda-CentOS-201703281317.x86_64/6.9
2.4 k
postfix x86_64 2:2.6.6-8.el6 @anaconda-CentOS-201703281317.x86_64/6.9
9.7 M
redhat-lsb x86_64 4.0-7.el6.centos @anaconda-CentOS-201703281317.x86_64/6.9
0.0
redhat-lsb-compat x86_64 4.0-7.el6.centos @anaconda-CentOS-201703281317.x86_64/6.9
0.0
redhat-lsb-core x86_64 4.0-7.el6.centos @anaconda-CentOS-201703281317.x86_64/6.9
22 k
redhat-lsb-graphics x86_64 4.0-7.el6.centos @anaconda-CentOS-201703281317.x86_64/6.9
0.0
redhat-lsb-printing x86_64 4.0-7.el6.centos @anaconda-CentOS-201703281317.x86_64/6.9
0.0
sysstat x86_64 9.0.4-33.el6 @anaconda-CentOS-201703281317.x86_64/6.9
826 k
Transaction Summary
====================================================================
Remove 13 Package(s)
Installed size: 86 M
Is this ok [y/N]: y
Downloading Packages:
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Warning: RPMDB altered outside of yum.
Erasing : redhat-lsb-compat-4.0-7.el6.centos.x86_64 1/13
Erasing : redhat-lsb-4.0-7.el6.centos.x86_64 2/13
Erasing : cloudera-manager-agent-5.11.1-1.cm5111.p0.9. 3/13
warning: /etc/cloudera-scm-agent/config.ini saved as /etc/cloudera-scm-agent/config.ini.rpmsave
Erasing : redhat-lsb-graphics-4.0-7.el6.centos.x86_64 4/13
Erasing : redhat-lsb-printing-4.0-7.el6.centos.x86_64 5/13
Erasing : redhat-lsb-core-4.0-7.el6.centos.x86_64 6/13
/var/tmp/rpm-tmp.jLbJUk: line 1: lsb_release: command not found
Erasing : MySQL-python-1.2.3-0.3.c1.1.el6.x86_64 7/13
Erasing : sysstat-9.0.4-33.el6.x86_64 8/13
Erasing : crontabs-1.10-33.el6.noarch 9/13
Erasing : cronie-anacron-1.4.4-16.el6_8.2.x86_64 10/13
Erasing : cronie-1.4.4-16.el6_8.2.x86_64 11/13
Erasing : 2:postfix-2.6.6-8.el6.x86_64 12/13
Erasing : mysql-libs-5.1.73-8.el6_8.x86_64 13/13
Verifying : redhat-lsb-printing-4.0-7.el6.centos.x86_64 1/13
Verifying : cronie-anacron-1.4.4-16.el6_8.2.x86_64 2/13
Verifying : cronie-1.4.4-16.el6_8.2.x86_64 3/13
Verifying : 2:postfix-2.6.6-8.el6.x86_64 4/13
Verifying : redhat-lsb-4.0-7.el6.centos.x86_64 5/13
Verifying : redhat-lsb-core-4.0-7.el6.centos.x86_64 6/13
Verifying : cloudera-manager-agent-5.11.1-1.cm5111.p0.9. 7/13
Verifying : crontabs-1.10-33.el6.noarch 8/13
Verifying : redhat-lsb-compat-4.0-7.el6.centos.x86_64 9/13
Verifying : MySQL-python-1.2.3-0.3.c1.1.el6.x86_64 10/13
Verifying : redhat-lsb-graphics-4.0-7.el6.centos.x86_64 11/13
Verifying : sysstat-9.0.4-33.el6.x86_64 12/13
Verifying : mysql-libs-5.1.73-8.el6_8.x86_64 13/13
Removed:
MySQL-python.x86_64 0:1.2.3-0.3.c1.1.el6
mysql-libs.x86_64 0:5.1.73-8.el6_8
Dependency Removed:
cloudera-manager-agent.x86_64 0:5.11.1-1.cm5111.p0.9.el6
cronie.x86_64 0:1.4.4-16.el6_8.2
cronie-anacron.x86_64 0:1.4.4-16.el6_8.2
crontabs.noarch 0:1.10-33.el6
postfix.x86_64 2:2.6.6-8.el6
redhat-lsb.x86_64 0:4.0-7.el6.centos
redhat-lsb-compat.x86_64 0:4.0-7.el6.centos
redhat-lsb-core.x86_64 0:4.0-7.el6.centos
redhat-lsb-graphics.x86_64 0:4.0-7.el6.centos
redhat-lsb-printing.x86_64 0:4.0-7.el6.centos
sysstat.x86_64 0:9.0.4-33.el6
Complete!
3、用whereis命令查找mysql相關的文件，因為步驟2用yum來卸載，所以mysql被清理得很干凈；如果使用rpm將會很麻煩，有很多的文件需要手動清除
[root@cdh1 zjl]# whereis mysql mysql:
4、查看系統(tǒng)中的mysql安裝包
[root@cdh1 zjl]# yum list mysql* Loaded plugins: fastestmirror, refresh-packagekit, security Loading mirror speeds from cached hostfile * base: mirrors.zju.edu.cn * extras: mirrors.aliyun.com * updates: mirrors.aliyun.com Available Packages MySQL-python.x86_64 1.2.3-0.3.c1.1.el6 base mysql.x86_64 5.1.73-8.el6_8 base mysql-bench.x86_64 5.1.73-8.el6_8 base mysql-connector-java.noarch 1:5.1.17-6.el6 base mysql-connector-odbc.x86_64 5.1.5r1144-7.el6 base mysql-devel.i686 5.1.73-8.el6_8 base mysql-devel.x86_64 5.1.73-8.el6_8 base mysql-embedded.i686 5.1.73-8.el6_8 base mysql-embedded.x86_64 5.1.73-8.el6_8 base mysql-embedded-devel.i686 5.1.73-8.el6_8 base mysql-embedded-devel.x86_64 5.1.73-8.el6_8 base mysql-libs.i686 5.1.73-8.el6_8 base mysql-libs.x86_64 5.1.73-8.el6_8 base mysql-server.x86_64 5.1.73-8.el6_8 base mysql-test.x86_64 5.1.73-8.el6_8 base
5、選擇mysql-server來安裝
[root@cdh1 zjl]# yum install mysql-server Loaded plugins: fastestmirror, refresh-packagekit, security Setting up Install Process Loading mirror speeds from cached hostfile * base: mirrors.zju.edu.cn * extras: mirrors.aliyun.com * updates: mirrors.aliyun.com Resolving Dependencies --> Running transaction check ---> Package mysql-server.x86_64 0:5.1.73-8.el6_8 will be installed --> Processing Dependency: mysql = 5.1.73-8.el6_8 for package: mysql-server-5.1.73-8.el6_8.x86_64 --> Processing Dependency: perl-DBI for package: mysql-server-5.1.73-8.el6_8.x86_64 --> Processing Dependency: perl-DBD-MySQL for package: mysql-server-5.1.73-8.el6_8.x86_64 --> Processing Dependency: perl(DBI) for package: mysql-server-5.1.73-8.el6_8.x86_64 --> Processing Dependency: libmysqlclient_r.so.16(libmysqlclient_16)(64bit) for package: mysql-server-5.1.73-8.el6_8.x86_64 --> Processing Dependency: libmysqlclient.so.16(libmysqlclient_16)(64bit) for package: mysql-server-5.1.73-8.el6_8.x86_64 --> Processing Dependency: libmysqlclient_r.so.16()(64bit) for package: mysql-server-5.1.73-8.el6_8.x86_64 --> Processing Dependency: libmysqlclient.so.16()(64bit) for package: mysql-server-5.1.73-8.el6_8.x86_64 --> Running transaction check ---> Package mysql.x86_64 0:5.1.73-8.el6_8 will be installed ---> Package mysql-libs.x86_64 0:5.1.73-8.el6_8 will be installed ---> Package perl-DBD-MySQL.x86_64 0:4.013-3.el6 will be installed ---> Package perl-DBI.x86_64 0:1.609-4.el6 will be installed --> Finished Dependency Resolution Dependencies Resolved ================================================================================================================================================================================================================= Package Arch Version Repository Size ================================================================================================================================================================================================================= Installing: mysql-server x86_64 5.1.73-8.el6_8 base 8.6 M Installing for dependencies: mysql x86_64 5.1.73-8.el6_8 base 895 k mysql-libs x86_64 5.1.73-8.el6_8 base 1.2 M perl-DBD-MySQL x86_64 4.013-3.el6 base 134 k perl-DBI x86_64 1.609-4.el6 base 705 k Transaction Summary ================================================================================================================================================================================================================= Install 5 Package(s) Total download size: 12 M Installed size: 33 M Is this ok [y/N]: 6、選擇y繼續(xù)安裝 Is this ok [y/N]: y Downloading Packages: (1/5): mysql-5.1.73-8.el6_8.x86_64.rpm | 895 kB 00:00 (2/5): mysql-libs-5.1.73-8.el6_8.x86_64.rpm | 1.2 MB 00:00 (3/5): mysql-server-5.1.73-8.el6_8.x86_64.rpm | 8.6 MB 00:02 (4/5): perl-DBD-MySQL-4.013-3.el6.x86_64.rpm | 134 kB 00:00 (5/5): perl-DBI-1.609-4.el6.x86_64.rpm | 705 kB 00:00 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Total 2.2 MB/s | 12 MB 00:05 Running rpm_check_debug Running Transaction Test Transaction Test Succeeded Running Transaction Installing : mysql-libs-5.1.73-8.el6_8.x86_64 1/5 Installing : perl-DBI-1.609-4.el6.x86_64 2/5 Installing : perl-DBD-MySQL-4.013-3.el6.x86_64 3/5 Installing : mysql-5.1.73-8.el6_8.x86_64 4/5 Installing : mysql-server-5.1.73-8.el6_8.x86_64 5/5 Verifying : perl-DBD-MySQL-4.013-3.el6.x86_64 1/5 Verifying : mysql-libs-5.1.73-8.el6_8.x86_64 2/5 Verifying : mysql-server-5.1.73-8.el6_8.x86_64 3/5 Verifying : mysql-5.1.73-8.el6_8.x86_64 4/5 Verifying : perl-DBI-1.609-4.el6.x86_64 5/5 Installed: mysql-server.x86_64 0:5.1.73-8.el6_8 Dependency Installed: mysql.x86_64 0:5.1.73-8.el6_8 mysql-libs.x86_64 0:5.1.73-8.el6_8 perl-DBD-MySQL.x86_64 0:4.013-3.el6 perl-DBI.x86_64 0:1.609-4.el6 Complete!
7、啟動mysql服務
[root@cdh1 zjl]# service mysqld start
Initializing MySQL database: Installing MySQL system tables...
OK
Filling help tables...
OK
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 cdh1.zjl.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
Please report any problems with the /usr/bin/mysqlbug script!
[ OK ]
Starting mysqld: [ OK ]
8、連接一下試一下，直接mysql然后\q關閉連接
[root@cdh1 zjl]# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 Server version: 5.1.73 Source distribution Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> \q Bye
9、設置mysql開機啟動
[root@cdh1 zjl]# chkconfig mysqld on
10、開啟3306端口，并保存
[root@cdh1 zjl]# /sbin/iptables -I INPUT -p tcp --dport 3306 -j ACCEPT [root@cdh1 zjl]# /etc/rc.d/init.d/iptables save
11、連接mysql設置密碼
[root@cdh1 zjl]# mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.1.73 Source distribution
Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> update user set password=password('123') where user='root';
Query OK, 3 rows affected (0.02 sec)
Rows matched: 3 Changed: 3 Warnings: 0
mysql> flush privileges;
Query OK, 0 rows affected (0.02 sec)
mysql> \q
Bye
12、重啟mysql服務
[root@cdh1 zjl]# service mysqld restart Stopping mysqld: [ OK ] Starting mysqld: [ OK ]
以上所述是小編給大家介紹的centos 6.9安裝mysql的詳細教程，希望對大家有所幫助，如果大家有任何疑問請給我留言，小編會及時回復大家的。在此也非常感謝大家對腳本之家網站的支持！
相關文章
這篇文章主要給大家介紹了關于MySQL中or、in、union與索引優(yōu)化的相關資料，文中通過示例代碼介紹的非常詳細，對大家學習或者使用MySQL具有一定的參考學習價值，需要的朋友們下面來一起學習學習吧2019-12-12
MySQL 提供了多種類型的變量,以適應不同的應用場景,用戶定義的變量適用于簡單的會話內數(shù)據傳遞,局部變量適合在復雜的存儲過程中使用,而會話變量則用于調整和優(yōu)化數(shù)據庫會話的行為,這篇文章主要介紹了MySQL 中定義和使用變量,需要的朋友可以參考下2024-04-04
這篇文章主要介紹了MySQL中的樂觀鎖和悲觀鎖和MVCC全面解析的相關資料，幫助大家更好的理解和學習MySQL數(shù)據庫，感興趣的朋友可以了解下2021-01-01
win10 下安裝mysql服務器社區(qū)版本mysql 5.7.22 winx64的圖文教程
這篇文章主要介紹了win10 下安裝mysql服務器社區(qū)版本mysql 5.7.22 winx64的圖文教程,非常不錯，具有一定的參考借鑒價值，需要的朋友可以參考下2018-05-05
driver-class-name:?com.mysql.jdbc.Driver爆紅的問題解決
在springboot項目工程中想要進行數(shù)據庫配置,driver-class-name:?com.mysql.cj.jdbc.Driver始終報錯,本文就來介紹一下如何解決,感興趣的可以了解一下2024-07-07
數(shù)據庫的操作越來越成為整個應用的性能瓶頸了，這點對于Web應用尤其明顯。這篇文章主要介紹了MySQL數(shù)據庫21條最佳性能優(yōu)化經驗的相關資料,需要的朋友可以參考下2016-10-10
文章介紹了4種修改MySQL密碼的方法,包括使用setpassword命令、mysqladmin命令、修改user表以及忘記密碼時的處理步驟,感興趣的朋友一起看看吧2025-03-03
如果你需要windows mysql 主、備機雙向同步環(huán)境，可按照以下步驟進行操作2011-05-05
這篇文章主要介紹了詳解MySQL中ALTER命令的使用,是MySQL入門學習中的基礎知識,需要的朋友可以參考下2015-05-05
這篇文章主要給大家介紹了關于MySQL服務器 IO 100%的相關資料，文中通過示例代碼介紹的介紹非常詳細，對大家學習或者使用mysql具有一定的參考學習價值，需要的朋友們下面隨著小編來一起學習學習吧2018-10-10