Page 1 of 1
cannot connect mysql in lan using the program delphi with component mydac
Posted: Fri 30 May 2008 20:50
by John80
I tried to connect to mysql in lan using the delphi with Mydac components , the server name is given as 192.168.0.1 , and the correct password, user as root . In the local computer when I use localhost as servername and user/password: root it works , but using localhost computer ip address 192.168.0.1 in the same PC or another in LAN it doesnt work. I am using xp , ports opened for 3306, 80, and disabled firewall but I no success. Any idea?
Thanks
Posted: Mon 02 Jun 2008 13:28
by jkuiper_them
Normally you don't use an ip address when you connecting to a local pc. 127.0.0.1 is a lookback driver and goes directory to your tcp/ip connection without using the network.
Do you have another pc to ping you pc?
Can you connect with mysql browser to the mysqlserver?
Can you connect with another pc with mysql browser to the mysqlserver?
Posted: Mon 02 Jun 2008 13:55
by Antaeus
If you connect to MySQL using 'localhost' in your connection settings, you need permissions for 'user_name'@'localhost'. But when you connect to the same server from the same application using the name of your computer, you need permissions for 'user_name'@'your_computer_name'. So you need to grant privileges for the 'user_name'@'your_computer_name' user to use your computer name in the connection settings.
If this does not help, specify the exact error message you get when connection fails.