phpmyadmin login - i keep getting the infamous '#2002 Cannot log in to the MySQL server' error ? 1

[c0deM0nK424]

ive tried everything - well not really.

here is my config.inc.php file folks:

$cfg['Servers'][$i]['host'] = '127.0.0.1'; ( previous it was 'localhost' )

$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
/* Select mysql if your server does not have mysqli */
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['AllowNoPassword'] = false; ( previously i ommited this entire line)
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'tnj888777'; (previously this line never existed )

so with the changes that I did i STILL get the #2002 error.

Is there a way to fix this issue ??

where am i going wrong ?

I have:

PHP Version 5.4.16
Apache Version : 2.4.4
MySQL Version : 5.6.12

please folks - any wamp heads out there who know the fix ? whats happening why wont it friggin let me in ??


Oh im using Windows xP sp 3 , if that helps ( should it ) ?

get back to me on this one asap please folks.

im trying to install magento on wamp - obviously i cant if i cannot create a goddamn database in phpmyadmin ( need to create a database for magento , im using a tutorial on youtube ).

 

[vacunita]

What is $i? in your config.inc file?

How are you using this configuration?

How are you accessing the $cfg variable?

Are you sure MYSQL is running on your local machine?

If you installed WAMP the WAMP task bar icon should list the status of all the services including MYSQL.

What happens if you create a direct connection using mysql_connect(); ?






----------------------------------
Phil AKA Vacunita
----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.

Web & Tech

 

[c0deM0nK424]

Hello Vacunita - thanks as always for responding to all my threads, its seasoned I.T veterans and proven smartheads like you who enrichen forum experience imo.


Okay so this issue has been resolved - i uninstalled Wampserver from control panel.

2. I backed up the

http://www directory

on C drive INCASE i wanted to use some of the stuff in there

3. I used file shredder to delete the wamp folder left over after the un-install , over 10,000 files deleted with a 3 pass lol

4. restarted machine

5. re-installed the wampserver package

6. phpmyadmin working again

7. created a new passowrd inside phpmyadmin itself

8. generated a password from step 7.

9. now i can log in - about to create my database


i tried so many silly things earlier - stackoverflow forums, daemon tool forums, ubuntu forums, hell i was going as far as to use the cmd and manually create a new administrator lol


but this has now been resolved - so yeah, if anybody has this issue - just do my steps


regards

code monk.

 

[c0deM0nK424]

ok vacunita - how do i 'close' this thread so its archived (solved) lol ?

 

[jpadie]

I would guess it is because your mysql installation was listening on a non standard port. this is normal for wamp installs.

leave on localhost and phpmyadmin will use a socket for the mysql library to communicate with the server. change to 127.0.0.1 (loopback) and you will need to supply a port as well if mysql is listening on anything other than 3306. the listen port will be a parameter in the wamp control panel normally.

 

[vacunita]

Glad you solved it. You can't close threads here. But thanks for posting what solved it for you.

----------------------------------
Phil AKA Vacunita
----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.

Web & Tech