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.
No comments