下载地址
https://dev.mysql.com/downloads/mysql/
系统版本
mysql版本类型
下载之前 先安装 wget:
yum -y install wget
下载mysql8.0:执行如下命令:
wget https://cdn.mysql.com//Downloads/MySQL-8.0/mysql-8.0.18-el7-x86_64.tar.gz
mysql压缩包存放目录:/usr/local/mysql/mysql-8.0.18-el7-x86_64.tar.gz
解压mysql安装包:
tar -zxvf mysql-8.0.18-el7-x86_64.tar.gz
进入mysql-8.0.18-el7-x86_64目录。
编辑mysql配置文件:
vi /etc/my.cnf
修改内容为:
[mysqld]
socket=/usr/local/mysql/mysql-8.0.18-el7-x86_64/mysql.sock
port=3306
user=mysql
basedir=/usr/local/mysql/mysql-8.0.18-el7-x86_64
datadir=/usr/local/mysql/mysql-8.0.18-el7-x86_64/data
max_allowed_packet=128M
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
[client]
port=3306
socket=/usr/local/mysql/mysql-8.0.18-el7-x86_64/mysql.sock
添加mysql 组和用户
groupadd mysql和useradd -r -g mysql mysql
修改相关权限,进入usr/local/mysql/mysql-8.0.18-el7-x86_64目录
cd /usr/local/mysql/mysql-8.0.18-el7-x86_64
chown -R mysql:mysql ./ //修改当前目录为mysql用户
初始化mysql ,进入安装目录下的bin目录:/usr/local/mysql/mysql-8.0.18-el7-x86_64/bin/,执行如下命令:
./mysqld --initialize --user=mysql --basedir=/usr/local/mysql/mysql-8.0.18-el7-x86_64 --datadir=/usr/local/mysql/mysql-8.0.18-el7-x86_64/data
初始化mysql 并得到初始密码
进入/usr/local/mysql/mysql-8.0.18-el7-x86_64/support-files目录,执行./mysql.server start启动mysql
复制启动文件到系统启动路径下:
cp support-files/mysql. server /etc/rc.d/init.d/mysql
启动如果报错 就报log目录已经文件给最高权限即可
启动命令:service mysqld start
重新启动命令:systemctl restart mysqld.service
启动命令:systemctl start mysqld.service
停止启动命令:systemctl stop mysqld.service
终极启动命令:/etc/init.d/mysql start