Problem in MySql
Hello every one,
i have format my system and after that i have installed mysql in my system when i m connecting to mysql from my server then its not connected .but i putted the right HostName="192.168.1.3" this is my Server IP address . Do you have any idea how to solve my problem then please let me know . please its too urgent thanks in Advance........
Kirtan PatelPosted Nov 17, 2009, 7:42 AM
Are you Accecing MySQl that is installed in local Computer .and accessing it from same computer ??
if so then use
127.0.0.1 as IP and User Name =root and password = ""
this will resolve your problem
if it solves your problem then check "Do you like this answer" check box :)
if still having problem them let me know and also post code you are using to connect MySql :)
and if you are using Simply ODBC Connection then dont use it
use MySQL Connector instead
Download My SQL Connector From Here
after installation you will have new name space
System.Data.MySQLClient then use it like SQL Server Programming .
Kirtan PatelPosted Nov 18, 2009, 11:44 AM
May be your Firewall is Blocking the connection check it too :)
Naeem KhanPosted Nov 17, 2009, 1:55 PM
SreekanthPosted Nov 17, 2009, 9:14 AM
Nilanka DharmadasaPosted Nov 17, 2009, 8:19 AM
What is the exact error you get? Are you getting an error meesage?
You might be able to get a help from this link.
http://dev.mysql.com/doc/refman/5.1/en/can-not-connect-to-server.html#can-not-connect-to-server-on-windows