not able to use mysql server
am 30.12.2009 07:11:55 von Sudhakar
--0016e64ce5a2ed9daa047bec034e
Content-Type: text/plain; charset=ISO-8859-1
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.
--0016e64ce5a2ed9daa047bec034e--
Re: not able to use mysql server
am 30.12.2009 07:40:16 von Jignesh Thummar
--0016e64be8e85a46a2047bec692a
Content-Type: text/plain; charset=ISO-8859-1
It is problem with mysql client, it's not able to connect with mysql server.
Either mysql server is not running or windows firewall is blocking to the
access of port 3306. Try to disable firewall.
-Jignesh
On Wed, Dec 30, 2009 at 11:41 AM, Sudhakar wrote:
> 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.
>
--0016e64be8e85a46a2047bec692a--
Re: not able to use mysql server
am 30.12.2009 15:44:03 von Eric Lee
--00163623ac5c75af3d047bf32b2b
Content-Type: text/plain; charset=UTF-8
On 12/30/09, Jignesh Thummar wrote:
>
> It is problem with mysql client, it's not able to connect with mysql
> server.
> Either mysql server is not running or windows firewall is blocking to the
> access of port 3306. Try to disable firewall.
>
> -Jignesh
>
> On Wed, Dec 30, 2009 at 11:41 AM, Sudhakar
> wrote:
>
> > 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.
> >
>
Are there any error entries of mysql server on the event viewer ?
Also, what is the starting state of mysql server on the services console ?
You can found all tool on administrative folder on the start menu.
--00163623ac5c75af3d047bf32b2b--