mysql user with the name already exists. how to delete

Please Rate us 
Solving an issue of

Extracting tarball................... Done
Extracting Domain....Done
Generating Account....

Account Creation Status: failed (Sorry, a mysql user with the name already exists.)


Account Restore Failed... Restore failed.

 

 

only use this code in ssh command

mysql> delete from mysql.user where user='USER';

Or

DROP USER 'USER'@'localhost';

Or

DROP USER USER;

 

Change USER with user name of mysql user

 

  • 0 Users Found This Useful
Was this answer helpful?

Also Read

How to Create Full backup for an account visa SSH

CPanel: Backup and Restore a Domain Account via SSHPlease Rate us Sometimes there is a need...

How create a backup of a MySQL database using SSH

Please Rate us  Log into your account on our server and issue the following command:...

Optimize and repair all mysql databases at once

There is a really handy MySql utility called mysqlcheck that allows you to do a number of...

How to disable SSH login for the root user?

Please Rate us  To disable root login, open the main ssh configuration file...

How to install OpenVPN on Linux?

apt-get install openvpn openssl udev ...