Facing database MySQL problem.

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
ian163
Forum Newbie
Posts: 7
Joined: Fri May 02, 2008 8:55 am

Facing database MySQL problem.

Post by ian163 »

After installing Apache, PHP and MySQL. When I try to start MySQL from DOS base, I found a below error message : -
E:\WebServer\mysql\bin>mysql
ERROR 2003: Can't connect to MySQL server on 'localhost' (10061)

Please help me .......
josh
DevNet Master
Posts: 4872
Joined: Wed Feb 11, 2004 3:23 pm
Location: Palm beach, Florida

Re: Facing database MySQL problem.

Post by josh »

mysql is the client, mysqld is the "server"
User avatar
califdon
Jack of Zircons
Posts: 4484
Joined: Thu Nov 09, 2006 8:30 pm
Location: California, USA

Re: Facing database MySQL problem.

Post by califdon »

As jshpro2 said, mysql is the command line client, but if it can't connect to your database, perhaps the mysql server is not running. You need to either explicitly start the server (from Start menu, Run, enter msconfig, go to Services tab) or set it up to start on Windows boot.
User avatar
jayshields
DevNet Resident
Posts: 1912
Joined: Mon Aug 22, 2005 12:11 pm
Location: Leeds/Manchester, England

Re: Facing database MySQL problem.

Post by jayshields »

califdon wrote:from Start menu, Run, enter msconfig, go to Services tab
Just a heads up - you can also type "services.msc" into the Run prompt to get the services menu. Also, can launch Run with Windows key + R.
User avatar
califdon
Jack of Zircons
Posts: 4484
Joined: Thu Nov 09, 2006 8:30 pm
Location: California, USA

Re: Facing database MySQL problem.

Post by califdon »

jayshields wrote:
califdon wrote:from Start menu, Run, enter msconfig, go to Services tab
Just a heads up - you can also type "services.msc" into the Run prompt to get the services menu. Also, can launch Run with Windows key + R.
Good points. I always forget those other routes, since I don't use them very often.
ian163
Forum Newbie
Posts: 7
Joined: Fri May 02, 2008 8:55 am

Re: Facing database MySQL problem.

Post by ian163 »

Thanks guys.

Try start from services.msc, still can't work.
Below error msg display :-

Could not start MYSQL service on Local Computer.
ERROR 1067 : The process terminated unexpectedly.

So, what so I need to do next.
josh
DevNet Master
Posts: 4872
Joined: Wed Feb 11, 2004 3:23 pm
Location: Palm beach, Florida

Re: Facing database MySQL problem.

Post by josh »

Un-do whatever you last did / check error logs / re-configure mysql / re-install mysql
Post Reply