XAMPP - set password for root user ( MySQL / MariaDB ) on Windows

Trabla: XAMPP - set password for root user ( MySQL / MariaDB ) on Windows

Solving:

NOTE: SQL query for changing root user password, used in tutorial:

SET PASSWORD FOR 'root'@'localhost' = PASSWORD('Samurai123$%'); SET PASSWORD FOR 'root'@'127.0.0.1' = PASSWORD('Samurai123$%'); SET PASSWORD FOR 'root'@'::1' = PASSWORD('Samurai123$%'); FLUSH PRIVILEGES;

Where - Samurai123$ - new password, replace with yours