启动项目之--新建并配置数据库-创建MySQL用户 赋予某指定库表的权限

1. 下载并启动数据库

# 下载 MySQL(mairadb) 
yum install -y mariadb mariadb-server
# 启动数据库
systemctl start mariadb 
# 开机自动启动
systemctl enable mariadb

2. 新建数据库

CREATE DATABASE `repository` CHARACTER SET 'utf8' COLLATE 'utf8_general_ci';

3. 新建用户分配权限

# 新建并分配数据库权限
grant all on repository.* to repository@"%" identified by "repository";
# 刷新系统权限表
flush privileges;

4. 其他操作

# 修改用户密码
mysqladmin -urepository -prepository password p123456

use mysql; 
update user set password=password('123') where user='repository' and host='localhost';
flush privileges; 

# 新建只读用户-可读全部数据库
grant select on *.* to read_only@"%" identified by "password";