I installed Navicat in my system for accessing the database by Graphical User Interface.
I created the database in PHP MyAdmin. Now I accessed this database through Navicat.
After some time, I again accessed the database through Navicat but I am receiving the below error.
Please tell me its solution.
Error detail is give below for your understanding.
2003 – Can’t connect to MySQL server on ‘localhost’ (10061)
OK
Error 2003 while accessing Database in Navicat
Hi,
If you have a problem with that, then you can try Xampp software to create and access SQL server. Its also graphical. In this case you can use XAMPP as your SQL server. It is not so difficult.
Just go to this link and download XAMPP for free and then install it.
First it will extract in one of your hard drives. Then install it.
It is really simple just like other software installation process. After finishing its installation process run XAMPP’s control panel. You will see this type of Windows.
Here just click on start button, which is located beside My SQL. It will run SQL server in your computer.
Then browse it in your browser by using : http://localhost/phpmyadmin.com
Then create a database with it.
Error 2003 while accessing Database in Navicat
If you are unable to connect to your SQL Server please try to apply this code for connection to connect to you SQL Server. In the code you have to change your localhost name, your username, and password . This is very simple PHP code and you can use it every where by just including it to you page. The code is given below.
<?php
$con = mysql_connect("localhost","peter","abc123");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
?>
use this code, this will help you a lot. I have tried it by myself, it helped me a lot in many pages.
