目录
前言
centos安装mysql8.0详细步骤,如需卸载,请看https://blog.csdn.net/qq_42951096/article/details/124314019
一、安装步骤
1. 安装依赖
yum install libaio wget -y
2.检查MYSQL是否已安装(如果安装了则需要卸载)
yum list installed | grep mysql
卸载方式:(格式: yum -y remove [包名])
yum -y remove mysql-libs.x86_64
3. 下载MySQL官网的仓库文件
cd /tmp
wget http://repo.mysql.com/mysql80-community-release-el7-1.noarch.rpm
yum localinstall mysql80-community-release-el7-1.noarch.rpm
4. 验证仓库是否添加成功
yum repolist enabled | grep "mysql.*-community.*"
5. 开始安装mysql
yum install mysql-community-server -y
如果MySQL 安装完成,它包含了 mysql-community-server、mysql-community-client 、mysql-community-common、mysql-community-libs 四个包
6. 查看mysql安装位置
whereis mysql
7. 启动、停止服务
systemctl start mysqld
systemctl enable mysqld
systemctl status mysqld
8. 因为安装时间默认了初始密码,先查看初始密码
cat /var/log/mysqld.log | grep password
9. 登入mysql修改初始密码
mysql -uroot -p
输入密码登入之后进行密码修改
ALTER USER 'root'@'localhost' IDENTIFIED BY '你的密码';
10. 如果需要设置远程连接
a.进入mysql库
use mysql
b.创建用户
create user '用户名'@'%' identified by '密码';
c.给用户授予权限
grant all on *.* to '用户'@'%';
d.刷新用户权限
flush privileges;