PHP & mySQL

connection problem

[esha_salz]

I cant connect to my MySQL database from my own computer?
How do i do it?
N what bout the localhost?
I am using my school's wireless network which has no IP address.. cos its configured automatically..

[coopster]

Where is the MySQL server running? On your own computer or on a different computer on the network?

[ergophobe]

Most shared hosts will only allow connections from specified IPs (and it's likely that those IPs will be localhost and perhaps a couple for sysadmins to use). Many shared hosts will also allow connections only via certain protocols as well.

So you likely have two choices:

If this is for development purposes, you should install the DB server on your computer and use that.

If you want real-time access to the db, you'll need to connect to it. Popular ways are
- log in via SSH and start the default mysql client
- install phpMyAdmin and use that to connect
- build an interface using PHP or something like it.

Usually, both the default client and phpMyAdmin will be installed on a shared web server somewhere. phpMyAdmin is great for a quick little thing when you have your browser open already, but if you need to do a lot of work, it is frustratingly slow. The default client is super fast, but you need to know some SQL to do much of anything with it.

Depending on which way you want to go, we can offer additional help.

Tom