MySQL - Cant connect to server 127.0.0.1 (10051)

[Raghavendra Shockley]

I tried to manage a DB connection and now I get this error. How do I get rid of it ? Do you find MySql confusing and less user friendly as compared to MS-SQL ?

[Mohana Rao Sv]

Are you able to connect to mySQL directly?

[Raghavendra Shockley]

Mohana Rao Sv wrote:Are you able to connect to mySQL directly?

I am a complete newbie to databases and sql. I am learning it to do jdbc stuff. So, I am not able to understand the meaning of your question. Please tell me how this mysql works. I tried MS-SQL and it was much easier. But most tutorials use this complicated mysql, that is why i am forced to use it.

[Ireneusz Kordal]

Run mysql command from the command line and check if it connects to the database properly.
What operating system are you using ? WIndows, unix ?
Check if the database server is started, if not - start it.

Here is an example form my pc - I am using linux:

~$ mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

~$ sudo /etc/init.d/mysql start
[sudo] password for irko: 
Starting MySQL
...
irko@kokodrilko:~$ mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.6.4-m7-log MySQL Community Server (GPL)

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> select 1 + 2;
+-------+
| 1 + 2 |
+-------+
|     3 |
+-------+
1 row in set (0.02 sec)

[Raghavendra Shockley]

Resolved! Thanks!