下载

wget -i -c http://dev.mysql.com/get/mysql-community-common-5.7.33-1.el7.x86_64.rpm
wget -i -c http://dev.mysql.com/get/mysql-community-libs-5.7.33-1.el7.x86_64.rpm
wget -i -c http://dev.mysql.com/get/mysql-community-client-5.7.33-1.el7.x86_64.rpm
wget -i -c http://dev.mysql.com/get/mysql-community-server-5.7.33-1.el7.x86_64.rpm

安装

yum -y install mysql-community-common-5.7.33-1.el7.x86_64.rpm
yum -y install mysql-community-libs-5.7.33-1.el7.x86_64.rpm
yum -y install mysql-community-client-5.7.33-1.el7.x86_64.rpm
yum -y install mysql-community-server-5.7.33-1.el7.x86_64.rpm

启动服务

    -- 启动服务
    [root@localhost ~]# systemctl start mysqld.service
    -- 检查服务状态
    [root@localhost ~]# systemctl status mysqld.service

服务配置

查看mysqld日志并用初始化密码登录——root@localhost:系统会自动默认匹配初始化密码

[root@localhost ~]# grep "password" /var/log/mysqld.log
-- 输入查到的密码
[root@localhost ~]# mysql -u root -p
-- 设置低密码等级
mysql-> set global validate_password_policy=LOW
mysql-> set global validate_password_length=6;
-- 修改密码
mysql-> ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';

设置远程登录

-- 1.切换mysql数据库
mysql> use mysql
-- 2.执行查询,查看数据库当前有访问权限的信息
mysql> SELECT User, Host FROM user;
-- 3.设置访问权限
mysql> GRANT ALL PRIVILEGES ON . TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
-- 4.刷新访问权限表(不要忘了)
mysql> FLUSH PRIVILEGES;
Logo

瓜分20万奖金 获得内推名额 丰厚实物奖励 易参与易上手

更多推荐