安装mysql
1、下载mysql官方yum源
wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm
2、安装源
yum -y install mysql57-community-release-el7-10.noarch.rpm
3、安装mysql
yum -y install mysql-community-server
4、获取初始化密码
grep "password" /var/log/mysqld.log
配置mysql
1、运行mysql服务
systemctl start mysqld.service
2、登录mysql(xxxxxx代表初始密码)
mysql -uroot -p'xxxxxx'
3、设置密码测率为低(mysql命令行下,此项设置看个人需要)
set global validate_password_policy=LOW;
4、赋予数据库root用户权限(mysql命令行下)
GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY 'password' WITH GRANT OPTION;
5、设置数据库root用户任意渠道访问(mysql命令行下)
UPDATE user set host = '%' WHERE mysql.user = 'root';
6、修改配置文件,设置utf8字符集(此项看个人需要,vim /etc/my.cnf,有则修改无则增加,确保如下五段文字存在)
[client]
default-character-set=utf8
[mysqld]
character-set-server=utf8
collation-server=utf8_general_ci
7、重启mysql服务
service mysqld restart
配置防火墙
1、开放mysql监听端口
firewall-cmd --zone=public --add-port=3306/tcp --permanent
firewall-cmd --reload
引用
https://blog.csdn.net/qq_36582604/article/details/80526287