How to reset the password for a MySQL database?AA-00340You may need to change the password of your database in order to improve the security of your website or if your account has been compromised by hackers. Basically the easiest way to change the password for your database is to recreate the MySQL user attached to it. You can use the following instructions to do so:
You will be prompted to confirm this action: Are you sure you wish to permanently remove user yourusername_user? Click on the Delete User button in order for the database user to be successfully deleted. Then you should create a new database user:
Type the same database username and type (or generate) the new password for it. Bear in mind that you will be able to change only the user part of the database name yourusername_user. The prefix yourusername_ is added by default by the system.
NB: Note that if the database is used by a
script/web application (WordPress, Joomla etc.) you will have to
reconfigure it and set the new password inside its configuration file. |