Pages: 12Next
Current Page: 1 of 2
phpmyAdmin wont work.
Posted by: MC2 (---.link.net.pk)
Date: March 06, 2008 02:57PM

Hi, i recently installed WAMPSERVER to test my PHP scripts locally. Everything works fine except tha when i try to open phpmyAdmin it shows:
Error
MySQL said:

#2003 - Can't connect to MySQL server on 'localhost' (10061)

And using he mysql_connect function in the script returns:
Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'mohsin'@'localhost' (using password: NO) in C:\wamp\www\MC2\mg.php on line 2

I've tried to tinker with php.ini file using ideas pcked from other posts, it hasn't helped.
Any Ideas?

Options: ReplyQuote
Re: phpmyAdmin wont work.
Posted by: stevenmartin99 (---.b-ras1.blp.dublin.eircom.net)
Date: March 06, 2008 03:53PM

try the user root first with no password

if that works go into privledges in phpmyadmin and set up a new user for you

Options: ReplyQuote
Re: phpmyAdmin wont work.
Posted by: yfastud (Moderator)
Date: March 06, 2008 04:26PM

Check Setup Password and Setup Database guides on my personal website

Have fun,

FREE One A Day
FREE Photo
FREE Games
FREE Websites
FREE Portable GPS
FREE WAMP Guides

Options: ReplyQuote
Re: phpmyAdmin wont work.
Posted by: MC2 (---.link.net.pk)
Date: March 06, 2008 04:54PM

Can u tell in a more step by step approach plz, i couldn't make any head or tail of wat u said .

Options: ReplyQuote
Re: phpmyAdmin wont work.
Posted by: stevenmartin99 (---.b-ras1.blp.dublin.eircom.net)
Date: March 06, 2008 05:02PM

open up the file config.inc.php in c:/wamp/apps/phpmyadmin2.10


change



$cfg['Servers'][$i]['user'] = 'blablabla'; // MySQL user
$cfg['Servers'][$i]['password'] = ''; // MySQL password (only needed



to

$cfg['Servers'][$i]['user'] = 'root'; // MySQL user
$cfg['Servers'][$i]['password'] = ''; // MySQL password (only needed



then empty browser history and try log in again

Options: ReplyQuote
Re: phpmyAdmin wont work.
Posted by: MC2 (---.link.net.pk)
Date: March 06, 2008 05:13PM

Well its already that way

Options: ReplyQuote
Re: phpmyAdmin wont work.
Posted by: yfastud (Moderator)
Date: March 06, 2008 05:16PM

did you ever have db before? if already uninstall, did you clean its registries as well?

Have fun,

FREE One A Day
FREE Photo
FREE Games
FREE Websites
FREE Portable GPS
FREE WAMP Guides

Options: ReplyQuote
Re: phpmyAdmin wont work.
Posted by: MC2 (---.link.net.pk)
Date: March 06, 2008 05:27PM

No nothing of this sort before.

Options: ReplyQuote
Re: phpmyAdmin wont work.
Posted by: yfastud (Moderator)
Date: March 06, 2008 06:07PM

So you never had any type of db before; then, check if you have any soft in this list: IIS, Skype, NOD32, Internet Optimizer, Google accelerator, ...
I still wonder and try to find out the reason why recently a lot of people have the problem to run mysql after installing wamp???

Have fun,

FREE One A Day
FREE Photo
FREE Games
FREE Websites
FREE Portable GPS
FREE WAMP Guides

Options: ReplyQuote
Re: phpmyAdmin wont work.
Posted by: hambuler (---.cpe.net.cable.rogers.com)
Date: March 07, 2008 05:32AM

Does your php script mysql_connect function reside on the same computer where the Wamp Server is running?

Options: ReplyQuote
Re: phpmyAdmin wont work.
Posted by: stevenmartin99 (---.b-ras1.blp.dublin.eircom.net)
Date: March 07, 2008 05:44AM

paste ur script up herre .it must be wrong

Options: ReplyQuote
Re: phpmyAdmin wont work.
Posted by: MC2 (---.link.net.pk)
Date: March 07, 2008 02:22PM

<?php
$con = mysql_connect("localhost","MC2","*********"winking smiley;
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
?>

Options: ReplyQuote
Re: phpmyAdmin wont work.
Posted by: stevenmartin99 (---.b-ras1.blp.dublin.eircom.net)
Date: March 07, 2008 02:51PM

<?php
$con = mysql_connect("localhost","root"winking smiley;
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
?>




try this. if that works then u never set up ur user properly

Options: ReplyQuote
Re: phpmyAdmin wont work.
Posted by: wampit (---.tbcn.telia.com)
Date: March 07, 2008 09:12PM

I have the same problem and can't use PHPMyAdmin. I have just done a clean installation and have never had WAMP on the computer before. Just followed the installation instructions and have not change anything.
The other (SQLiteManager) works.

------------

#2003 - Can't connect to MySQL server on 'localhost' (10061)

------------

Options: ReplyQuote
Re: phpmyAdmin wont work.
Posted by: wampit (---.tbcn.telia.com)
Date: March 08, 2008 09:25PM

Ok, I've tried to reinstall it and only followed the onscreen instructions.
But still, PHPMyAdmin don't work, MySQL-Lite work and has an database "Test" that is possible to navigate and do changes in...

Options: ReplyQuote
Re: phpmyAdmin wont work.
Posted by: hambuler (---.cpe.net.cable.rogers.com)
Date: March 08, 2008 09:34PM

Can you successfully open the mysql console and enter password if it asks?

Options: ReplyQuote
Re: phpmyAdmin wont work.
Posted by: wampit (---.tbcn.telia.com)
Date: March 08, 2008 10:31PM

I have not choosen any password and if I do this comes up. The same as when I go in on "localhost/phpmyadmin".

-----------
#2003 - Can't connect to MySQL server on 'localhost' (10061)
-----------

Options: ReplyQuote
Re: phpmyAdmin wont work.
Posted by: hambuler (---.cpe.net.cable.rogers.com)
Date: March 08, 2008 10:35PM

Check if the mysql server is running and listening on the default port 3306.

Options: ReplyQuote
Re: phpmyAdmin wont work.
Posted by: chpalmer (---.wavecable.com)
Date: March 08, 2008 10:48PM

Hi

Im having the same problem

I had netserver on this machine before

I have

080308 13:21:23 [ERROR] Default storage engine (InnoDcool smiley is not available
080308 13:21:23 [ERROR] Aborting

080308 13:21:23 [Note] wampmysqld: Shutdown complete

on the mysql log.

Going through the registry next...

Thanks

Options: ReplyQuote
Re: phpmyAdmin wont work.
Posted by: chpalmer (---.wavecable.com)
Date: March 08, 2008 10:54PM

Just did this and seems to be working now.

[forum.wampserver.com]

Options: ReplyQuote
Pages: 12Next
Current Page: 1 of 2


Sorry, only registered users may post in this forum.