关闭

CENTOS7使用rpm方式安装mysql5.7.18

标签: centosmysqlrpm
1835人阅读 评论(0) 收藏 举报

1、# yum install libaio  //mysql依赖包

2、# rpm -ivh mysql-community-libs-5.7.17-1.el6.x86_64.rpm  mysql-community-client-5.7.17-1.el6.x86_64.rpm mysql-community-common-5.7.17-1.el6.x86_64.rpm mysql-community-server-5.7.17-1.el6.x86_64.rpm  //安装mysql

3、#/etc/init.d/mysqld start  //开启mysql

Starting mysqld (via systemctl):                 [  OK  ]//开启成功

4、#cat /var/log/mysqld.log  //查看mysql的初始密码

2017-04-12T08:08:09.129189Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2017-04-12T08:08:10.300168Z 0 [Warning] InnoDB: New log files created, LSN=45790
2017-04-12T08:08:10.376838Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2017-04-12T08:08:10.394301Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 2b1bbadd-1f57-11e7-a13b-f23c91bcd804.
2017-04-12T08:08:10.395575Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2017-04-12T08:08:10.397081Z 1 [Note] A temporary password is generated for root@localhost:VIsoqx.z:4!L(密码)
2017-04-12T08:08:12.994015Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).

5、#mysql -u root -p VIsoqx.z:4!L  //登录mysql

6、ALTER USER 'root'@'localhost' IDENTIFIED BY 'your_new_password';

至此,mysql安装配置成功

以下命令是开启mysql的远程访问:

UPDATE user SET HOST = '%' WHERE USER ='root';

FLUSH PRIVILEGES; 

0
1
查看评论
发表评论
* 以上用户言论只代表其个人观点,不代表CSDN网站的观点或立场

MySQL5.7.18 源码安装详细步骤

MySQL5.7.18 源码安装详细步骤 一:操作系统环境和目录结构 [root@mysql3 ~]# cat /etc/redhat-release Red Hat Enter...
  • Hwh1231
  • Hwh1231
  • 2017-05-08 17:51
  • 4238

Centos6编译安装Mysql5.7.18, rpm 安装mysql5.7.18,ubuntu apt安装mysql

关键字: centos 编译安装mysql5.7.18 rpm安装5.7.18,ubuntu apt -get 安装mysql 一. 编译安装前的准备1.1 卸载原有的Mysql在root用户下操...
  • T1DMzks
  • T1DMzks
  • 2017-05-07 22:00
  • 3391

mysql5.7.18+linux安装二进制包与运行

mysql5.7.18
  • acrux1985
  • acrux1985
  • 2017-04-11 13:56
  • 4314

Linux CentOS MySQL 5.7.18 5.7.X安装教程

Linux CentOS MySQL 5.7.18 5.7.X安装教程
  • guoxingege
  • guoxingege
  • 2017-04-24 10:53
  • 5491

CentOS7下安装mysql-5.7.18

CentOS7下安装mysql-5.7.18 前言:楼主以前一直用的CentOs6.6,准备在这个环境上安装一个最新版本的mysql-5.7.18. 于是就开始下载mysql-5.7.18的rpm安装...
  • tianhouquan
  • tianhouquan
  • 2017-06-24 18:16
  • 2653

CentOS7下安装mysql-5.7.18

本文参考了: http://blog.csdn.net/peng314899581/article/details/70241976 http://www.cnblogs.com/pythonal/p...
  • heting717
  • heting717
  • 2017-05-11 18:20
  • 1938

MySQL5.7.18 源码安装详细步骤

MySQL5.7.18 源码安装详细步骤 一:操作系统环境和目录结构 [root@mysql3 ~]# cat /etc/redhat-release Red Hat Enter...
  • Hwh1231
  • Hwh1231
  • 2017-05-08 17:51
  • 4238

安装MySQL5.7.18遇到的坑

最近才注意到MySQL的各个版本之间差别还挺大的,比如5.5.x版本的timestamp类型列只能有一个设置为default CURRENT_TIMESTAMP的,于是尝试了换成一个新版本是mysq...
  • achilles12345
  • achilles12345
  • 2017-06-22 17:27
  • 1574

解决mysql-5.7.18安装,MySQL服务无法启动

MySQL 是一个非常强大的关系型数据库。但有些初学者在安装配置的时候,遇到种种的困难,在此就不说安装过程了,说一下配置过程。在官网下载的mysql时候,有msi格式和zip格式。Msi直接运行安装即...
  • chasing_the_sun
  • chasing_the_sun
  • 2017-04-30 18:39
  • 3640

CentOS的简单使用之配置编译MySQL( 版本号:mysql-community-5.7.18-1.el7.src.rpm,主要参考官网方法)

一、编译安装MySQL前的准备工作卸载mariadb; yum -y remove mariadb*;Dependencies Resolved============================...
  • qq_32087569
  • qq_32087569
  • 2017-06-29 14:32
  • 629
    个人资料
    • 访问:113087次
    • 积分:1799
    • 等级:
    • 排名:千里之外
    • 原创:58篇
    • 转载:51篇
    • 译文:0篇
    • 评论:9条
    最新评论