mysql remote connection

[ehcpdeveloper]

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)

Restored from old drupal forum, for user uid:1 username:ehcpdeveloper
You may reset your password to access your new account here.

[ehcpdeveloper]

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;


Restored from old drupal forum, for user uid:1 username:ehcpdeveloper
You may reset your password to access your new account here.

[Andy Jordaan]

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



Restored from old drupal forum, for user uid:1 username:ehcpdeveloper
You may reset your password to access your new account here.