Change MariaDB user password
To change the MariaDB root password, log in to MySQL as the user root
1 |
mysql -u root -p |
Enter your current password when prompted.
Use the following command to change the root password
1 |
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('NEW_PW_HERE'); |
Replace NEW_PW_HERE with your new MySQL root password.
Change a user password
1 |
SET PASSWORD FOR 'USER_HERE'@'localhost' = PASSWORD('NEW_PW_HERE'); |
Example
1 |
SET PASSWORD FOR 'admin'@'localhost' = PASSWORD('serverok123'); |
For more info, see