phpmyadmin install issue

[oddyseys]

I am trying to get phpmyadmin to install so I dont have to use a dos tool or the tool they give you from the mysql install .zip file. I have dloaded the most current version of mysql and php and when I try to reach the index.php page for phpmyadmin it gives me a connection error something like ... cannot connect root@127.0.0.1 (using password: yes). the mysql is installed and the php works (tested with a phpinfo() page) so once I get that set I can start developing my pages that I want to do. If I cant use phpmyadmin I need to know of a good (and free if possible) resource for managing mysql tables from a friendly GUI. BTW I am running this all on IIS 5 in win2k server on the localhost address.

Thanks for the help in advance.

Jim

[daphreeek]

somewhere in the phpmyadmin folder is a config file (config.inc.php i think) edit it so that it has a login instead of using the root password (otherwise anyone can use ur D😎.

Go through the whole file and set all the variables to the correct value. For login, i reccommend cookies 🙂

Hope that helps
- Matt

[foolguitardude]

Don't take this as an insult, but are you sure that the mySQL server is running? I've forgotten this a few times myself.

[oddyseys]

Yes the server is running as the mySQL AB utility monitor is showing the test databases of test and mysql. I believe I have also installed the mysql as a service to start automatically. I can verify this when I get back home as I'm currently at school.

I can attach my my.ini and my.cnf files if it will help when I get home.

Jim

[daphreeek]

did you try doing what I stated? It looks simply like you have the wrong password/settings in the config for it 🙂

• Matt

[superwormy]

daphreeek has the most likely solution to your problem... you should listen to him and try what he suggested.

[oddyseys]

Will do! Thanks a lot for the help.

Jim

[oddyseys]

I am unsure of what settings daphreeek is referring too so I have added my configuration files so that I dont mess up something that is working at least as a service. Thanks for the help.

Jim

[daphreeek]

In config.inc.php change this lines:

$cfg['Servers'][$i]['auth_type'] = 'config'; // Authentication method (config, http or cookie based)?

to:

$cfg['Servers'][$i]['auth_type'] = 'cookie'; // Authentication method (config, http or cookie based)?

The above should make it work at least but I highly reccommend going through the entire file and changing it to how you want it.

Read all the comments - it takes a while but its worth it 🙂

• Matt