centos7 yum mysql5.7 install
来源:互联网 发布:世界程序员的名片 编辑:程序博客网 时间:2024/05/17 02:36
卸载centos7默认安装的MariaDB,因为和mysql有冲突
#rpm -qa | grep mariamariadb-libs-5.5.52-1.el7.x86_64
#yum remove mariadb-libs -y
下载最新的mysql官方yum源
https://dev.mysql.com/downloads/repo/yum/
安装:yum localinstall mysql57-community-release-el7-9.noarch.rpm
用yum info命令搜索mysql-community-server,确认详细的信息
yum info mysql-community-server
最后:yum install mysql-community-server -y
可以看到默认需要依赖的安装包:
设置开机启动mysql服务:
systemctl enable mysqld.service
systemctl daemon-reload
启动mysql服务:
systemctl start mysqld.service
停止:
systemctl stop mysqld.service
查看mysql运行状态:
systemctl status mysqld.service
配置mysql,重置root密码,默认生成的密码在/var/log/mysqld.log,首先以这个密码登录mysql来修改root密码
mysql -uroot -p
如果不修改密码执行mysql命令,mysql5.7会提示:
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
可见mysql的安全性做的越来越高,接下来修改root密码
ALTER USER 'root'@'localhost' IDENTIFIED BY 'xxxxxxxxxx';
修改mysql编码,修改/etc/my.cnf配置文件,在[mysqld]下添加编码配置
character_set_server=utf8
init_connect='SET NAMES utf8'
开启log日志,配置my.cnf
log-bin=mysql-bin.log(默认在数据目录/var/lib/mysql)
server-id=序列号(必须配置)
重启:systemctl restart mysqld.service
- centos7 yum mysql5.7 install
- CentOS7 使用YUM 安装MySQL5.7(yum install mysql5.7)
- CentOS7 yum 安装Mysql5.7
- CentOS7 YUM安装mysql5.7
- yum install mysql5.x
- CentOS7下通过yum安装MySQL5.7
- Centos7下yum安装MySQL5.7
- Centos7 使用yum源安装mysql5.7
- centos7 yum install nginx
- CentOS7 yum 安装 mysql5.6
- centos7.1 yum 安装 MySQL5.7 和 PHP5.6
- Centos7.2下使用YUM快速安装MySQL5.7
- CentOS7下YUM安装与配置MySQL5.7
- CentOS7下安装MySQL5.7安装与配置(YUM)
- CentOS7下安装MySQL5.7安装与配置(YUM)
- CentOS7下安装MySQL5.7安装与配置(YUM)
- CentOS7下安装MySQL5.7安装与配置(YUM)
- CentOS7下安装MySQL5.7安装与配置(YUM)
- Oracle(23)pl/sql编程 分页过程
- MQTT之centos6.5 下编译Mosquitto
- 第七届蓝桥杯JAVA语言B组_生日蜡烛
- 接口
- 更改RemixOS分辨率
- centos7 yum mysql5.7 install
- Tess4j+中文识别+使用介绍文档+参考网址+实现源码下载地址
- css3之未读消息小红点
- NN优化方法对比:梯度下降、随机梯度下降和批量梯度下降
- Unity3D游戏记录回放插件EZReplayManager(二)
- ICMP:Internet 报文控制协议
- Java中注解详解
- 类的说明
- basedao 反射