phpmyadmin issue

[scorpionz]

Hi This is Scorp

I have Little issue about phpmyadmin.

When i write
http://localhost/phpmyadmin
on my url and Press Enter
i got the Login Screen
and i tries every username and password, but everytime it gives same error

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

I m stuck
Any help will be Appriciated
Regards Scorpion

[johnsquibb]

i assume you have root access to the server to set configurations etc....

I am not a phpmyadmin maestro, so you might be better off posting this in a linux/wamp forum depending on your server type...I can just suggest a few troubleshooting techniques that I have come across in my experience.
--
is mysql running?
--
have you set a password for mysql root user yet? If not, enter a username without password. More on mysql passwords here: http://dev.mysql.com/doc/refman/5.0/en/adding-users.html
---
have you set up the phpmyadmin config? This can be a royal pain. Be sure to refer to the documentation here: http://wiki.cihar.com/pma/Welcome_to_phpMyAdmin_Wiki . Quick Install->configuration is a good place to start.

[nav33n]

Grant privileges (using root account) to the user pma. I don't think pma have sufficient privileges.

[scorpionz]

So Guys How can i Fix this issue so as to get through to my wprk
Regards
Scorpion

[nav33n]

If you have root password, login with ur root account, create or grant privileges to a user. Check mysql manual for more information !

[Walkere]

So Guys How can i Fix this issue so as to get through to my wprk

Well, the best way to do that would be to remember the password you used.

In lieu of that, you can log in as the root user and modify the password for the user 'pma' to something new.

Here's how you do this in phpmyadmin, once you're logged in as the "root" account.Click on "Privileges" tab
Find username 'pma' in the list
Click on the "Edit Privileges" icon all the way to the right
Scroll down to where it says "Change Password"
Select "Password" and enter a new password
If you don't know the password for the "root" account, you can re-set the password and then use the root account to reset the 'pma' account. Here's the relevant section of the mySQL documentation on re-setting the root password .

Good luck,
- Walkere

[scorpionz]

Sorry to say Guys, i am unable to solve the issue of login to phpmyadmin, let me give you more detail about my problem
I tried with every username and every password but but but nothing is working it is not logging, every time it generates same error,

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

I m stuck Guys.....

if any one can give some stepwise working scenario about setting username and password so i can start it phpmyadmin...

Regards
Scorpion

[nav33n]

Can you log in with 'root' account ?

[scorpionz]

I cant event log in through root...
I dont know What to do?????
Regards
Scorpion

[nav33n]

hmm.. Check this . It might be of some help.

[scorpionz]

Well Thanks Naveen, but I have install Xampp on my laptop, not individually everything, and the website u provided me is for configuration of mysql separately
I need to configure it in Xampp.
Well Sorry to say it is still not solved yet

Regards
Scorpion

[richie513]

Hi scorpionz,

Go into your phpmyadmin directory and find a file called config.inc.php. Open this file and find the lines 72, and 73. Set line 72 to 'root' and line 73 to the root password you used when you installed it. If you didn't use a password when you installed it, then add a password in there that you will remember. After you have done this save the file, then see if you can login in. If you can log in, you can then have full control over phpmyadmin, you can then if you want to re-create a new user account. I hope this helps

[scorpionz]

No it is still not solved....
the website u provide me is not really helpful for my issue... after all Thanx
when i click on phpmyadmin
it just give an error page

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

So men What to Dooo
Thanx in Advance

and my config file has these lines

$cfg['Servers'][$i]['auth_type'] = 'config'; // Authentication method (config, http or cookie based)?
$cfg['Servers'][$i]['user'] = 'root'; // MySQL user
$cfg['Servers'][$i]['password'] = ''; // 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'

[richie513]

ok in your config file, change this line:

$cfg['Servers'][$i]['password'] = ''; // MySQL password (only needed
// with 'config' auth_type)

to this:

$cfg['Servers'][$i]['password'] = 'Yourpassword'; // MySQL password (only needed
// with 'config' auth_type)

Note where I wrote 'Yourpassword' in the code above, change this to whatever password you want. Once you have done this, save the file and log in phpmyadmin using your root account. You can then edit your user privileges when you are in there. It is not letting you in because you have no password in the line of code above. Try this and let me know how you went:)

[scorpionz]

$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)

Not Working Buddy... I m Stuck...

Thanx and Regards
Scorpion

[richie513]

hmm this is a tricky one, just a question, can you log in using your MySQL console?, if not you might have to re-install MySQL

if you can, try and re-install phpmyadmin:)

[scorpionz]

Thanx after all but richie
i m using Xampp not doing installation individually

So big issues around me
Buddy solve it i will be Thankful

Regards scorpion

[nav33n]

Open mysql console and create a new user.

create user testuser;
grant all privileges on *.* to 'testuser'@'localhost';

This will create a new user called testuser with all the privileges. Use this user account in your script.

[richie513]

ok try changing this line:

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

to:

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

Notice that I have changed 'config' in the first line of code to 'http' in the second line of code, give this ago. This should bring up the login page for phpmyadmin, then try login from there!

[scorpionz]

Thanks for telling that but Naveen its giving this error when writing on Console

c:\xampp\mysql\bin\>mysql.exe -root
ERROR 1045 (28000): Access denied for user 'ODBC'@'localhost' (using password: NO)

Another Issue raised inside an issue
Men this is really unbelievable, I never have this Problem in my Office PC

Regards
Scorpion