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