In a few circumstance, customers may be using a Remote MySQL database (for legacy support or other reason).
Customer may login to (remote) phpMyAdmin,
Issue the following SQL to get the current logged-in username –
Issue the following SQL to change the current user password –
SET PASSWORD = PASSWORD(‘new_password’);
For local MySQL database (localhost), customer may simply login to DirectAdmin, MySQL management, select the MySQL database, and MySQL user, and change the password.