--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’

 

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)

 

  

[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的提醒符是:mysql>

  

 

  (注:u与root能够毫不加空格,别的也一样)

  

[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.

  

只顾:扩展的开放330六端口的话语一定要在icmp-host-prohibited从前

  

   有的话,我们就由此 rpm -e 命令 恐怕 rpm -e –nodeps 命令来卸载掉

[root@localhost ~]# yum localinstall mysql57-community-release-el6-10.noarch.rpm

   找到mysql的设置目录,一般能够间接键入命令mysql -uroot
-p,回车后提醒您输密码,假使刚安装好MYSQL,拔尖用户root是从未密码的,故直接回车就能够进入到MYSQL中

 

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!

安装mysql

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]# yum install gcc*

地面安装下载下来的rpm包

Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights
reserved.

 

[root@localhost ~]# wget http://dev.mysql.com/get/mysql57-community-release-el6-10.noarch.rpm

 

 

 

  查看可用的安装包

二、连接到长途主机上的MYSQL

   mysql -h10.0.0.1 -uroot -p123

 

[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
[root@localhost yum.repos.d]# yum install -y  mysql-community-server
Initializing MySQL database:                               [  OK  ]
Installing validate password plugin:                       [  OK  ]
Starting mysqld:                                           [  OK  ]

 

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 -h主机地址 -u用户名 -p用户密码
一、例一:连接到本机上的MYSQL

 

 

   使用上面包车型地铁指令检查是或不是安装有MySQL Server

[root@localhost yum.repos.d]# service mysqld start

官方网址yum repository 下载安装包

  
若是远程主机的IP为:10.0.0.一,用户名称叫root,密码为1二三。则键入以下命令:

 

  

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

  

启动mysql

  进入mysql安全格局

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input
statement.

   在剔除完之后大家能够透过 rpm -qa | grep mysql
命令来查看mysql是或不是早已卸载成功!!

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

布置防火墙
4503.com,防火墙的330陆端口默许未有拉开,若要远程访问,供给开启这一个端口
打开/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了~

安装前装gcc全数包,防止报错[Errno -1]  Package does not match intended
download

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.