xampp - set mysql root password

Costas

Administrator
Staff member
once you connect to phpmyadmin go to SQL tab and execute :
JavaScript:
--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 :
JavaScript:
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'password';
 
https://www.pipiscrew.com/2018/04/mysql-v5-7-21x86-bone-edition/
 
Top