OK.
Within PhpMyAdmin specify a password for 'root@localhost'. Delete all the other users, if you don't need them. Then you have to change some entries in 'xampp\phpmyadmin\config.inc.php'. Load it in your editor and look for the entries under 'Server's Configuration, ca. at line 64. There are following the entries for the localhost configuration:
- Code: Select all
/**
* Server(s) configuration
*/
$i = 0;
// The $cfg['Servers'] array starts with $cfg['Servers'][1]. Do not use $cfg['Servers'][0].
// You can disable a server config entry by setting host to ''.
$i++;
$cfg['Servers'][$i]['host'] = 'localhost'; // MySQL hostname or IP address
$cfg['Servers'][$i]['port'] = ''; // MySQL port - leave blank for default port
$cfg['Servers'][$i]['socket'] = ''; // Path to the socket - leave blank for default socket
$cfg['Servers'][$i]['connect_type'] = 'tcp'; // How to connect to MySQL server ('tcp' or 'socket')
$cfg['Servers'][$i]['compress'] = FALSE; // Use compressed protocol for the MySQL connection
// (requires PHP >= 4.3.0)
$cfg['Servers'][$i]['controluser'] = ''; // MySQL control user settings
// (this user must have read-only
$cfg['Servers'][$i]['controlpass'] = ''; // access to the "mysql/user"
// and "mysql/db" tables)
$cfg['Servers'][$i]['auth_type'] = 'config'; // Authentication method (config, http or cookie based)?
$cfg['Servers'][$i]['user'] = 'root'; // MySQL user
$cfg['Servers'][$i]['password'] = 'YourPassWord'; // MySQL password (only needed
// with 'config' auth_type)
Only three lines are from interest for you:
- Code: Select all
$cfg['Servers'][$i]['auth_type'] = 'config'; // Authentication method (config, http or cookie based)?
If you are shure that only you will have access to the machine, let it, if it is. If you want that a login box opens, when you start PhpMyAdmin then change it to'http'.
- Code: Select all
$cfg['Servers'][$i]['user'] = 'root'; // MySQL user
I think it's right for your needs to login as root. Let it.
- Code: Select all
$cfg['Servers'][$i]['password'] = 'YourPassWord'; // MySQL password (only needed
// with 'config' auth_type)
If you have left the 'auth_type' as 'config' this is the place for the password you gave the 'root' in PhpMyAdmin. Leave this entry blank if you changed it to 'http'.
Save the file, shut the my sql server down and start it again. if you call PhpMyAdmin now you are logged in as root and the warning about the missing password is gone.
Rolo