幽灵资源网

centos 6.5下 mysql-community-server. 5.7.18-1.el6安装
数据库 2024/12/25 佚名
3 2
幽灵资源网 Design By www.bzswh.com

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

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

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

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

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

官网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:

　　进入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主机地址 -u用户名 －p用户密码

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

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

了，MYSQL的提示符是：mysql>

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

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

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”，下添加：

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

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

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

标签：
centos,mysql,server
幽灵资源网 Design By www.bzswh.com
广告合作：本站广告合作请联系QQ：858582 申请时备注：广告合作（否则不回）
免责声明：本站文章均来自网站采集或用户投稿，网站不提供任何软件下载或自行开发的软件！ 如有用户或公司发现本站内容信息存在侵权行为，请邮件告知！ 858582#qq.com
幽灵资源网 Design By www.bzswh.com
www.bzswh.com 幽灵资源网
143,552互联网资源
29,117高清电影
46,608技术教程
224,608站长资源

友情链接

杰晶网络 DDR爱好者之家 桃源资源网 杰网资源 富贵资源网 南强小屋 铁雪资源网 幽灵资源网 万梅资源网 狼山资源网 白云岛资源网 昆仑资源网 相思资源网 明霞山资源网 内蒙古资源网 黑松山资源网 茶园资源网 饿虎岗资源网 大旗谷资源网 常春岛资源网 岱庙资源网 兴国资源网 快活林资源网 蝙蝠岛资源网 帝王谷资源网 白云城资源网 伏龙阁资源网 清风细雨楼 天枫庄资源网 圆月山庄资源网 无争山庄资源网 神水资源网 移花宫资源网 神剑山庄资源网 无为清净楼资源网 金钱帮资源网 丐帮资源网 华山资源网 极乐门资源网 小李飞刀资源网 凤求凰客栈 风云阁资源网 金狮镖局 鸳鸯亭资源网 千金楼资源网 更多链接
幽灵资源网 Design By www.bzswh.com