Search code examples
mysqllocalhostsqlyog

Connecting to MYSQL Server from SQL Yog

I know this question has been asked many times, but I couldn't solve my problem after seeing all the relevant questions.

I had installed Visual Studio 2012 Express edition on my Windows 7 Dell Inspiron laptop. So, Microsoft SQL Server was automatically installed along with it.

After that, I installed SQL Yog Community Edition. After starting it for the first time, I tried to connect to the MYSQL Host. I kept the information as it is, namely,

MySQL Host Address: localhost
Username: root
Port: 3306

I did not put any password.
After doing all this, when I said Connect, it gives the following error:

"Error No. 2003 Can't connect to MySQL Server on 'localhost' (10061)"

After all this, I thought the problem was with the installation of SQL on my machine. Hence I downloaded Microsoft SQL Server 2012 Express Edition and installed it. But still, SQL Yog is facing the same problem.

What should I do?

Solution
    • You should check that MySQL server is started.
    • Check the default port, is it 3306?
    • The port may be forbidden, check the firewall if it is started.

    Try to test address - localhost:3306 with TELNET program -

    telnet localhost 3306