Can't login to myphpadmin

Virtualmin
1

Not sure if this is more related to the virtualmin GPL install or the myphpadmin install. Virtualmin seems to be working just fine. I did the manual install myphpadmin and I cannot log into http://server/myphpadmin. I get a “wrong username/password. access denied”

CentOS 5.5 x64 on Xen VPS

Virtualmin 3.82.gpl GPL

phpMyAdmin 2.11.11.1

mysql Ver 14.12 Distrib 5.0.77, for redhat-linux-gnu (x86_64) using readline 5.1

When I configured mysql, I set the root password. I also ran a mysql_secure_installation and verified the root password was changed.

When I browse to http://server/myphpadmin I get the popup for the login. I am typing root and the mysql password I setup during installation.

I’ve installed the myphpadmin files to /home/myvirtualserver/public_html/myphpadmin

I’ve also modified the config.inc.php to…

/* Authentication type */
$cfg['Servers'][$i]['auth_type'] = 'http';
/* Server parameters */
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
/* Select mysqli if your server has it */
$cfg['Servers'][$i]['extension'] = 'mysql';
/* User for advanced features */
$cfg['Servers'][$i]['controluser'] = 'root';
$cfg['Servers'][$i]['controlpass'] = '';

According to the directions here…http://wiki.phpmyadmin.net/pma/Quick_Install

…once I login successfully I should add the pma “controluser” and then update the config.inc.php file. But I cannot get the 1st successful login.

Any help guys?

Thanks,
Mike

2

Howdy,

It sounds like you may be seeing a config issue of some sort… two things you may want to look into –

First, in your config.inc.php, what is “auth_type” set to? You may want to experiment with some different values. I’m using “cookie”.

Second, what is “AllowRoot” set to? I’m not sure what the default is, though on my system that’s set to “no”. So if you’re trying to login as root and things aren’t working, that could be due to phpMyAdmin being set to disallow root logins.

-Eric