Skip to main content

How to DROP MySQL users manually

Steven Sublett
  • Updated

Question

How can a MySQL user be dropped manually?

Answer

The easiest way to perform this is via the MySQL command line.

Drop a Single User
  1. Connect to your server using SSH as the root user.
  2. Drop the user from the mysql user database:

# mysql mysql -e "DROP user '$USER'@'$HOST';"

CPANEL_WARN: Be sure to replace $USER with the appropriate user and $HOST with the appropriate host. For the host, this will generally be "localhost". For example:
mysql mysql -e "DROP user 'cptech'@'localhost';"

Drop All Users for One Account
  1. Connect to your server using SSH as the root user.
  2. Remove the users from the mysql user table first:

# mysql mysql -e "delete from mysql.user where User like '$USER%';"

  1. Remove the users from the mysql db table:

# mysql mysql -e "delete from mysql.db where User like '$USER%';"

CPANEL_WARN: Be sure to replace $USER with the appropriate user and preserve the percent sign. For example:
mysql mysql -e "delete from mysql.user where User like 'cptech%';"

Additional Information

MySQL Documentation: DROP User

Related articles

Comments

0 comments

Article is closed for comments.

%