mysql部署

mysql部署

下载

版本号改为自己需要的

wget https://cdn.mysql.com/archives/mysql-8.0/mysql-8.0.18-el7-x86_64.tar.gz

解压（我的路径是usr/local/mysql/）

tar zxvf mysql-8.0.30-el7-x86_64.tar.gz

改名（名字太长，可省略）

mv mysql-8.0.30-el7-x86_64 /usr/local/mysql/mysql-8.0.30

修改配置文件，my.cnf

[mysqld]
basedir=/usr/local/mysql/mysql-8.0.30
datadir=/usr/local/mysql/mysql-8.0.30/data
port=3306
socket=/tmp/mysql.sock
character_set_server=utf8
lower_case_table_names=1
log-error=/usr/local/mysql/mysql-8.0.30/data/mysql.log
pid-file=/usr/local/mysql/mysql-8.0.30/data/mysql.pid
[mysql]
default-character-set = utf8

在mysql-8.0.30下新建文件夹 data

mkdir data

初始化

./bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql/mysql-8.0.30/ --datadir=/usr/local/mysql/mysql-8.0.30/data/

设置环境变量

export MYSQL_HOME=/usr/local/mysql/mysql-8.0.30
export PATH=$PATH:$MYSQL_HOME/bin

保存配置

source /etc/profile

启动mysql

service mysql start