Community Learn Tools Library Leisure
search
English
Home > Database > Mysql Tutorial > mysql用户权限基本操作_MySQL

mysql用户权限基本操作_MySQL

WBOY
Release： 2016-05-30 17:10:15
Original
941 people have browsed it

创建用户

create user 'username'@'host' IDENTIFIED BY 'PASSWORD'

 

给指定用户授权

 

grant all on DBName.* to 'username'@'host'

 

刷新权限

 

flush privileges;

 

查看用户权限

 

show grants for 'user'@'host'

 

换行查询信息，主要针对多行

 

select * from user \G

 

Related labels：
Basic operations Permissions user
source：php.cn
Previous article：InnoDB概览_MySQL Next article：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
The child window operates the parent window, but the output does not respond. The first two sentences are executable, but the last sentence cannot be implemented.
From 2024-04-19 15:37:47
0
1
1361
The page suddenly cannot pull css or bootstrap So I'm developing a page, I did part of it yesterday and it worked great, and today I cont...
From 2024-04-06 21:58:04
0
1
800
Sudoku checker not working? Can anyone help me identify the error? I tried everything on the online editor but still get the error. But when I do this on VSC...
From 2024-04-06 21:21:07
0
1
474
Calculate the sum of fields in another table using MySQL SQL query I have a schema like this: User table with attributes "user_id" and "userna...
From 2024-04-06 19:39:29
0
1
441
MySQL: "Select text from... as <variable here or subquery>" I have the following table with the following data: id text language 1 german text german ...
From 2024-04-06 19:25:54
0
2
529
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