PHP MySQL Windows Configuration

[Beady]

I am a reasonably aware user of Windows but know nothing about this Unix thing.

I need to set up a PHP/MySQL web on my machine, running XP Pro.

I can get it to work OK, except I get two messages on the opening page of phpMyAdmin:
-----
The $cfg['PmaAbsoluteUri'] directive MUST be set in your configuration file!

Your configuration file contains settings (root with no password) that correspond to the default MySQL privileged account. Your MySQL server is running with this default, is open to intrusion, and you really should fix this security hole.
-----
I've set the $cfg['... equal to

http://localhost/phpMyAdmin/

but this doesn't make any difference.

I've set, I think password and user values in the user table and in the php.ini file and again it makes no difference.

Can someone point me in the direction of a non-Unix type tutorial.



Regards,
Bernard Davis

http://www.authorware.org.uk

http://www.castlecs.co.uk

 

[DRJ478]

Hi!

1. Are you sure PHPMyAdmin is in the folder you specified in the PmaAbsoluteUri ? Try to use the IP for localhost.

2. After changing the values in the user Table, did you use 'flush privileges'? Changes in the access privileges don't change before the 'flush privileges' command is issued.

 

[SPYDERIX]

Hi,

When you login to phpmyadmin there is a link in the middle there that says change password. That's the password it's talking about. It doesn't want the users passwords it wants the root user password.

Hope this helps!

Nate

http://www.mainframe-webdesign.com

 

[shaddow]

$cfg['PmaAbsoluteUri'] = '';
/**
* Disable the default warning about $cfg['PmaAbsoluteUri'] not being set
* You should use this if and ONLY if the PmaAbsoluteUri auto-detection
* works perfectly.
*/
This should work with no setting.
Also with the new PhpMyAdmin i get same warnings also, you cant set a MySql password on windows machine, or at least you set but doesnt work, might be fixed in the latest mysql but never tryed, you dont need password on mysql as long you stop the incomming conexion to the MySql server.

________
George, M