mysql的安装有哪些方式:
1、yum源安装 其实本质上还是rpm ,原因是先帮你下载rpm然后再帮你安装
2、rpm安装包安装
3、可以使用今天的方式安装(也属于yum源安装的一种)
这个软件mysql80-community-release-el7-4.noarch.rpm,它不是一个安装包,而已是一个引导包
cd /opt/modules
yum install -y wget
wget https://dev.mysql.com/get/mysql80-community-release-el7-4.noarch.rpm
yum install -y mysql80-community-release-el7-4.noarch.rpm
yum localinstall -y mysql80-community-release-el7-4.noarch.rpm
##1.2 安装mysql
yum install -y mysql-community-server
如果报错:
源 “MySQL 8.0 Community Server” 的 GPG 密钥已安装,但是不适用于此软件包。请检查源的公钥 URL 是否配置正确。
失败的软件包是:mysql-community-client-8.0.28-1.el7.x86_64
GPG 密钥配置为:file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
执行如下:
rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022
##1.3 启动mysql服务
[root@hadoop yum.repos.d]# systemctl start mysqld
##1.4 查看初始root密码
[root@hadoop yum.repos.d]# grep ‘temporary password’ /var/log/mysqld.log
##1.5 登陆mysql
[root@hadoop yum.repos.d]# mysql -uroot -p
修改密码:
alter user root@localhost identified by ‘Y1h2e3d4u5!’;
set global validate_password.policy=LOW;
set global validate_password.length=4;
set global validate_password.mixed_case_count=0;
set global validate_password.number_count=0;
set global validate_password.special_char_count=0;
2. 修改密码
alter user root@localhost identified by ‘123456’;
##1.6 远程授权
create user ‘root’@‘%’ identified by ‘123456’;
grant all privileges on . to ‘root’@‘%’ with grant option;
flush privileges;
ALTER USER ‘root’@‘%’ IDENTIFIED WITH mysql_native_password BY ‘123456’;
##1.8 重启mysql的服务
service mysqld restart