当前位置: 澳门新濠3559 > 数据库 > 正文

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

时间:2019-11-29 07:15来源:数据库
  注意:增加的开放3306端口的语句一定要在icmp-host-prohibited之前 --2017-04-24 18:53:49-- http://dev.mysql.com/get/mysql57-community-release-el6-10.noarch.rpmResolving dev.mysql.com... 137.254.60.11Connecting to dev.mysql

 

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

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

  

  

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

  

 

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

 

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

  

  (注:u与root可以不用加空格,其它也一样)

  进入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.
Initializing MySQL database:                               [  OK  ]
Installing validate password plugin:                       [  OK  ]
Starting mysqld:                                           [  OK  ]
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

Type 'help;' or 'h' for help. Type 'c' to clear the current input statement.

澳门新濠3559,mysql -h主机地址 -u用户名 -p用户密码
1、例1:连接到本机上的MYSQL

 

  

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

   mysql -h10.0.0.1 -uroot -p123

  

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

  

 

  

了,MYSQL的提示符是:mysql>

  查看可用的安装包

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

官网yum repository 下载安装包

 

 

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

 

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

 

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

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

 

本地安装下载下来的rpm包

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

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

  

 

安装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)

[root@localhost yum.repos.d]# yum install -y  mysql-community-server

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

 

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

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

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

 

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

配置防火墙
防火墙的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了~

编辑:数据库 本文来源:   使用下面的命令检查是否安装有MySQL Server

关键词: