各位用户为了找寻关于centos 6.5下 mysql-community-server. 5.7.18-1.el6安装的资料费劲了很多周折。这里教程网为您整理了关于centos 6.5下 mysql-community-server. 5.7.18-1.el6安装的相关资料，仅供查阅，以下为您介绍关于centos 6.5下 mysql-community-server. 5.7.18-1.el6安装的详细内容

使用下面的命令检查是否安装有MySQL Server

? 1 [root@localhost etc]# rpm -qa | grep mysql // 这个命令就会查看该操作系统上是否已经安装了mysql数据库

   有的话，我们就通过 rpm -e 命令 或者 rpm -e --nodeps 命令来卸载掉

? 1 2 [root@localhost ~]# rpm -e mysql　　// 普通删除模式 [root@localhost ~]# rpm -e --nodeps mysql　　// 强力删除模式，如果使用上面命令删除时，提示有依赖的其它文件，则用该命令可以对其进行强力删除

   在删除完以后我们可以通过 rpm -qa | grep mysql 命令来查看mysql是否已经卸载成功！！

官网yum repository 下载安装包

? 1 2 3 4 5 6 7 8 9 10 [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包

? 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 [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!

　　查看可用的安装包　

? 1 2 3 4 [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

? 1 [root@localhost yum.repos.d]# yum install gcc*　

安装mysql

? 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 [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

? 1 2 3 4 [root@localhost yum.repos.d]# service mysqld start　　 Initializing MySQL database:                [ OK ] Installing validate password plugin:            [ OK ] Starting mysqld:

　　进入mysql安全模式

? 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 [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主机地址 -u用户名 －p用户密码

1、例1：连接到本机上的MYSQL

   找到mysql的安装目录，一般可以直接键入命令mysql -uroot -p，回车后提示你输密码，如果刚安装好MYSQL，超级用户root是没有密码的，故直接回车即可进入到MYSQL中

了，MYSQL的提示符是：mysql>

2、连接到远程主机上的MYSQL

   假设远程主机的IP为：10.0.0.1，用户名为root,密码为123。则键入以下命令：

? 1 mysql -h10.0.0.1 -uroot -p123

  （注：u与root可以不用加空格，其它也一样）

配置防火墙

防火墙的3306端口默认没有开启，若要远程访问，需要开启这个端口

打开/etc/sysconfig/iptables

在“-A INPUT –m state --state NEW –m tcp –p tcp –dport 22 –j ACCEPT”，下添加：

? 1 -A INPUT -m state --state NEW -m tcp -p tcp --dport 3306 -j ACCEPT

然后保存，并关闭该文件，在终端内运行下面的命令，刷新防火墙配置：

service iptables restart OK，一切配置完毕，你可以访问你的MySQL了~

注意：增加的开放3306端口的语句一定要在icmp-host-prohibited之前

? 1 2 3 4 5 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安装，希望对大家有所帮助，如果大家有任何疑问请给我留言，小编会及时回复大家的。在此也非常感谢大家对网站的支持！