Win a copy of TDD for a Shopping Website LiveProject this week in the Testing forum!
    Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Paul Clapham
  • Ron McLeod
  • Jeanne Boyarsky
  • Tim Cooke
Sheriffs:
  • Liutauras Vilda
  • paul wheaton
  • Henry Wong
Saloon Keepers:
  • Tim Moores
  • Tim Holloway
  • Stephan van Hulst
  • Carey Brown
  • Frits Walraven
Bartenders:
  • Piet Souris
  • Himai Minh

MySQL localhost

 
Greenhorn
Posts: 8
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Report post to moderator
when I run mysql it displays the following error

c:\Sun\AppServer\mysql\bin>mysql
ERROR 2003 <HY000): Can't connect to MySQL server on 'localhost' <10061>

from where can I can get this localhost

thanks
 
Ranch Hand
Posts: 2908
1
Spring Java Ubuntu
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Report post to moderator
localhost is your local machine and MySQl server instance by default runs on port 3306, so checkout if that port is opened and any service is running on it. Use netstat command from command prompt to check any process running on port 3306.
 
Ranch Hand
Posts: 263
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Report post to moderator
Also check this out, it talks about such problems:

http://qnatech.wordpress.com/category/mysql/
 
Bartender
Posts: 2661
19
Netbeans IDE C++ Linux
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Report post to moderator
Indeed, most likely you don't have MySQL running on your machine.
Does it work if you replace localhost by 127.0.0.1 in your connect string?

Note that mysql is not the way to start MySQL.
mysql is a query tool, not a database startup tool.

Info: http://dev.mysql.com/doc/refman/5.0/en/windows-start-command-line.html

Regards, Jan
 
Ranch Hand
Posts: 367
Eclipse IDE Opera Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Report post to moderator
Hello All,

I'm trying to install MySQL on my laptop.

When I installed it successfully, my code didn't show the desired answer.
so I removed and reinstalled MySQL and since then, even if I enter correct existing password followed by new password and confirm it.
It shows me Error no 2003, "Can't connect to MySQL server on localhost(10061).
I checked the process MySQL, but it stops within a moment after starting through control panel.

when I do the same through command prompt by giving sc qc MySQL, it shows me access denied when I'm the admin of the machine.

Please help.

Unfortunately I'm unable to attache word file here ...
 
Jan Cumps
Bartender
Posts: 2661
19
Netbeans IDE C++ Linux
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Report post to moderator
Hi pramod .
Please create a separate post for your problem.


edit: typo
 
Are you okay? You look a little big. Maybe this tiny ad will help:
Free, earth friendly heat - from the CodeRanch trailboss
https://www.kickstarter.com/projects/paulwheaton/free-heat
    Bookmark Topic Watch Topic
  • New Topic