首页 > 数据库技术 > 详细

centos7 安装mysql5.7,并优化

时间:2020-02-03 19:46:51      阅读:65      评论:0      收藏:0      [点我收藏+]

1.下载mysql

wget https://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm

2.安装mysql

安装mysql安装源

yum -y localinstall mysql57-community-release-el7-11.noarch.rpm
安装MySQL 
yum -y install mysql-community-server

启动mysql

systemctl start mysqld
systemctl enable mysqld

从/var/log/mysqld.log获取mysql初始密码

grep password /var/log/mysqld.log

初始化mysql

修改mysql密码,并开启远程访问

ALTER USER ‘root‘@‘localhost‘ IDENTIFIED BY ‘Test2020@‘;
GRANT ALL PRIVILEGES ON . TO ‘root‘@‘%‘ IDENTIFIED BY ‘Test2020@‘ WITH GRANT OPTION;

backup的脚本。每天晚上3点备份至一个挂载的NFS上面,备份到/data/mysql/backup目录下

垃圾太慢了!!!看下一个

设置yun源

vim mysql.repo
[mysql57-community]
name=MySQL 5.7 Community Server
baseurl=https://mirrors.tuna.tsinghua.edu.cn/mysql/yum/mysql57-community-el7/
enabled=1
gpgcheck=0
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql

安装mysql

yum -y install mysql-community-server

启动并开启远程连接

systemctl start mysqld
systemctl enable mysqld
awk ‘/temporary password/{print $NF}‘ /var/log/mysqld.log
mysql -uroot -p ktvXngyks6=Q
ALTER USER ‘root‘@‘localhost‘ IDENTIFIED BY ‘Test2020@‘;
GRANT ALL PRIVILEGES ON . TO ‘root‘@‘%‘ IDENTIFIED BY ‘Test2020@‘ WITH GRANT OPTION;
flush privileges;

centos7 安装mysql5.7,并优化

原文:https://www.cnblogs.com/os4top16/p/12256733.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!