centos 6.5下 mysql-community-server. 5.7.18-…
2018-06-23 13:25:30来源：未知 阅读 ()
使用下面的命令检查是否安装有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: [ OK ]
进入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.
标签：
版权申明：本站文章部分自网络，如有侵权，请联系：west999com@outlook.com
特别注意：本站所有转载文章言论不代表本站观点，本站所提供的摄影照片，插画，设计作品，如需使用，请与原作者联系，版权归原作者所有
上一篇：下载MySQL数据库
下一篇：封装mysql的JDBC
相关文章
- mysql7.x如何单独安装mysql 2020-02-27
- CentOS7.2与Nginx配置虚拟主机详解 2019-08-29
- centos7下yum方式安装MySQL5.7 2019-07-24
- Linux(Centos7)下Mysql的安装 2019-07-24
- Centos6.8忘记MySQL数据库root密码解决方法 2019-07-24
IDC资讯： 主机资讯 注册资讯 托管资讯 vps资讯 网站建设
网站运营： 建站经验 策划盈利 搜索优化 网站推广 免费资源
网络编程： Asp.Net编程 Asp编程 Php编程 Xml编程 Access Mssql Mysql 其它
服务器技术： Web服务器 Ftp服务器 Mail服务器 Dns服务器 安全防护
软件技巧： 其它软件 Word Excel Powerpoint Ghost Vista QQ空间 QQ FlashGet 迅雷
网页制作： FrontPages Dreamweaver Javascript css photoshop fireworks Flash
热门词条
最新资讯
热门关注
热门标签