Forum Moderators: mack
I got MySql running on remote server on win2k. I got phpadmin administering it. I would like to know how can I connect an aspx page to access data from the mysql database? I can run the page locally where the database is running but when I put it in a different server, I get stuck. please help
what do I have to change on the ASP page and on MySQL config?
From the bit I understand from your post, you might have set the mySQL-phpadmin parameters to only accept connections from 'localhost' which would prevent it from being accessed by another server.
You can check to see if that is indeed the case by looking through your config file, and then see if it is configured only for localhost or global access.
Perhaps you could let us know if that is it, or something else? :)
#Uncomment or Add only the keys that you know how works.
#Read the MySQL Manual for instructions
[mysqld]
basedir=C:/mysql
#bind-address= {some IP address}
datadir=C:/mysql/data
#language=C:/mysql/share/your language directory
#slow query log#=
#tmpdir#=
port=3306
#set-variable=key_buffer=16M
[WinMySQLadmin]
Server=C:/mysql/bin/mysqld-nt.exe
user={some username}
password={some password}
#bind-address= {some IP address}
So, then we move to your ASP script :) which is where my help ends, unfortunately - I don't do ASP.
If the connection is similar to perl / php, then you need to make sure you are connecting to the right IP addy, instead of localhost, for the connection...and, turn on 'debugging' it may give you some useful data.
Though perhaps an ASP person could give you a bit better piece of advice?
the db was on a commercial server so the port was blocked.
:))
Now I've to figure out how to connect ASP to the db
thanks
Because, in all honesty, if you're connecting an asp script to a db from a server that is a connection between 2 different servers, that doesn't exactly sound like a 'newbie' question. lol.
Quite a bit beyond me, in fact...
