joomla remote mysql administration

I am using the Joomla appliance and would like to use Navicat to administer the Mysql db. I've put a route in the Firewall but i'm still unable to conncect.

Please help.

Glen,

Replies (7)

thanks for reporting this

Reply 1 2009-04-27

the 'backstage' mysql.user host will be removed from all lamp based appliances released from this point on.

go to webadmin, then mysql

Reply 2 2009-04-26

go to webadmin, then mysql administration, then create a user account. you think specify what hosts the account can access from.

which hosts file are you referring to?

Reply 3 2009-04-26

can you post the path?

the issue is the hosts.

Reply 4 2009-04-26

the issue is the hosts. root only has local host, backstagej, and 127.0.0.1. I created a new account and assigned it a host of "any"

Glad it works, although...

Reply 5 2009-04-26

Glad it works, although it doesn't make sense to me how it would - unless navicat tunnels connections over ssh or something similar.

the issue was for some reson

Reply 6 2009-04-26

the issue was for some reson "root" did not have access to remotely administer the db. I create a new account with full to all db instances and it worked.

MySQL is bound to localhost by default

Reply 7 2009-04-26

By commenting out the bind-address in the MySQL configuration, it will bind to all interfaces.

sed -i "s/^bind-address/#bind-address/" /etc/mysql/my.cnf