Installing on a system with windows xp / norton internet security. I have tried several versions of mysql. Still cant connect after successful installation. :shock:

I tried the grant privlege * thingie, and even created a new user through phpMyAdmin.

When I tried version 4.1.5, after successful upload and using phpMyAdmin, (config, username, user password) when I got the popup window for the user name and password, nothing I entered was accepted. You could try it 3 times then got a screen change - access denied. :shock:

In one case, the only version I could connect on (phpMyAdmin) was 4.0.0a. When I wrote the db via php form, it would not show the result although it actually wrote the data to the db.

this is really weird because ites surely not an OS issue...
try installing phpMyAdmin 2.6.0 pl1 even thou all other versions are working fine..
dont forget to set some variables in the config.inc.php file.

The main problem is that you are using a root as a username for the entire DB engine..
change the username and a password in MySQLAdmin that is distributed with the MySQL and then set those username and a password in the phpMyAdmin's config.inc.php file..

This will work... or atleast should work... you might have already done that before,,, but try again.. with a aclean install... i would set an Auth method to HTTP if i were you..

Okej... i found out that ive made one mistake**atleast** while explaining..
http and cookie types of access do not need a password in the config.inc.php... only the congig type does..
Also i forgot to tell thats its very important to set blowfish secret.

I think they wrote about using a command line... and it worked for them...
i think its just their configuration files that have some misstakes... this i was able to understand from one of the emails that i recieved.

If some of you would post their config files --- atleast a part of it..
then i might be able to help a bit more...

First of all, I solved the "no access" error as mentioned in my last post. It was related to the config of my OS.

Now I get "incorrect user/password" error.

command line works just fine. Did the grant all and everything else in the manual.

It should be noted that when I set the config.inc.php file for phpMyAdmin [latest version] type = 'config' and user = 'root and password = ''[nothing], I can access MySql.

It's when I put anything else in the username and password [as shown by the admin utility that comes with MySql] that I get the "password/user" incorrect error.

FYI - I didn't have any issues when using Win 2000 prof edition. This XP prof edition has not been what I thought. When originally installed, the installer suggested to use the upgrade option, which I did. Lots of issues. I wound up wiping the drive and doing a clean install with XP. I don't know if this XP is cracked up to be what Microsoft said it was......... anyway...... :sad:

:-D Again, thanks to all for the posts. I appreciate your input and kindness.

Well the deal is that in the config file you should set the MySQL access information... the one that is set in my.ini file of the mysql database administration..
Http access type needs only username to be saved in the phpmyadmin config.inc.php

After you've loged in you should create a new user and give it full access with a password protection... this way you will have to use that user instead..