yum安装mysql 5.7
wget -i -c https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm
yum -y install mysql80-community-release-el7-3.noarch.rpm
yum-config-manager --disable mysql80-community
yum-config-manager --enable mysql57-community
yum install -y mysql-server
yum install -y mysql-devel
# [mysqld]
# datadir=/var/lib/mysql
# socket=/var/lib/mysql/mysql.sock
character-set-server=utf8
collation-server=utf8_general_ci
# 启动
systemctl start mysqld
# 查看状态
systemctl status mysqld
# 开机自启动
systemctl enable mysqld
# 查看监听端口,默认 3306
ss -natl |grep 3306
cat /var/log/mysqld.log | grep password
# 关闭安全验证策略
SET GLOBAL validate_password_policy=0;
# 密码最小长度
SET GLOBAL validate_password_length=4;
ALTER USER 'root'@'localhost' IDENTIFIED BY '666666';
# 放开3306端口
firewall-cmd --zone=public --add-port=3306/tcp --permanent
firewall-cmd --reload
# 远程登录还需要授权远程登录,mysql默认不允许远程登录
grant all PRIVILEGES on *.* to 'root'@'%' identified by '666666' WITH GRANT OPTION;
# 刷新,使修改生效
flush privileges;
# 重启数据库
systemctl restart mysql
yum安装mysql 8.0
卸载mysql的命令
yum remove mysql
删除mysql的配置文件
find / -name mysql
rm -rf XXX/XXX
rpm -qa | grep mysql
rpm -e --nodeps xxx
安装源
wget -i -c https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm
yum -y install mysql80-community-release-el7-3.noarch.rpm
# 查看mysql yum仓库中mysql版本
yum repolist all | grep mysql
安装并开启服务
yum install mysql-community-server
systemctl start mysqld.service
systemctl enable mysqld.service
初始密码修改
cat /var/log/mysqld.log | grep password
mysql -u root -p
# 验证策略取消,密码最小长度(4)
set global validate_password.policy=0;
set global validate_password.length=4;
# 修改密码
ALTER USER 'root'@'localhost' IDENTIFIED BY 'root';
远程设置
#远程设置
use mysql;
update user set host='%' where user='root';
#授权用户名的权限,赋予任何主机访问数据的权限
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'WITH GRANT OPTION;
FLUSH PRIVILEGES;
开放3306端口
# 查看已经开放的端口
firewall-cmd --list-ports
# 开启端口
firewall-cmd --zone=public --add-port=3306/tcp --permanent
# 重启firewall
firewall-cmd --reload