简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)
Home > Database > Mysql Tutorial > body text

Mysql高级之权限检查原理_MySQL

WBOY
Release： 2016-06-01 13:04:24
Original
1145 people have browsed it

用户进行数据库操作分为两步：

1 是否有权限连接，根据host，name，password；

2 是否有权限进行CURD；

图示解说：

关于用户权限在哪里进行存放？

这样看：

\

mysql数据库里面有张user表：

\

\

就像普通CURD一样，这就可以登录控制啦！

\

注意在User表里面权限是全局性质的，

\

\

如果想针对某个表进行控制怎么办？记得db表吧，就是在这，

就不细说了：

\

Related labels：
principle Permissions
source：php.cn
Previous article：RedHat5安装Mysql5.1.7_MySQL Next article：CAPI--linux上c语言读取数据库内容（mysql）_MySQL
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
How to update a React component's dependencies in useEffect without creating an infinite loop I have a React component where I need to wait for a stored value (member) to update and th...
From 2024-04-05 14:31:46
0
1
1383
Use locally installed libraries in website pages Is it possible to use libraries (.dll, .ocx) written for Windows operating systems and reg...
From 2024-04-05 00:15:49
0
1
3563
Unable to implement this htaccess redirect I have a maindomain.com which contains a website and some pages here should be temporarily...
From 2024-04-04 23:43:51
0
1
1376
Lower opacity of scroll background image, limit minimum opacity I'm trying to get the background image to reduce the opacity on scroll and once away from ...
From 2024-04-04 23:50:53
0
1
1329
I want to send two different emails to two different addresses using php in the same function So when a product is ordered from a merchant registered on my website, I want my code to u...
From 2024-04-04 22:17:09
0
1
1481
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn：Public welfare online PHP training，Help PHP learners grow quickly！