主頁 > 知識庫 > centos 6.5下 mysql-community-server. 5.7.18-1.el6安裝

centos 6.5下 mysql-community-server. 5.7.18-1.el6安裝

熱門標(biāo)簽:安國在哪里辦理400電話 智能電銷機(jī)器人靠譜么 電銷機(jī)器人公眾號推送 地圖標(biāo)注培訓(xùn) 電銷機(jī)器人說明書 手機(jī)用地圖標(biāo)注工具 南宋地圖標(biāo)注黃河華山 長安區(qū)違法建房地圖標(biāo)注 昆明智能外呼系統(tǒng)中心

使用下面的命令檢查是否安裝有MySQL Server

[root@localhost etc]# rpm -qa | grep mysql // 這個(gè)命令就會查看該操作系統(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)力刪除模式,如果使用上面命令刪除時(shí),提示有依賴的其它文件,則用該命令可以對其進(jìn)行強(qiáng)力刪除

   在刪除完以后我們可以通過 rpm -qa | grep mysql 命令來查看mysql是否已經(jīng)卸載成功?。?/p>

官網(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所有包,防止報(bào)錯(cuò)[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)程訪問,需要開啟這個(gè)端口

打開/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)運(yùn)行下面的命令,刷新防火墻配置:

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安裝,希望對大家有所幫助,如果大家有任何疑問請給我留言,小編會及時(shí)回復(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ù)的實(shí)現(xiàn)代碼

標(biāo)簽:南昌 武漢 江門 潛江 吉安 長沙 合肥 東莞

巨人網(wǎng)絡(luò)通訊聲明:本文標(biāo)題《centos 6.5下 mysql-community-server. 5.7.18-1.el6安裝》,本文關(guān)鍵詞  centos,6.5下,mysql-community-server.,;如發(fā)現(xiàn)本文內(nèi)容存在版權(quán)問題,煩請?zhí)峁┫嚓P(guān)信息告之我們,我們將及時(shí)溝通與處理。本站內(nèi)容系統(tǒng)采集于網(wǎng)絡(luò),涉及言論、版權(quán)與本站無關(guān)。
  • 相關(guān)文章
  • 下面列出與本文章《centos 6.5下 mysql-community-server. 5.7.18-1.el6安裝》相關(guān)的同類信息!
  • 本頁收集關(guān)于centos 6.5下 mysql-community-server. 5.7.18-1.el6安裝的相關(guān)信息資訊供網(wǎng)民參考!
  • 推薦文章