1.从官网下载安装包
2.解压安装包
tar -zxvf mysql-8.0.23-1.el7.x86_64.rpm-bundle.tar
3.安装mysql
安装mysql 前先卸载mariadb或者以前的mysql
rpm -ivh mysql-community-common-8.0.23-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-plugins-8.0.23-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-8.0.23-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-8.0.23-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-8.0.23-1.el7.x86_64.rpm
4.启动mysql 与修改密码
启动
systemctl start mysqld
状态
systemctl status mysqld
停止
systemctl stop mysqld
查看初始随机密码
cat /var/log/mysqld.log | grep password
若果密码错误或者忘记了,先停止mysql 服务器
systemctl stop mysqld
编辑mysql 配置文件
vim /etc/my.cnf
在配置文件添加:
skip-grant-tables
在启动Mysql服务器,
mysql -uroot -p
按两次回车,进入mysql登录界面。
选择数据库
use mysql
重置密码设置密码为空
update user set authentication_string='' where user='root'
exit;退出登录,删除第一步中/etc/my.cnf文件最后的 skip-grant-tables,再次重启mysql服务
root用户空密码直接登陆
mysql -u root -p
passwrod:直接回车;
修改密码
ALTER user 'root'@'localhost' IDENTIFIED BY '你的密码';
flush privileges;
开放远程登录权限
use mysql;
select host,user from user;
update user set host='%' where user ='root';