Remote mysql

[peshte]

Hi.
I see that the remote mysql is activated by default for all users.
Is this safe?

[MyKEcz]

It's not recommended to have open mysql port to world, just for specific IP address for example via IPTables.

[fremeni]

Hi, on your guide i've found this command that connect an external mysql db server
v-add-database-host mysql new-server.com root password

When i lunch it, filled with my datas, centos answer me "bash: list-database-hosts: command not found"

Where is my mistake?

[peshte]

It's not recommended to have open mysql port to world, just for specific IP address for example via IPTables.

So I was tough.
By default, the remote mysql is open to the world.

[imperio]

Hi,

When i lunch it, filled with my datas, centos answer me "bash: list-database-hosts: command not found"
Where is my mistake?

try to specify the full path to the command

Code: Select all

sudo /usr/local/vesta/bin/v-list-database-hosts

[fremeni]

Hi All,

The command now works, but on rackspace for example, vesta save the db information in panel but don't create the db on rackspace cloud db.

Any suggestion?