Setting username and password in phpmyadmin

Question

I need to set the username and password in phpmyadmin for mysql.

I think the default username is root@localhost.

I do not know how to set this.

Answer 1

The 'root' user would have been setup during the initial install. If you open the config.default.php file you will see

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

This information can be changed provided you are not using 'cookie' validation. Like this

$cfg['Servers'][$i]['auth_type'] = 'cookie';