gaorenst's picture
Submitted by gaorenst on Sun, 2009/04/26 - 00:38

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,

Forum: 
Support
Alon Swartz's picture

Alon Swartz - Sun, 2009/04/26 - 16:03
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

gaorenst - Sun, 2009/04/26 - 17:49
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

Alon Swartz - Sun, 2009/04/26 - 17:54
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

gaorenst - Sun, 2009/04/26 - 18:03
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

Alon Swartz - Sun, 2009/04/26 - 18:30
can you post the path?
gaorenst's picture

gaorenst - Sun, 2009/04/26 - 18:36
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

Alon Swartz - Mon, 2009/04/27 - 13:29
the 'backstage' mysql.user host will be removed from all lamp based appliances released from this point on.

Add new comment