centos 6.5下 mysql-community-server. 5.7.18-1.el6安裝
更新時間：2017年04月27日 13:52:02 投稿：mrr
這篇文章主要介紹了centos 6.5下 mysql-community-server. 5.7.18-1.el6安裝,需要的朋友可以參考下
使用下面的命令檢查是否安裝有MySQL Server
[root@localhost etc]# rpm -qa | grep mysql // 這個命令就會查看該操作系統(tǒng)上是否已經(jīng)安裝了mysql數(shù)據(jù)庫
有的話，我們就通過 rpm -e 命令 或者 rpm -e --nodeps 命令來卸載掉
[root@localhost ~]# rpm -e mysql // 普通刪除模式 [root@localhost ~]# rpm -e --nodeps mysql // 強(qiáng)力刪除模式，如果使用上面命令刪除時，提示有依賴的其它文件，則用該命令可以對其進(jìn)行強(qiáng)力刪除
在刪除完以后我們可以通過 rpm -qa | grep mysql 命令來查看mysql是否已經(jīng)卸載成功！！
官網(wǎng)yum repository 下載安裝包
[root@localhost ~]# wget http://dev.mysql.com/get/mysql57-community-release-el6-10.noarch.rpm --2017-04-24 18:53:49-- http://dev.mysql.com/get/mysql57-community-release-el6-10.noarch.rpm Resolving dev.mysql.com... 137.254.60.11 Connecting to dev.mysql.com|137.254.60.11|:80... connected. HTTP request sent, awaiting response... 301 Moved Permanently Location: https://dev.mysql.com/get/mysql57-community-release-el6-10.noarch.rpm [following] --2017-04-24 18:53:49-- https://dev.mysql.com/get/mysql57-community-release-el6-10.noarch.rpm Connecting to dev.mysql.com|137.254.60.11|:443... connected. ERROR: certificate common name “www.mysql.com” doesn't match requested host name “dev.mysql.com”. To connect to dev.mysql.com insecurely, use ‘--no-check-certificate'
本地安裝下載下來的rpm包
[root@localhost ~]# yum localinstall mysql57-community-release-el6-10.noarch.rpm Loaded plugins: fastestmirror, refresh-packagekit, security Setting up Local Package Process Examining mysql57-community-release-el6-10.noarch.rpm: mysql57-community-release-el6-10.noarch Marking mysql57-community-release-el6-10.noarch.rpm to be installed Loading mirror speeds from cached hostfile * base: mirrors.cn99.com * extras: mirrors.cn99.com * updates: mirrors.cn99.com Resolving Dependencies --> Running transaction check ---> Package mysql57-community-release.noarch 0:el6-10 will be installed --> Finished Dependency Resolution Dependencies Resolved =============================================================================================================================================================================================== Package Arch Version Repository Size =============================================================================================================================================================================================== Installing: mysql57-community-release noarch el6-10 /mysql57-community-release-el6-10.noarch 30 k Transaction Summary =============================================================================================================================================================================================== Install 1 Package(s) Total size: 30 k Installed size: 30 k Is this ok [y/N]: y Downloading Packages: Running rpm_check_debug Running Transaction Test Transaction Test Succeeded Running Transaction Installing : mysql57-community-release-el6-10.noarch 1/1 Verifying : mysql57-community-release-el6-10.noarch 1/1 Installed: mysql57-community-release.noarch 0:el6-10 Complete!
查看可用的安裝包
[root@localhost ~]# yum repolist enabled|grep mysql mysql-connectors-community MySQL Connectors Community 33 mysql-tools-community MySQL Tools Community 47 mysql57-community MySQL 5.7 Community Server 183
安裝前裝gcc所有包，防止報錯[Errno -1] Package does not match intended download
[root@localhost yum.repos.d]# yum install gcc*
安裝mysql
[root@localhost yum.repos.d]# yum install -y mysql-community-server Loaded plugins: fastestmirror, refresh-packagekit, security Loading mirror speeds from cached hostfile * base: mirrors.cn99.com * extras: mirrors.cn99.com * updates: mirrors.cn99.com Setting up Install Process Resolving Dependencies --> Running transaction check ---> Package mysql-community-server.x86_64 0:5.7.18-1.el6 will be installed --> Processing Dependency: mysql-community-common(x86-64) = 5.7.18-1.el6 for package: mysql-community-server-5.7.18-1.el6.x86_64 --> Processing Dependency: mysql-community-client(x86-64) >= 5.7.9 for package: mysql-community-server-5.7.18-1.el6.x86_64 --> Running transaction check ---> Package mysql-community-client.x86_64 0:5.7.18-1.el6 will be installed --> Processing Dependency: mysql-community-libs(x86-64) >= 5.7.9 for package: mysql-community-client-5.7.18-1.el6.x86_64 ---> Package mysql-community-common.x86_64 0:5.7.18-1.el6 will be installed --> Running transaction check ---> Package mysql-community-libs.x86_64 0:5.7.18-1.el6 will be obsoleting ---> Package mysql-libs.x86_64 0:5.1.71-1.el6 will be obsoleted --> Processing Dependency: libmysqlclient.so.16()(64bit) for package: 2:postfix-2.6.6-2.2.el6_1.x86_64 --> Processing Dependency: libmysqlclient.so.16(libmysqlclient_16)(64bit) for package: 2:postfix-2.6.6-2.2.el6_1.x86_64 --> Running transaction check ---> Package mysql-community-libs-compat.x86_64 0:5.7.18-1.el6 will be obsoleting ---> Package postfix.x86_64 2:2.6.6-2.2.el6_1 will be updated ---> Package postfix.x86_64 2:2.6.6-8.el6 will be an update --> Finished Dependency Resolution Dependencies Resolved ============================================================================================================================= Package Arch Version Repository Size ============================================================================================================================= Installing: mysql-community-libs x86_64 5.7.18-1.el6 mysql57-community 2.1 M replacing mysql-libs.x86_64 5.1.71-1.el6 mysql-community-libs-compat x86_64 5.7.18-1.el6 mysql57-community 1.6 M replacing mysql-libs.x86_64 5.1.71-1.el6 mysql-community-server x86_64 5.7.18-1.el6 mysql57-community 152 M Installing for dependencies: mysql-community-client x86_64 5.7.18-1.el6 mysql57-community 23 M mysql-community-common x86_64 5.7.18-1.el6 mysql57-community 328 k Updating for dependencies: postfix x86_64 2:2.6.6-8.el6 base 2.0 M Transaction Summary ============================================================================================================================= Install 5 Package(s) Upgrade 1 Package(s) Total size: 180 M Total download size: 152 M Downloading Packages: mysql-community-server-5.7.18-1.el6.x86_64.rpm | 152 MB 01:41 warning: rpmts_HdrFromFdno: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql Importing GPG key 0x5072E1F5: Userid : MySQL Release Engineering <mysql-build@oss.oracle.com> Package: mysql57-community-release-el6-10.noarch (@/mysql57-community-release-el6-10.noarch) From : /etc/pki/rpm-gpg/RPM-GPG-KEY-mysql Running rpm_check_debug Running Transaction Test Transaction Test Succeeded Running Transaction Installing : mysql-community-common-5.7.18-1.el6.x86_64 1/8 Installing : mysql-community-libs-5.7.18-1.el6.x86_64 2/8 Installing : mysql-community-libs-compat-5.7.18-1.el6.x86_64 3/8 Installing : mysql-community-client-5.7.18-1.el6.x86_64 4/8 Installing : mysql-community-server-5.7.18-1.el6.x86_64 5/8 Updating : 2:postfix-2.6.6-8.el6.x86_64 6/8 Cleanup : 2:postfix-2.6.6-2.2.el6_1.x86_64 7/8 Erasing : mysql-libs-5.1.71-1.el6.x86_64 8/8 Verifying : 2:postfix-2.6.6-8.el6.x86_64 1/8 Verifying : mysql-community-libs-compat-5.7.18-1.el6.x86_64 2/8 Verifying : mysql-community-server-5.7.18-1.el6.x86_64 3/8 Verifying : mysql-community-libs-5.7.18-1.el6.x86_64 4/8 Verifying : mysql-community-common-5.7.18-1.el6.x86_64 5/8 Verifying : mysql-community-client-5.7.18-1.el6.x86_64 6/8 Verifying : 2:postfix-2.6.6-2.2.el6_1.x86_64 7/8 Verifying : mysql-libs-5.1.71-1.el6.x86_64 8/8 Installed: mysql-community-libs.x86_64 0:5.7.18-1.el6 mysql-community-libs-compat.x86_64 0:5.7.18-1.el6 mysql-community-server.x86_64 0:5.7.18-1.el6 Dependency Installed: mysql-community-client.x86_64 0:5.7.18-1.el6 mysql-community-common.x86_64 0:5.7.18-1.el6 Dependency Updated: postfix.x86_64 2:2.6.6-8.el6 Replaced: mysql-libs.x86_64 0:5.1.71-1.el6 Complete!
啟動mysql
[root@localhost yum.repos.d]# service mysqld start Initializing MySQL database: [ OK ] Installing validate password plugin: [ OK ] Starting mysqld:
進(jìn)入mysql安全模式
[root@localhost yum.repos.d]# killall -TERM mysqld
[root@localhost yum.repos.d]# mysqld_safe --skip-grant-tables &
[1] 40422
[root@localhost yum.repos.d]# 2017-04-25T07:45:39.222061Z mysqld_safe Logging to '/var/log/mysqld.log'.
2017-04-25T07:45:39.246117Z mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.7.18 MySQL Community Server (GPL)
Copyright (c) 2000, 2017, 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> select * from users;
ERROR 1146 (42S02): Table 'mysql.users' doesn't exist
mysql> select * from user;
mysql> update user set authentication_string=PASSWORD('mysql') where user='root';
Query OK, 1 row affected, 1 warning (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 1
mysql> quit
Bye
[2]+ Exit 1 mysqld_safe --skip-grant-tables
[root@localhost yum.repos.d]# service mysqld start
Starting mysqld: [ OK ]
[root@localhost yum.repos.d]# mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 5
Server version: 5.7.18 MySQL Community Server (GPL)
Copyright (c) 2000, 2017, 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 -h主機(jī)地址 -u用戶名 －p用戶密碼
1、例1：連接到本機(jī)上的MYSQL
找到mysql的安裝目錄，一般可以直接鍵入命令mysql -uroot -p，回車后提示你輸密碼，如果剛安裝好MYSQL，超級用戶root是沒有密碼的，故直接回車即可進(jìn)入到MYSQL中
了，MYSQL的提示符是：mysql>
2、連接到遠(yuǎn)程主機(jī)上的MYSQL
假設(shè)遠(yuǎn)程主機(jī)的IP為：10.0.0.1，用戶名為root,密碼為123。則鍵入以下命令：
mysql -h10.0.0.1 -uroot -p123
（注：u與root可以不用加空格，其它也一樣）
配置防火墻
防火墻的3306端口默認(rèn)沒有開啟，若要遠(yuǎn)程訪問，需要開啟這個端口
打開/etc/sysconfig/iptables
在“-A INPUT –m state --state NEW –m tcp –p tcp –dport 22 –j ACCEPT”，下添加：
-A INPUT -m state --state NEW -m tcp -p tcp --dport 3306 -j ACCEPT
然后保存，并關(guān)閉該文件，在終端內(nèi)運行下面的命令，刷新防火墻配置：
service iptables restart OK，一切配置完畢，你可以訪問你的MySQL了~
注意：增加的開放3306端口的語句一定要在icmp-host-prohibited之前
mysql -uroot -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 3 Server version: 5.7.18 MySQL Community Server (GPL)
Copyright (c) 2000, 2017, 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.
以上所述是小編給大家介紹的centos 6.5下 mysql-community-server. 5.7.18-1.el6安裝，希望對大家有所幫助，如果大家有任何疑問請給我留言，小編會及時回復(fù)大家的。在此也非常感謝大家對腳本之家網(wǎng)站的支持！
您可能感興趣的文章:
- mysql installer community 8.0.16.0安裝配置圖文教程
- mysql installer community 5.7.16安裝詳細(xì)教程
- mysql installer web community 5.7.21.0.msi安裝圖文教程
- mysql installer community 8.0.12.0安裝圖文教程
- MySQL Installer is running in Community mode 的解決辦法
- MySQL Community Server 8.0.11安裝配置方法圖文教程
- Unity連接MySQL并讀取表格數(shù)據(jù)的實現(xiàn)代碼
相關(guān)文章
Mysql8導(dǎo)入數(shù)據(jù)到Mysql5.7的實現(xiàn)步驟
Mysql8的默認(rèn)字符集為utf8mb4，當(dāng)我們有需求要把Mysql8的數(shù)據(jù)導(dǎo)入到Mysql5.7時，就會出現(xiàn)不支持，本文主要介紹了2種解決方法，具有一定的參考價值，感興趣的可以了解一下2022-03-03
觸發(fā)器trigger是一種特殊的存儲過程,他在插入(inset)、刪除(delete)或修改(update)特定表中的數(shù)據(jù)時觸發(fā)執(zhí)行,下面這篇文章主要給大家介紹了關(guān)于MySQL觸發(fā)器使用的相關(guān)資料,需要的朋友可以參考下2022-06-06
一鍵搭建MYSQL主從，輕松應(yīng)對數(shù)據(jù)備份與恢復(fù)
MYSQL主從是一種常見的數(shù)據(jù)庫架構(gòu),它可以提高數(shù)據(jù)庫的可用性和性能,在主從架構(gòu)中,主數(shù)據(jù)庫負(fù)責(zé)處理寫操作,而從數(shù)據(jù)庫負(fù)責(zé)處理讀操作,當(dāng)主數(shù)據(jù)庫發(fā)生故障時,從數(shù)據(jù)庫可以接管并繼續(xù)提供服務(wù),從而實現(xiàn)高可用性,需要的朋友可以參考下2023-10-10
這篇文章主要介紹了Mysql8.0.22解壓版安裝教程(小白專用)，文中通過圖文介紹的非常詳細(xì)，對大家的學(xué)習(xí)或者工作具有一定的參考學(xué)習(xí)價值，需要的朋友們下面隨著小編來一起學(xué)習(xí)學(xué)習(xí)吧2020-12-12
這篇文章主要介紹了mysql如何將查詢結(jié)果插入到另一張表中問題,具有很好的參考價值,希望對大家有所幫助,如有錯誤或未考慮完全的地方,望不吝賜教2023-10-10
MySQL數(shù)據(jù)庫在安裝或卸載的過程中,常常會出現(xiàn)一些錯誤,這是件讓我們頭疼的事,下面這篇文章主要給大家介紹了關(guān)于MySQL安裝常見報錯處理方法的相關(guān)資料,文中通過實例代碼介紹的非常詳細(xì),需要的朋友可以參考下2022-07-07
創(chuàng)建primay key過程中發(fā)生了斷電，當(dāng)電腦再次啟動時候，發(fā)現(xiàn)mysql 服務(wù)無法啟動，使用 net start 提示 1067錯誤;后來只能通過手工刪除數(shù)據(jù)文件，日志文件，再啟動服務(wù)，然后導(dǎo)入數(shù)據(jù)來完成2013-01-01
這篇文章主要介紹了jmeter連接數(shù)據(jù)庫過程圖解,文中通過示例代碼介紹的非常詳細(xì)，對大家的學(xué)習(xí)或者工作具有一定的參考學(xué)習(xí)價值,需要的朋友可以參考下2019-10-10
這篇文章主要介紹了MySql連接不上問題及解決方案，具有很好的參考價值，希望對大家有所幫助。如有錯誤或未考慮完全的地方，望不吝賜教2023-06-06
InnoDB是為Mysql處理巨大數(shù)據(jù)量時的最大性能設(shè)計。它的CPU效率可能是任何其它基于磁盤的關(guān)系數(shù)據(jù)庫引擎所不能匹敵的。在數(shù)據(jù)量大的網(wǎng)站或是應(yīng)用中Innodb是倍受青睞的。那么它就不需要優(yōu)化了嗎，答案很顯然：當(dāng)然不是?。?！2017-03-03