https://blog.csdn.net/qq_35494808/article/details/89844590?utm_medium=distribute.pc_relevant.none-task-blog-BlogCommendFromMachineLearnPai2-1.channel_param&depth_1-utm_source=distribute.pc_relevant.none-task-blog-BlogCommendFromMachineLearnPai2-1.channel_param
为对方创建特定用户
| 操作指令 |
代码 |
| 创建登录账户 |
CREATE USER ‘用户名’ @‘IP/localhost’ IDENTIFIED BY ‘密码’; |
| 授权 |
GRANT 权限 ON 数据库名.表 TO ‘用户名’ @‘IP/localhost’; |
| 查看所有账户 |
SELECT USER,HOST FROM mysql.USER |
| 查看账户权限 |
SHOW GRANTS FOR ‘用户名’ @‘IP/localhost’ |
1
| CREATE USER 'c3' @'%' IDENTIFIED BY 'xxx202009';
|
创建好视图回来做
1
| GRANT SELECT ON ts_prod.v_expense_record TO 'c3' @'%';
|
mysql 视图相关操作
| 操作指令 |
代码 |
| 创建视图 |
CREATE VIEW 视图名(列1，列2…) AS SELECT (列1，列2…) FROM …; |
| 使用视图 |
和普通表一样操作 |
| 修改视图 |
CREATE OR REPLACE VIEW 视图名 AS SELECT […] FROM […]; |
| 删除视图 |
DROP VIEW 视图名 |
| 查看数据库已有视图 |
SHOW TABLES [like…];（可以使用模糊查找） |
| 查看视图详情 |
DESC 视图名或者SHOW FIELDS FROM 视图名 |
| 视图条件限制 |
[WITH CHECK OPTION] |
1
| create VIEW v_expense_record(user_code, c3_lsh, machine_code, expenses_date, base_money, self_money) as SELECT user_code, c3_lsh, machine_code, expenses_date, base_money, self_money from t_expenses_records WHERE expenses_date >= (NOW() - interval 24 hour)
|