centos7 安全 mysql_CentOS7下安装mysql5.7

下载和安装yum源

在服务器上运行下载命令：wget [刚刚复制的链接]

继续输入安装命令：rpm -ivh mysql80-community-release-el7-3.noarch.rpm

执行完成后会在/etc/yum.repos.d/目录下生成两个repo文件mysql-community.repo mysql-community-source.repo

通过yum安装mysql

运行命令：yum install -y mysql-community-server

启动mysql服务

运行命令：systemctl start mysqld (开启数据库)

systemctl enable mysqld (开机自启数据库)

查看mysql的初始密码

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

修改初始密码

先通过上面的密码来登录mysql ：mysql -u root -p

输入修改密码的命令：ALTER USER 'root'@'localhost' IDENTIFIED BY '123456'；

设置可远程访问

在mysql中运行：GRANT ALL PRIVILEGES ON . TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;

相关命令

1、设置安全选项：

mysql_secure_installation

2、关闭MySQL

systemctl stop mysqld

3、重启MySQL

systemctl restart mysqld

4、查看MySQL运行状态

systemctl status mysqld

5、设置开机启动

systemctl enable mysqld

6、关闭开机启动

systemctl disable mysqld

7、配置默认编码为utf8：

vi /etc/my.cnf #添加 [mysqld] character_set_server=utf8 init_connect='SET NAMES utf8'