工程师计划 数据库 Centos7.x下MySQL5.7安装

Centos7.x下MySQL5.7安装

1.在mysql官网查看压缩文件地址

https://dev.mysql.com/downloads/mysql/5.7.html#downloads

2.安装新版mysql前,需将系统自带的mariadb-lib卸载

rpm -qa|grep mariadb
mariadb-libs-5.5.60-1.el7_5.x86_64 输出包名 
rpm -e --nodeps mariadb-libs-5.5.60-1.el7_5.x86_64  卸载mariadb
systemctl stop firewalld 临时关闭防火墙
systemctl disable firewalld 关闭防火墙永久性生效

3.下载安装包到 /usr/local/

yum install wget
cd /usr/local/
wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.33-linux-glibc2.12-x86_64.tar.gz

4.安装mysql需要的依赖库

yum install libaio
yum -y install numactl.x86_64

5.安装MySQL

cd /usr/local/
tar -xf mysql-5.7.33-linux-glibc2.12-x86_64.tar.gz
mv mysql-5.7.33-linux-glibc2.12-x86_64 mysql
创建mysql用户和用户组

useradd mysql
id mysql

修改mysql文件夹所有文件和目录的所属人和所属组

cd mysql
chown -R mysql .
chgrp -R mysql .

创建数据存放的目录

mkdir data

进入到mysql的bin目录下,执行安装

cd bin/
./mysql_install_db --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data

查看mysql的初始密码

cat /root/.mysql_secret 

启动mysql

cd ../support-files/
./mysql.server start

设置mysql为自动启动

cd  /usr/local/mysql
cp support-files/mysql.server /etc/init.d/mysql
chkconfig --add mysql
chkconfig --list mysql

创建全局链接

ln -s /usr/local/mysql/bin/mysql /usr/bin/mysql

修改密码

mysql -uroot -p
SET PASSWORD = PASSWORD('root')
;
设置mysql数据库允许远程登录

GRANT ALL PRIVILEGES ON *.* TO root@'%' identified by 'root';
flush privileges;

查看MySQL安装路径

show variables like "%dir%";
show variables like "%port%";
本文来自网络,不代表本网站立场,转载请注明出处。http://loadingok.com/1584.html
© 2021 京ICP备2021027871号-1
联系我们

联系我们

18513870113

在线咨询: QQ交谈

邮箱: 1140136143@qq.com

工作时间:周一至周五,9:00-17:30,节假日休息

关注微信
微信扫一扫关注我们

微信扫一扫关注我们

返回顶部