centos7安装mysql

1.mysql安装准备：

CentOS7的yum源中默认是没有mysql的。为了解决这个问题，我们要先下载mysql的repo源。

(1).下载 mysql的repo

wget https://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm

(2)安装mysql源安装包

rpm -ivh mysql57-community-release-el7-11.noarch.rpm

安装这个包后，会获得两个mysql的yum repo源：/etc/yum.repos.d/mysql-community.repo，/etc/yum.repos.d/mysql-community-source.repo。

2.安装Mysql

yum -y install mysql-community-server

如果有报错：

yum install mysql-community-server --nogpgcheck

上面这个

3.启动Mysql服务

systemctl start mysqld

service mysqld stop

service mysqld start

# vi /etc/my.cnf 

在[mysqld]的段中加上一句：skip-grant-tables 

4、更改密码

update mysql.user set authentication_string=password('password') where user='root';

flush privileges;

后续更改grant报错，还是要这样修改密码

报错提示：You must reset your password using ALTER USER statement before executing this statement.

 登录mysql

step 1: SET PASSWORD = PASSWORD('password');

step 2: ALTER USER 'root'@'localhost' PASSWORD EXPIRE NEVER;

step 3: flush privileges;

授权远程用户

GRANT ALL PRIVILEGES ON *.* TO 'username'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;

----------------------------------------------------------------------------------------------

默认安装目录

查看  vi /etc/my.cnf 

场景一：单表访问权限功能

GRANT ALL PRIVILEGES ON tamo.* TO tamoroot@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;