The SitePoint Forums have moved.

You can now find them here.
This forum is now closed to new posts, but you can browse existing content.
You can find out more information about the move and how to open a new account (if necessary) here.
If you get stuck you can get support by emailing forums@sitepoint.com

If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Allowing remote access to MYSQL

I've searched for a solution for this but can't seem to get a straight answer.
My host told me that since our MYSQL is now installed we need to enable access remotely. Can anyone help me out with this one? Can't seem to get on MYSQL.com at the moment. But didn't really find anything there earlier.

Well, if you're using Windows at home/work, you could download MyODBC from MySQL.com and set that up with your host's IP address. Then you should be able to use whatever database administration tool you want to on it.

There's also a script called phpMyAdmin that you can install on your web server which will allow you to manipulate the database through a web interface.

I guess the big two questions are:
1) What operating system does your host use?
2) What operating system do you use?

Actually, after doing some research I think I need to reword my problem. MYSQL is installed on the Apache server, I even have phpmyadmin setup and running. I don't think the problem is with MYSQL but with PHP. (But I really don't know what I'm doing )

I'm using Dreamweaver MX to create a webpage. I can access the database but when I try to create a recordset I get an undefined error. I'm thinking that Dreamweaver attempts to write to a file on the server but can't.

I found something that said we need to enable remote access to files from within the php config file. That's what I'm working on now. But first I want to upgrade php, the server is running php 4.0.1 and I think the newest version is PHP 4.2.1