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.
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.
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.