〇、下载 安装包 链接:点击下载 提取码:yn9z
一、上传安装包到Linux
1、传路径:/usr/local/
2、解压缩
tar xvf mysql-8.0.17-linux-glibc2.12-x86_64.tar.xz
3、重命名
mv mysql-8.0.17-linux-glibc2.12-x86_64 mysql
二、安装配置
1、修改 vi /etc/my.cnf
[client]
port=3306
socket=/var/lib/mysql/mysql.sock
[mysqld]
port=3306
user=mysql
socket=/var/lib/mysql/mysql.sock
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
2、创建mysql组与用户
groupadd mysql
useradd -g mysql mysql
3、初始化mysql
/usr/local/mysql/bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data/
执行结果如下【root@localhost: 跟着的是初始密码。记下,后面用到 】:
2019-09-10T10:24:51.816431Z 0 [System] [MY-013169] [Server] /usr/local/mysql/bin/mysqld (mysqld 8.0.17) initializing of server in progress as process 11400
2019-09-10T10:24:56.404516Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: )sTNHf/sp7er
2019-09-10T10:24:58.587884Z 0 [System] [MY-013170] [Server] /usr/local/mysql/bin/mysqld (mysqld 8.0.17) initializing of server has completed
4、创建sock文件夹与命令链接
mkdir -p /var/lib/mysql ; chown -R mysql:mysql /var/lib/mysql
ln -s /usr/local/mysql/bin/mysql /usr/bin
5、启动服务
/usr/local/mysql/support-files/mysql.server start
6、修改初始密码
mysql -uroot -p
修改密码 ,我这里的新密码是123456
ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';
7、开启远程访问
use mysql;
update user set host='%' where user='root';
flush privileges;
exit;
8、关闭防火墙
systemctl stop firewalld.service #停止firewall
systemctl disable firewalld.service #禁止firewall开机启动
9、配置成服务并开机启动
cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql
chkconfig mysql on
chkconfig --add mysql
这样可以使用命令
service mysql start
service mysql stop
二、远程访问