MySQL-SQL基础-DCL
2024-10-10 08:28:26
mysql> grant select,insert on sakila.* to 'zl'@'localhost' identified by '123';
Query OK, 0 rows affected, 1 warning (0.00 sec) mysql> exit
Bye
[root@localhost ~]# mysql -uzl -p123
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 5
Server version: 5.7.24 MySQL Community Server (GPL) Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
+--------------------+
1 row in set (0.00 sec)
最新文章
- VR定制 AR定制 就找北京动软VR开发团队(VR案例 AR案例)
- Install MySQL on Mac by Homebrew
- Fortran学习心得
- 19数据表的创建-普通表&;临时表-天轰穿大话数据库视频教程
- HDU 4856
- Python开发【第一篇】Python基础之反射
- 《高级Perl编程》 读书笔记
- 【HDU4391】【块状链表】Paint The Wall
- 0_Linux_虚拟机安装
- hive大数据倾斜总结
- 限制转交订单-采购直接批准PO
- POJ 2195 Going Home (费用流)
- 库函数strstr的实现
- Show tree of processes in linux
- Thinkphp 全选、反选 批量删除
- 【java】JDK、JRE、JVM的关系
- ARM JTAG 调试原理
- Eclipse QuickSear的插件的说明
- Django配合MySQL学习Django模型外键的建立和使用
- NetCore偶尔有用篇:NetCore项目WebApi返回Json属性大小写
热门文章
- [考试总结]noip模拟9
- 犀牛Rhino 7.0中文版安装破解教程
- Unsupported major.minor version 52.0解决办法【转】
- 【Maven实战技巧】「插件使用专题」Maven-Assembly插件实现自定义打包
- 论文笔记:(CVPR2019)PointWeb: Enhancing Local Neighborhood Features for Point Cloud Processing
- 剑指 Offer 40. 最小的k个数
- Vue 脚手架学习
- postman之变量
- 【LeetCode】738. 单调递增的数字
- VNC远程重装CentOS7