linux安装mysql到指定目录,Linux安装MySQL 8

下载MySQL

选择好对应的版本；

wget https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.15-1.el7.x86_64.rpm-bundle.tar

解压至指定目录

tar -xvf mysql-8.0.15-1.el7.x86_64.rpm-bundle.tar -C mysql/

建议移动到指定目录，并修改文件夹名。

安装响应组件

依次安装common、libs、client、server四个组件；

rpm -ivh mysql-community-common-8.0.15-1.el7.x86_64.rpm --nodeps --force

rpm -ivh mysql-community-libs-8.0.15-1.el7.x86_64.rpm --nodeps --force

rpm -ivh mysql-community-client-8.0.15-1.el7.x86_64.rpm --nodeps --force

rpm -ivh mysql-community-server-8.0.15-1.el7.x86_64.rpm --nodeps --force

初始化数据库

mysqld --initialize;

chown mysql:mysql /var/lib/mysql -R;

systemctl start mysqld.service;

systemctl enable mysqld;

登录数据库，修改密码

查看默认初始密码；

cat /var/log/mysqld.log | grep password

根据该密码登录MySQL；

必须修改初始密码；

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';

添加用户，提供远程访问

create user 'caojiantao'@'%' identified with mysql_native_password by '123456';

grant all privileges on *.* to 'caojiantao'@'%' with grant option;

flush privileges;