TurnKey Linux Virtual Appliance Library

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,

Alon Swartz's picture

MySQL is bound to localhost by default

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

the issue was for some reson

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...

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 is the hosts.

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

which hosts file are you referring to?

can you post the path?

go to webadmin, then mysql

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

thanks for reporting this

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

Post new comment

The content of this field is kept private and will not be shown publicly. If you have a Gravatar account, used to display your avatar.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <a> <p> <span> <div> <h1> <h2> <h3> <h4> <h5> <h6> <img> <map> <area> <hr> <br> <br /> <ul> <ol> <li> <dl> <dt> <dd> <table> <tr> <td> <em> <b> <u> <i> <strong> <font> <del> <ins> <sub> <sup> <quote> <blockquote> <pre> <address> <code> <cite> <strike> <caption>

More information about formatting options

Leave this field empty. It's part of a security mechanism.
(Dear spammers: moderators are notified of all new posts. Spam is deleted immediately)