If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > MySQL > Getting ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 01-01-09, 23:43
neeraj_khandelwal neeraj_khandelwal is offline
Registered User
 
Join Date: Jan 2009
Posts: 5
Getting ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)

Can someone help me to overcome to problem when using mysql
"ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)"

I installed the mysql and using it and after rebooting of my system it generated an error "ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)".

Thanks!
Neeraj
Reply With Quote
  #2 (permalink)  
Old 01-04-09, 09:24
galih galih is offline
Registered User
 
Join Date: Feb 2008
Location: Bandung - Indonesia
Posts: 15
I think the problem is on your mysql - user table.
Maybe its corrupted, so the mysql server can't run properly.

1. Uninstall your mysql
2. Dont forget to delete manually DATA folder on its directory that keeps the mysql database.... if you have something important data, please backup first. Or you can just delete the mysql folder on data folder. No require to delete data folder.
3. Install fresh mysql
4. If succeed, please backup the mysql folder on data folder.

Some of the contents are:
Quote:
columns_priv.frm
columns_priv.MYD
columns_priv.MYI
db.frm
db.MYD
db.MYI
func.frm
func.MYD
func.MYI
help_category.frm
help_category.MYD
help_category.MYI
help_keyword.frm
help_keyword.MYD
help_keyword.MYI
help_relation.frm
help_relation.MYD
help_relation.MYI
help_topic.frm
help_topic.MYD
help_topic.MYI
host.frm
host.MYD
host.MYI
proc.frm
proc.MYD
proc.MYI
procs_priv.frm
procs_priv.MYD
procs_priv.MYI
tables_priv.frm
tables_priv.MYD
tables_priv.MYI
time_zone.frm
time_zone.MYD
time_zone.MYI
time_zone_leap_second.frm
time_zone_leap_second.MYD
time_zone_leap_second.MYI
time_zone_name.frm
time_zone_name.MYD
time_zone_name.MYI
time_zone_transition.frm
time_zone_transition.MYD
time_zone_transition.MYI
time_zone_transition_type.frm
time_zone_transition_type.MYD
time_zone_transition_type.MYI
user.frm
user.MYD
user.MYI
5. When sometimes you've got the same error, please shutdown the mysql service, then put & rewrite the mysql folder that we backup on your data folder.

I hope you understand what i try to write here.
Sorry for my ackward English.
__________________
Forum Informatika - Indonesian Informatics Online Community - http://if.web.id

Last edited by galih; 01-04-09 at 09:51.
Reply With Quote
  #3 (permalink)  
Old 01-04-09, 09:45
healdem healdem is online now
Jaded Developer
 
Join Date: Nov 2004
Location: out on a limb
Posts: 9,262
that error message suggests to me that the MySQL server isn't active, or there is something between the applciation and the server tha is blocking connection (eg a firewall or proxy server/ NAS)

so I'd want to first of all prove MySQL is actaully running
in windows look for a process called mysqld-nt.exe
in Linux lookat the system services and look for MySQL

if you are running a firewall make sure the specified port is open (usually MySQL runs on 3306

if thats working then I'd suggest you download the mySQL graphical tools from the MySQL site and see if either query browser and or Adminstrator can connect to the specified server.

after that it cvould be the app is not looking for the correct mYSQL server.... ie there are some config steps needed to get the app to talk to the required server.

if your server isn't on the same machine as the application that is generating the localhost message then its a config issue.
__________________
I'd rather be riding my Versys or my Tiger 800 let alone the Norton
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On