官网安装教程:
https://dev.mysql.com/doc/refman/5.7/en/linux-installation-yum-repo.html
1、下载mysql yum库
最新版本请在此查看 :
http://dev.mysql.com/downloads/repo/yum/
wget
https://repo.mysql.com//mysql57-community-release-el7-11.noarch.rpm
2、安装mysql yum库
sudo yum localinstall mysql-community-release-el7-{version-number}.noarch.rpm
3、更新yum
sudo yum update
4、查看当前启动的mysql版本
sudo yum repolist all | grep mysql
5、安装Mysql数据库
sudo yum install mysql-community-server
6、启动Mysql服务
sudo service mysqld start
启动出错:
Can
't change data directory owner to mysql
由于安全限制需要将安装关闭
setenforce 0
7. 修改root密码
1. 查看root临时密码:
grep
'temporary password'
/var/
log
/mysqld.
log
2. 使用临时密码登录Mysql
mysql-uroot-p
3. 修改root密码,需要包含特殊符号
ALTER
USER
'root'
@
'localhost'
IDENTIFIED
BY
'MyNewPass4!'
;
如果忘记初始密码可以在mysql日志文件中查找 /var/log/mysqld.log
yum mysql升级方法
1、(可选)修改MySQL yum 库 启用需要更新的版本:
/etc/yum.repos.d/mysql-community.repo
2、yum update
MySQL 用户授权:
创建用户命令:CREATE USER 'username'@'%' IDENTIFIED BY 'password';
创建数据库命令: create database xxx character set = utf8mb4
1. 给用户授予数据库xxx的操作权限:
grant all privileges on xxx.* to 'username'@'localhost'; % 全部IP, localhost 本机
2. 取消用户数据库操作权限:
revoke all on xxx.* from 'username'@'localhost';
3. 查看用户数据库操作权限:
show grants for 'username'@'%';
4. 更改用户密码:
SET PASSWORD FOR 'username'@'host' = PASSWORD('newpassword');