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.

I am following the MySQL tutorial here at SitePoint, but I am having trouble getting a database ready. Lucky for me, my provider supports MySQL, so I mailed them and asked for an account. I got my account information, and tried to log in with MySQL using www.telefragged.com as server (my hosting provider) and my username. I typed in the correct password, but then I get an error message saying my ISP is not allowed to connect to it. (ERROR 2003: Host 'apollo-hrlm0711.multiweb.net' is not allowed to connect to this MySQL server)

So I mailed the system admins. Their reply:
"only the telefragged server can connect"

So I asked them what possible use the database could be if you can only access it from the host server.

Their reply:
"www.php.net
that is how I do all my db connections
or <A HREF="http://www.phpwizard.net"" TARGET=_blank>www.phpwizard.net"</A>

Go to http://www.phpwizard.net and download phpMyAdmin. Insert your password into the config files and upload the files to a directory on your ISPs computer. Now you will have access to your mySQL database.

Christian

------------------
Axie automatically performs free, customizable searches for new
websites and delivers the links to members by personalized email.http://www.axie.com/

No telnet access and no remote client access? Wow -- that ISP definitely needs a talking-to. PHPMyAdmin will certainly do the trick for now, but some experience with the SQL command line will come in handy when it comes time to start accessing that database in your own PHP scripts. You might want to set up MySQL by itself on your own computer just to play around with it a little and go through the examples in Part II of my series.