[gentoo-user] phpmyadmin user/password?

[gentoo-user] phpmyadmin user/password?

[Daevid Vincent]

I emerged phpmyadmin 2.7 and when I go to the URL, it prompts for a
user/password. What exactly is this user/pw it's looking for? The one stored
in mysql.users? My actual account? Both in this case have no password set.

I've used this program for years, and I've just installed it from their
source tarballs. The ebuild seems to add this htaccess style protection (yet
I see no .htaccess file)

I have a VMWare that I use for webdev. I have no pw on root. (spare me the
warnings please, this isn't a mission critical "box", it's just a quick VM
to get LAMP/Rails stuff coded in without a lot of fuss).

I've tried from links2 on localhost (this VM has no X-windows/GUI). 
I also have tried via web browser on the host.

I put 'root' and '' but it doesn't accept it. This is all stock
phpmyadmin/mysql install thus far.

Strangely however, I have installed this ebuild on the host machine (ie. My
notebook) and that same user/pw combo does work (and yes, I have a pw on
root's account, but not the mysql root one) -- but that was installed with
an older phpmyadmin and upgraded over time.

"You had me at EHLO" --E.Webb (10.04.05) 

-- 
gentoo-user@gentoo.org mailing list

Re: [gentoo-user] phpmyadmin user/password?

[Qv6]

On Thursday 15 December 2005 05:24 pm, Daevid Vincent wrote:
> I emerged phpmyadmin 2.7 and when I go to the URL, it prompts for a
> user/password. What exactly is this user/pw it's looking for? The one
> stored in mysql.users? My actual account? Both in this case have no
> password set.
 
It's asking for the Mysql username/password root user. Recall that 
phpmyadmin is used to administer/administrate Mysql
-- 
gentoo-user@gentoo.org mailing list

RE: [gentoo-user] phpmyadmin user/password? [solved]

[Daevid Vincent]

Hmm. Well I thought I had done this, but issuing this command again seemed
to have fixed it:

mysql -u root -p <
/usr/share/webapps/phpmyadmin/2.7.0_p1/sqlscripts/mysql/2.7.0_p1_create.sql 

The problem now is that all the images are broken and no CSS is being
applied if I try to connect from a remote IP.

I fixed that by setting config.default.php to:

#$cfg['PmaAbsoluteUri'] = 'http://localhost//phpmyadmin';
$cfg['PmaAbsoluteUri'] = '';                            

Not quite sure why that is set by default when it works better without it...


"You had me at EHLO" --E.Webb (10.04.05)  

> -----Original Message-----
> From: Qv6 [mailto:sundiatah@comcast.net] 
> Sent: Thursday, December 15, 2005 4:18 PM
> To: gentoo-user@lists.gentoo.org
> Subject: Re: [gentoo-user] phpmyadmin user/password?
> 
> On Thursday 15 December 2005 05:24 pm, Daevid Vincent wrote:
> > I emerged phpmyadmin 2.7 and when I go to the URL, it prompts for a
> > user/password. What exactly is this user/pw it's looking 
> for? The one
> > stored in mysql.users? My actual account? Both in this case have no
> > password set.
>  
> It's asking for the Mysql username/password root user. Recall that 
> phpmyadmin is used to administer/administrate Mysql
> -- 
> gentoo-user@gentoo.org mailing list
> 
> 

-- 
gentoo-user@gentoo.org mailing list

Re: [gentoo-user] phpmyadmin user/password? [solved]

[David Obwaller]

On Thu, Dec 15, 2005 at 05:00:02PM -0800, Daevid Vincent wrote:
> Hmm. Well I thought I had done this, but issuing this command again seemed
> to have fixed it:
> 
> mysql -u root -p <
> /usr/share/webapps/phpmyadmin/2.7.0_p1/sqlscripts/mysql/2.7.0_p1_create.sql 
> 
> The problem now is that all the images are broken and no CSS is being
> applied if I try to connect from a remote IP.
> 
> I fixed that by setting config.default.php to:
> 
> #$cfg['PmaAbsoluteUri'] = 'http://localhost//phpmyadmin';
> $cfg['PmaAbsoluteUri'] = '';                            
> 
> Not quite sure why that is set by default when it works better without it...

I believe the correct setting would be something like

	$cfg['PmaAbsoluteUri'] = 'http://YOUR_IP_OR_HOSTNAME/phpmyadmin';

David
-- 
gentoo-user@gentoo.org mailing list