xampp - set mysql root password

[Costas]

once you connect to phpmyadmin go to SQL tab and execute :

--mysql
UPDATE mysql.user SET Password=PASSWORD('password') WHERE User='root'; FLUSH PRIVILEGES;

--MariaDB - https://mariadb.com/kb/en/set-password/
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('password')

stop mysql from xampp control panel

goto /xampp/phpmyadmin/config.inc.php set the password :

$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'password';

 
https://www.pipiscrew.com/2018/04/mysql-v5-7-21x86-bone-edition/