How to remove a MySQL database without removing its db user which is being used with another database as well?

In H-Sphere, if we have several databases and have a common db user for all and at some point remove a database then this will remove the database user for all the databases. To prevent this we should first unassign the database user for that database which we want to remove. For that we can follow the steps below:- 

1. Login to the H-Sphere control panel > Go to Databases > MySQL > MySQL DB's.
2. Select the user in question for the respective database.
2. Click on 'Edit user's privilege' and then uncheck all the privilege options there and click on the 'Submit' button.
3. After this, you may see the error 'Internal Error, Tech Support Was Notified' but at that moment you'll see that the db user has disappeared for that database, and then you can remove the database and it won't affect the db user for other databases.

That's it.

Sachin Tuesday 20 August 2013 - 8:08 pm | | Default

No comments

(optional field)
(optional field)

Comment moderation is enabled on this site. This means that your comment will not be visible until it has been approved by an editor.

Remember personal info?
Small print: All html tags except <b> and <i> will be removed from your comment. You can make links by just typing the url or mail-address.