#Mysql delete user command code#
#Mysql delete user command password#

Second, show all the users: select user, host from er Code language: SQL (Structured Query Language) ( sql )Ħ rows in set ( 0.00 sec) Code language: SQL (Structured Query Language) ( sql ) 3) Using the DROP USER statement to remove a connected userįirst, create a new database called people: create database people Code language: SQL (Structured Query Language) ( sql ) 2) Using the DROP USER statement to remove multiple user accountsįirst, remove two user accounts remote using the following statement: drop user remote Code language: SQL (Structured Query Language) ( sql ) The user account has been removed successfully. Output: + -+-+Ĩ rows in set ( 0.00 sec) Code language: SQL (Structured Query Language) ( sql ) Here is the current user list: + -+-+ĩ rows in set ( 0.00 sec) Code language: SQL (Structured Query Language) ( sql )įourth, drop the user by using the DROP USER statement: drop user Code language: SQL (Structured Query Language) ( sql )įifth, show all users again: select user, er Code language: SQL (Structured Query Language) ( sql ) Third, show users from the MySQL Server: select user, Second, create four account users accounts remote, and create user identified by 'Secure1Pass!' Code language: SQL (Structured Query Language) ( sql )

#Mysql delete user command password#

Type the password for the root user and press Enter: Enter password: ******** Code language: SQL (Structured Query Language) ( sql ) 1) Using MySQL DROP USER statement to drop a user exampleįirst, connect to the MySQL Server using the root account: mysql -u root -p Code language: SQL (Structured Query Language) ( sql ) Let’s take some examples of dropping users. Code language: SQL (Structured Query Language) ( sql )īesides removing the user account, the DROP USER statement also removes all privileges of the user from all grant tables. In MySQL 5.7.8+, you can use the IF EXISTS clause to conditionally drop a user only if it exists: DROP USER account_name. If you remove a user account that doesn’t exist, MySQL will issue an error.

Code language: SQL (Structured Query Language) ( sql ) If you want to remove multiple user accounts at once, you specify a list of comma-separated user accounts in the DROP USER clause: DROP USER account_name. Query OK, 0 rows affected, 1 warning (0.In this syntax, you specify the name of the user account that you want to remove after the DROP USER keywords. Mysql> DROP USER 1396 (HY000): Operation DROP USER failed for you use the IF EXISTS clause along with the DROP USER statement as shown below, the specified user will be dropped and if a user with the given name doesn’t exist, the query will be ignored.

If you try to drop a MySQL user that doesn’t exist error will be generated as shown below − Mysql> CREATE ROLE 'MyAdmin', 'MyDeveloper' įollowing query drops the above created roles at once − You can also delete multiple users at once using the DROP USER statement. Once a table is dropped, if you verify the list of the users as shown below you can see its name is missing − Mysql> DROP USER OK, 0 rows affected (0.13 sec) Mysql> DROP USER OK, 0 rows affected (0.43 sec) Mysql> DROP USER OK, 0 rows affected (0.15 sec) Let us delete three of the above created user accounts using the DROP USER statement as shown below − If you verify the list of users, you can observe the created ones in the list as follows − Mysql> CREATE USER IDENTIFIED BY 'password4' Mysql> CREATE USER IDENTIFIED BY 'password3' Mysql> CREATE USER IDENTIFIED BY 'password2' Mysql> CREATE USER IDENTIFIED BY 'password1' Suppose we have created multiple MySQL user accounts as shown below − Where, user_name is the name of the MySQL user you need to delete. Syntaxįollowing is the syntax of the DROP USER statement − To execute this statement, you need to have CREATE USER privilege. Once you delete an account all privileges of it were deleted.

You can drop/delete one or more existing users using the DROP USER Statement.