1、构建下载仓库
在/etc/yum.repos.d/下新建mysql-community.repo
如下所示:
# Enable to use MySQL 5.7
[mysql57-community]
name=MySQL 5.7 Community Server
baseurl=https://repo.mysql.com/yum/mysql-5.7-community/el/7/$basearch/
enabled=1
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
2、安装MySQL服务器
yum -y install mysql-server
3、启动MySQL服务
systemctl start mysqld.service
运行一下命令查看一下运行状态
systemctl status mysqld.service
4、初始化数据库密码
(1)查看初始密码:grep "password" /var/log/mysqld.log
(2)登录:mysql -uroot -p
(3)修改密码策略:
必须修改两个全局参数:
首先,修改validate_password_policy参数的值
mysql> set global validate_password_policy=0;
Query OK, 0 rows affected (0.00 sec)
然后,修改validate_password_length参数的值
mysql> set global validate_password_length=1;
修改密码:
ALTER USER 'root'@'localhost' IDENTIFIED BY '****************';
5、数据库授权
数据库没有授权,只支持localhost本地访问
mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
//
远程连接数据库的时候需要输入用户名和密码
用户名:root
密码:123456
指点ip:%代表所有Ip,此处也可以输入Ip来指定Ip
输入后使修改生效还需要下面的语句
mysql>FLUSH PRIVILEGES;
6、设置自动启动
systemctl enable mysqld
systemctl daemon-reload