mysql remote connection

to connect to a local db, just use "localhost" as mysql host
to connect to a remote db, use remote ip (real external ip of server)

however, to connect to a mysql from remote, you need to do some settings in mysql.
open my.cnf,
bind-address = 127.0.0.1, 88.33.44.55 (your external real ip)
after that, you need to give your user to connect from outside mysql server.

open mysql console (or do in phpmyadmin, privileges)
grant all privileges on db.* to user@'yourip' identified by 'pass';
flush privileges;

(if you have firewall, you need to open port 3306)

Forums: 

additional/another info:

to connect to a local db, just use "localhost" as mysql host
to connect to a remote db, use remote ip (real external ip of server)

however, to connect to a mysql from remote, you need to do some settings in mysql.
open my.cnf,
bind-address = 127.0.0.1, 88.33.44.55 (your external real ip)
after that, you need to give your user to connect from outside mysql server.

open mysql console (or do in phpmyadmin, privileges)
grant all privileges on db.* to user@'yourip' identified by 'pass';
flush privileges;

Be awake here !!

The developer says open my.cnf then fix the VPS to change the bind ( bind-address = 127.0.0.1 ) to the VPS fixed IP
address,

All documentation on the web says its under [mysqld] yes it is.
BUT
further DOWN ehcp added another, Two days later I stumbled on it , a simple Edit and I was connected !!

Andy