Forum: 

joomla remote mysql administration

gaorenst's picture

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,

Alon Swartz's picture

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
gaorenst's picture

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.
Alon Swartz's picture

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

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"
Alon Swartz's picture

can you post the path?
gaorenst's picture

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

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

Post new comment