What is the command to delete a user in mysql

The command to delete a user in MySQL is DROP USER 'username', where 'username' is the username to be deleted. User permissions should be revoked before use. The deletion operation is permanent and cannot be undone.

Command to delete a user in MySQL

To delete a user in the MySQL database, you can use the following command:

<code class="sql">DROP USER 'username'</code>

Among them, 'username' is the username to be deleted.

Command structure

• DROP USER: is used to delete users.
• 'username': The username to be deleted. Use single quotes to surround the username.

Usage Example

To delete a user named 'admin', you can use the following command:

<code class="sql">DROP USER 'admin';</code>

IMPORTANT

• Before deleting a user, make sure that you have revoked its permissions on any database or object.
• Deleting a user will also delete all its permissions and all database objects associated with the user (for example, tables, views, and stored procedures).
• Deleting a user is a permanent operation and cannot be undone.

The above is the detailed content of What is the command to delete a user in mysql. For more information, please follow other related articles on the PHP Chinese website!