Linux安装mysql步骤

1.查看系统中是否安装有mysql

yum list installed | grep mysql

1. 如果有删除自带mysql及依赖

yum -y remove mysql -libs.x86_64

1. 安装wget命令

yum install wget -y

1. 给CentOS添加rpm源，并且选择较新的源

wget https://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm

1. 安装Mysql源文件

yum localinstall -y mysql57-community-release-el7-11.noarch.rpm

1. 查看Mysql源是否安装成功

yum repolist enabled | grep "mysql.*-community.*"

1. 安装Mysql服务

yum -y install mysql-community-server

报如下密钥问题

file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql

解决：rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022

1. 启动Mysql

systemctl start mysqld 

systemctl restart mysqld //重启    

1. 获取root默认密码root@localhost:后面的就是密码（由于Mysql安全策略升级，安装完成后系统自动设置了一个随机密码）8uQl_bjmg>mj   >%yfwRatj3io yWR,zZpOk5hj

grep 'temporary password' /var/log/mysqld.log

1. 登录mysql

mysql -uroot -p

1. 修改mysql登录密码

alter user 'root'@'localhost' identified by '123456';

1. 关闭Mysql密码校验规则，允许设置简单密码

set global validate_password_policy=0;
set global validate_password_length=1;
set password=password('密码');

1. 修改远程访问权限

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;

14.查看查看用户信息与显示登录用户

select * from mysql.user \G

select User,Host,authentication_string from mysql.user;

15.创建表

 create database if not exists ipay_db;

16.查看数据库 如下图已经安装成功

 

17.mysql退出 quit

18./var/log mysql日志