1.下载mysql源安装包
2.安装mysql源
yum localinstall mysql57-community-release-el7-8.noarch.rpm
3.检查mysql源是否安装成功
yum repolist enabled | grep "mysql.*-community.*"
4.安装mysql
yum install -y mysql-server
5.启动mysql服务
systemctl start mysqld
//systemctl stop mysqld 停止
6.设置开机启动
systemctl enable mysqld
systemctl daemon-reload
7.密码修改
mysql安装完成之后,在/var/log/mysqld.log文件中给root生成了一个默认密码。通过下面的方式找到root默认密码,然后登录mysql进行修改:
grep 'temporary password' /var/log/mysqld.log
mysql -u root -p
#修改密码
set password for 'root'@'localhost'=password('Yhw123456,');
(密码策略问题)
Error:Your password does not satisfy the current policy requirements
查看策略
SHOW VARIABLES LIKE 'validate_password%';
修改策略为低等级
set global validate_password_policy=LOW;
8.设置远程登录
mysql -u root -p
use mysql
update user set host = '%' where user = 'root';
9.配置默认编码
vim /etc/my.cnf
增加
character_set_server=utf8
init_connect='SET NAMES utf8'
9.常用目录:
默认配置文件路径:
配置文件:/etc/my.cnf
日志文件:/var/log/mysqld.log
服务启动脚本:/usr/lib/systemd/system/mysqld.service
socket文件:/var/run/mysqld/mysqld.pi
bin_log文件:/var/lib/mysql/master_bin
10.常用命令
show variables like '%binlog%'; ##查看binlog配置
11. error: Host '192.168.31.132' is not allowed to connect to this MySQL server
https://blog.csdn.net/weixin_41622043/article/details/94150568
# 登陆mysql
mysql -uroot -p root
# 选择数据库
use mysql;
# 所有的地址都可以使用root用户来登陆
update user set host = '%' where user ='root';
#所有的地址都可以使用root用户,密码为12345678远程访问所有的数据库
grant all privileges on *.* to 'root'@'%' IDENTIFIED BY '12345678' with grant option;
所有的地址都可以使用root用户,远程访问所有的数据库
grant all privileges on *.* to 'root'@'%' with grant option;
# 刷新数据库
flush privileges;
# 退出数据库
exit;
# 重启数据
sudo service mysql restart;