phpmyadmin Problem

[ScorpionZ]

Hi This is Scorp
I have recently installed Xampp on my Laptop,
well Xampp is Running, Apache and mysql status are in "Running" Mode at Xampp Control panel

Now when i write
http://localhost/phpmyadmin
on my url and Press Enter

There is an Page Open with Error
It said

Error
MySQL said:
#1045 - Access denied for user 'pma'@'localhost' (using password: NO)

Now I want to know what is this Problem?
and How to solve it?

Any Help will be appreciated with kindness.
Thanks in advance
Scorp.:)

[sir pannels]

Hi Scropion

Open up localhost/xampp and you will see a Security link. Click that. In there are password options for PHPMYADMIN aswell as some other xampp password stuff, you can set your password or turn password for phpmyadmin there.

cheers :)

[ScorpionZ]

Well What can i say... Thank U very much for response....
but i cant understand ur exact point what should i supposed to do
I did go to
http://localhost/xampp
then go to Security which is at left side. when i get into that i find a link
http://localhost/security/xamppsecurity.php
when i click on this
i find a Text fields of New Password and Current Password
I did that too by changing a root Password but when i click on "Changing Password " it returns a successful message but when i restart the mysql from CP of Xampp it again gives a same error Page as i mentioned in my post 1

kindly find some solution about this Problem
Thanks in advance
Scorp

[hammer65]

You might try going directly to the configuration file for PHPMyAdmin. Directions for editing the file are on the PHPMyAdmin web site.
http://www.phpmyadmin.net/

[ScorpionZ]

Sorry Guys I am Confused a bit the url hammer65
give me has got many of the files about phpmyadmin
I still still am cant understand what to do to start phpmyadmin from Localhost

Thanks in advance after all for such help uptil now,
any help will be appreciated

Regards
Scorp

[o0O0o.o0O0o]

i installed WAMP server I WORKED PERFECTLY
no need to change anything

just try it

[ScorpionZ]

No Doubt that u use Wamp. and you are satisfied with it.
But the thing is that i use Xampp at my office too.
But now I have install that in my Home Laptop and Facing this Problem.
So can anyone have the Solution of this Problem. the step by step instructions.
I will be very Thankful
Thanks in advance

Regards
Scorp

[abduraooft]

Found some links through google, hope they'l help!
http://www.robsnotebook.com/xampp-additional-passwords
http://rudyegenias.wordpress.com/2006/09/15/enabling-phpmyadmin-once-you-change-permission-or-privileges-on-mysql-database/

[ScorpionZ]

Hi, First of all Thanks for Such a great help, i was sick for few days so unable to contact here.
Finally i got the Login Screen, that i got

Now i am giving

I try in every way with username and Password.

but everytime it gives an error now... like a Validation
i.e
Error
MySQL said:
#1045 - Access denied for user 'pma'@'localhost' (using password: YES)

Now
What to Do NExt

Thanks after all for bringing a Login Screen For me.
Hoping for Best Response

Regards
Scorp

[ScorpionZ]

Guys Where are u all.
I still couldn't find the solution at all

Thanks and Regard
Scorp...

[outseeker]

OK buddy. That error 1045 is because the phpmyadmin is trying to connect to your database using the user "pma" and with no password. Either "pma" doesn't exist as a user, or he has a password but you haven't told phpmyadmin what it is. Within your phpmyadmin files, you should have a file you edited to say "pma" is your MySQL login name. In the same area, you should have an area that wants your password for that MySQL user's name. Also the database to connect to etc.

Make sure your login name, password, and database are all correct in the phpmyadmin configuration file and it will connect for you.

If you would prefer to do things the easy way, instead of phpmyadmin you can just use http://www.sql-front.com/download.html instead. Windows .EXE front end for MySQL. Super easy, basically no configuration needed. See how you go. :)

[ScorpionZ]

Thanks a lot outseeker
But sorry i dont want to use any downloader, i just want to go through to it manually,
I would like to isnt that the port number issue?
coz i was having my IIS service running and for that reason i got some solution of changing Port number, even though Xampp is running fine

at
http://localhost:800/phpmyadmin

Please I need the solution to this problem

Regards
ScorpionZ

[ScorpionZ]

Hi Guys this is my Config file
may this will help in Solving my issue... please check this

$cfg['Servers'][$i]['controluser'] = 'pma'; // MySQL control user settings
// (this user must have read-only
$cfg['Servers'][$i]['controlpass'] = 'secret'; // access to the "mysql/user"
// and "mysql/db" tables).
// The controluser is also
// used for all relational
// features (pmadb)
$cfg['Servers'][$i]['auth_type'] = 'config'; // Authentication method (config, http or cookie based)?
$cfg['Servers'][$i]['user'] = 'root'; // MySQL user
$cfg['Servers'][$i]['password'] = 'test'; // MySQL password (only needed
// with 'config' auth_type)
$cfg['Servers'][$i]['only_db'] = ''; // If set to a db-name, only
// this db is displayed in left frame
// It may also be an array of db-names, where sorting order is relevant.
$cfg['Servers'][$i]['verbose'] = ''; // Verbose name for this host - leave blank to show the hostname

$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin'; // Database used for Relation, Bookmark and PDF Features
// (see scripts/create_tables.sql)
// - leave blank for no support
// DEFAULT: 'phpmyadmin'

I got the same Error i.e..
MySQL said:
#1045 - Access denied for user 'pma'@'localhost' (using password: YES)

I m Stuck...

Thanx and Regards
ScorpionZ

[outseeker]

well, if you've really got your heart set on phpmyadmin instead of something that actually works ;)

OK, I've downloaded phpmyadmin from http://optusnet.dl.sourceforge.net/sourceforge/phpmyadmin/phpMyAdmin-2.11.4-english.zip (do this if you have an older version than 2.11.4) and am about to go thru a full install for you step by step.

The mysql login name "pma" is the default one set by PhpMyAdmin.

Are you saying you have created a MySQL user named "pma" that has access to a database? If you haven't, of course you can't login as pma and use phpmyadmin. Before I do the complete writeup, could you check this out for me? Where is your mysql database and what is the login name etc. for that? Is this running on your own PC or on a web server by the way?

Cheers

[outseeker]

Just finished installing it.. Slightly problematic.. Using the version I linked to: unzip it, rename the config.sample.inc.php to config.inc.php, edit config.inc.php and put a correct working mysql name and password in the relevant fields, upload the files to your server and access the phpmyadmin directory (ie. http://yoursite.com/phpmyadmin)

That worked just fine for me. It complained I hadn't set a blowfish encryption key, so I edited config.inc.php and typed a random key for it. Done. I'm pretty sure I can see your problem: pma is not a valid mysql user.

Make sure you download the newest version man, I can see in the config file u quoted a login name and password two different times. One pma and one root. The config file I was looking at from the phpmyadmin release only declared one of those two.