Quote Originally Posted by Lightning
Yes MSX one can't set row privileges using MySQL, i don't see any reason for that anyway
You don't see any reason ?! What about data protection or privacy ? Let's say you have a table with your customers ordering. A customer certain can read all it's orders and change them. So he can now read and change all other customers orders ? I don't think so.
At most, they have phpMyAdmin installed. (which again run on the web server)

Quote Originally Posted by Lightning
i had no problems connecting anywhere, let's say i have MySQL on www.mywebsite.org, that website also has an IP wich may change and that is the IP of the host where MySQL runs, you can connect to that MySQL server using a valid user+password and the host name, check the MySQL manual for more details on remote connections.
Ok, but you connect through a PHP page, and that php page runs on the server, so it's a connection from the web server to the database server, which are on the same network (or even the same machine).
I hardly think that mywebsite leave open access to the database. No web provider i've ever used do this.

MSX, if you have any DB server installed on your PC, try connecting using your internet connection's IP, you can obtain it by typing ipconfig in the console(dos command prompt), once a connection is established disconnect from the web and try to send commands to your DB server, you can't, but once you reactivate the connection you can send commands again, now try using your machine's name, localhost, another machine's name/IP, a website, they all work !!!
That doesn't make any sense. DB server and Web server are separate things.
The fact that you can connect to the database in you machine from everywhere is probably becouse it's misconfigured.