# ops

**Repository Path**: hemleen/ops

## Basic Information

- **Project Name**: ops
- **Description**: 运维手册
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2024-08-13
- **Last Updated**: 2024-08-14

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

### Mysql用户操作
```sql
--查看版本
select version();
--创建数据库
create database have_meals DEFAULT CHARSET utf8;
--创建用户
CREATE USER 'dangan'@'%' IDENTIFIED with mysql_native_password BY '1qaz!QAZ';
--授权
grant all privileges on dms_jgda.* to 'dangan'@'%' with grant option;
GRANT CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE ON *.* TO 'dangan'@'%'
--刷新
flush privileges;
--查看用户
select user,host from mysql.user;
SELECT Host, User, plugin from mysql.user;
select host, user, authentication_string, plugin from mysql.user;
show GRANTS for dangan; 
show grants for 'have_meals'@'%';
--修改用户
alter user 'have_meals'@'%' IDENTIFIED with mysql_native_password BY '7gcsIWWCP5mvHHaw@123';
--删除用户
drop user have_meals;
```