Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2009
    Posts
    5

    Unanswered: 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

  2. #2
    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:
    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.
    Last edited by galih; 01-04-09 at 10:51.
    Forum Informatika - Indonesian Informatics Online Community - http://if.web.id

  3. #3
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    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 on the Tiger 800 or the Norton

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •