Code360 powered by Coding Ninjas X Naukri.com. Code360 powered by Coding Ninjas X Naukri.com
Last updated: May 23, 2022

User

User explains basic functions that the user performs or seeks on MySQL. These functions are explained under user. The functions such as Create, drop, and show. These three functions are used to create, drop and show the tables, and databases. Other such functions such as account manipulation which involved how to change the password and unlocking the account. It also includes how to provide certain privileges to the user which includes grants, revoke, and how to manage the roles. These features are explained in-depth with examples.
MySQL Create User
This article comprises MySQL Create User operation followed by the various privileges regarding the same.
MySQL Drop User
In this article, we will learn about the MySQL DROP USER command that is used to remove one or more user accounts and their privileges from the database server.
MySQL Show Users
In this article, we will learn how to show users in the MySQL database server. We will also discuss how to show current and currently logged users.
MySQL Account Manipulation
In this blog, we will discuss various ways of manipulating a user account in MySQL.
MySQL Grant Privilege
In this article, we’ll be learning about how to grant privileges in MySQL.
MySQL Revoke Privilege
This blog incorporates how to revoke privileges in MySQL in detail.
MySQL Manage Roles 1
This article will discuss the MySQL SHOW GRANTS command And all about Managing roles. Some of the FAQs will follow it.