Reset your Database Password

A user's identity in MariaDB is determined by their username and host combination. If you have numerous users from different source hosts, you will need to reset the password for each user. To reset your database password, connect to the MariaDB cluster and run either of the following commands using the user whose password should be changed:

• SET PASSWORD = PASSWORD('<new password>');

• SET PASSWORD = '<passwordhash>';

Reset your database password using the commands