{"id":1049,"date":"2013-07-02T03:39:01","date_gmt":"2013-07-02T09:39:01","guid":{"rendered":"http:\/\/blog.supportpro.com\/?p=1049"},"modified":"2018-10-04T00:57:15","modified_gmt":"2018-10-04T06:57:15","slug":"error-account-creation-status-failed-sorry-a-mysql-user-lets-take-dbuser-with-the-name-already-exists","status":"publish","type":"post","link":"https:\/\/www.supportpro.com\/blog\/error-account-creation-status-failed-sorry-a-mysql-user-lets-take-dbuser-with-the-name-already-exists\/","title":{"rendered":"How to fix – Error: Account Creation Status: failed,mysql user with the name already exists"},"content":{"rendered":"

While restoring a cPanel account from one server to another server there is a chance for following error: Account Creation Status: failed (Sorry, a mysql user (let’s take ‘dbuser’) with the name already exists<\/p>\n

To Delete the user :<\/p>\n

Please login into the mysql and follow the steps<\/p>\n

mysql<\/p>\n

mysql > use mysql;<\/p>\n

mysql > drop user dbuser@localhost;<\/p>\n

OR<\/p>\n

mysql> delete from mysql.user where user=dbuser;<\/p><\/blockquote>\n

You can also check this using :<\/p>\n

select User, Host from user where User like dbuser;<\/p><\/blockquote>\n

Where dbuser is the user mentioned in the error.<\/p>\n

If the above mentioned steps do not fix the issue,please follow the below steps.<\/p>\n

Please check for entries of that usernames in the following files and if there is any, remove those entries.<\/p>\n

\/var\/cpanel\/databases\/users.db<\/p>\n

\/etc\/dbowners<\/p><\/blockquote>\n

After removing these entries, execute the following command.<\/p>\n

userdel -f username<\/p><\/blockquote>\n

If you require help, contact SupportPRO Server Admin<\/a><\/p>\n

\"Server<\/a><\/span>