Create a root password for PHPMyAdmin
*Set Password baru: Open phpMyAdmin and select the SQL tab. Then type this command: SET PASSWORD FOR root@localhost = PASSWORD('your_root_password'); Edit: Also change to this line in config.inc.php : $cfg['Servers'][$i]['auth_type'] = 'cookie'; To make phpMyAdmin prompts for your MySQL username and password. *Update password dari yang sudah diset tadi: UPDATE mysql.user SET Password=PASSWORD('ganti dengan yang dimau') WHERE User='root'; FLUSH PRIVILEGES; ======================================================= Here the simple step that you can easily set PHPMYADMIN Password. Goto “ C:\xampp\phpMyAdmin ” and find “Config.inc.php” file Open “ Config.inc.php ” file in Text editor like Notepad++. Find the line $cfg [‘Servers’] [$a] [‘auth_type’] = ‘config’; in “config.inc.php” file. Change the word $cfg [‘Servers’] [$a] [‘auth_type’] = ‘config’; to $cfg [‘Servers’] [$a] [‘auth_type’] = ‘cookie’; in “config.inc.php” file...
