error with mysql

Sudhakar

unread,

Dec 30, 2009, 1:23:23 AM12/30/09

to

hi

i am using windows vista and installed wamp server, initially i
installed wamp and accessed phpmyadmin and while setting a password
for the root i did a mistake and could not access phpmyadmin and also
renamed some php files so i uninstalled wamp server and re installed

now the problem i am facing is when i click on mysql.exe located at D:
\wamp\bin\mysql\mysql5.1.36\bin i am getting the following error
error 2003 cant connect to Mysql server on localhost 10061

in config.inc.php located at d:\wamp\apps\phpmyadmin3.2.0.1 i have the
following
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['port'] = '3306';
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'root';
$cfg['Servers'][$i]['AllowNoPassword'] = true;

along with others.

when i type http://localhost i am able to see the welcome screen of
wamp and can click on phpinfo but when i click on phpmyadmin it takes
a while to load and a blank screen appears

also i have stopped all services and restarted all services from the
wampserver icon in the system tray, normally the colors change from
red to yellow to white, the color is at yellow and does not change to
white

how do i solve the error error 2003 cant connect to Mysql server on
localhost 10061 so that i can use phpmyadmin

please advice.

thanks.

Michael Fesser

unread,

Dec 30, 2009, 3:17:15 AM12/30/09

to

.oO(Sudhakar)

>i am using windows vista and installed wamp server, initially i
>installed wamp and accessed phpmyadmin and while setting a password
>for the root i did a mistake and could not access phpmyadmin and also
>renamed some php files so i uninstalled wamp server and re installed

There are better ways to reset a forgotten root password. Reinstalling
everything seems to be the typical way for many Windows users, but it's
almost never really necessary and just causes a lot more work.

>now the problem i am facing is when i click on mysql.exe located at D:
>\wamp\bin\mysql\mysql5.1.36\bin i am getting the following error
>error 2003 cant connect to Mysql server on localhost 10061

Most obvious question: Is the MySQL server running? mysql.exe is just a
command line client, and if there's no server running and listening, it
won't be able to connect.

But for further discussion you should choose a more appropriate
newsgroup, since this has nothing to do with PHP.

Micha

Richard

unread,

Dec 30, 2009, 4:20:57 PM12/30/09

to

"Sudhakar" <sudhak...@gmail.com> wrote in message
news:07e3e41c-c802-4e49...@m16g2000yqc.googlegroups.com...

> hi
>
> i am using windows vista and installed wamp server, initially i
> installed wamp and accessed phpmyadmin and while setting a password
> for the root i did a mistake and could not access phpmyadmin and
> also
> renamed some php files so i uninstalled wamp server and re installed
>
> now the problem i am facing is when i click on mysql.exe located at
> D:
> \wamp\bin\mysql\mysql5.1.36\bin i am getting the following error
> error 2003 cant connect to Mysql server on localhost 10061
>

.. snip

With WAMP, there is no need to start mySQL manually.
If you just start it, all will be handled for you.

IF the install is correct of course.

R.