Linux Centos7 下安装Mysql
Mysql有两种安装方式：源码包安装和二进制包安装本文描述的是二进制安装包，下载目录：https://www.mysql.com/downloads/
步骤一：
https://s1.运维网.com/images/blog/201903/28/3f96c8d6dc3d258fd7b684afa29ab92f.png
步骤二：
https://s1.运维网.com/images/blog/201903/28/74d9d56e15f3ff5e80f07d30f99b4559.png
步骤三：
https://s1.运维网.com/images/blog/201903/28/af81aa2f0bcddddf03d78b5e03862ce1.png
因本人的虚拟机是仅主机模式，所以需要先将在本地安装的Mysql安装包上传到虚拟机上
命令：rz
https://s1.运维网.com/images/blog/201903/28/1b33b7010bec539b38615edc735136ef.png
解压到/usr/local/目录下
# tar xf mysql-8.0.15-linux-glibc2.12-x86_64.tar.xz -C /usr/local/
目录/usr/lcoal/下创建链接
# ln -sn mysql-8.0.15-linux-glibc2.12-x86_64 mysql
https://s1.运维网.com/images/blog/201903/28/a6bc10aa9aeffe3b9efc412e0dd8b241.png
创建mysql用户和所属组
# groupadd mysql和useradd -r -g mysql mysql
https://s1.运维网.com/images/blog/201903/28/ce49a0be583511cf9b09a8695daf1c97.png
设置/usr/local/mysql目录下所有文件为root主，mysql组
# chown -R root.mysql ./*
https://s1.运维网.com/images/blog/201903/28/308bfa0a65f60c4f2530f6e70c41ca7d.png
创建目录存放mysql数据
# mkdir -pv /data/mysql
修改/data/mysql/目录的属主属组为mysql
# chown -R mysql.mysql /data/mysql/
https://s1.运维网.com/images/blog/201903/28/e448adcb3a26ab51cb08dcdc1902ebb5.png
编辑环境变量
# vim /etc/profile.d/mysql.sh
export PATH=/usr/local/mysql/bin:$PATH
重新加载下文件
# ./etc/profile.d/mysql.sh
初始化mysql
# ./bin/mysqld --initialize --user=mysql --datadir=/data/mysql --basedir=/usr/local/mysql
**记下生成的密码 ，若不生成密码，设置空密码：--initialize后加-insecure
创建etc目录，将/etc/my.cnf复制到/usr/local/mysql/etc目录下
# mkdir etc
# cp /etc/my.cnf etc/
编辑/usr/local/mysql/etc.cnf
# cd etc/
# vim my.cnf
https://s1.运维网.com/images/blog/201903/28/38e8c152b132f343f57d60f701dccd75.png
根据my.cnf文件路径配置，创建mysql目录下对应的目录和文件
# mkdir my.cnf.d
https://s1.运维网.com/images/blog/201903/28/7024b4c5e1cd9ea5384ccfc0841f5616.png
创建logs目录
# mkdir logs
设置目录所属主，所属组
# chown -R root.mysql logs
创建错误日志文件
# touch error.log
设置错误日志所属主和所属组
# chown -R mysql.mysql error.log
https://s1.运维网.com/images/blog/201903/28/7b56b8ed84a24faa0304d18ad06f85e5.png
将目录/usr/local/mysql/support-files/mysql.server复制到目录/etc/init.d/mysqld
# cp mysql.server /etc/init.d/mysqld
启动脚本
# service mysqld start
Starting MySQL....... SUCCESS!
登录（/usr/local或/data目录下）
# mysql -uroot -p
修改密码为123456
set password='123456'
https://s1.运维网.com/images/blog/201903/28/96b9bbaea9c177f47553b1ed9ba4e19d.png
OK！(^o^)/~已安装成功！下一章Mysql基本语句学习...
页:
[1]