xampp default password mysql code example

Example 1: set mysql password xampp

SET PASSWORD FOR 'root'@'localhost' = PASSWORD('pass');
FLUSH PRIVILEGES;

Example 2: xampp mysql default username and password

if you open localhost/phpmyadmin you will find a tab called "User accounts". There you can define all your users that can access the mysql database, set their rights and even limit from where they can connect.