Enable remote access on Joomla Jumpbox Database

We have to enable remote access on a joomla jumpbox db in order to access it from the GUI tools which are installed on my actual machine (While jumpbox is in a VM on my actual machine)

On your VMWare player, click Alt + F1 to go to the console:

In console, write the following to get the root password:

sudo grep root /jumpbox/lib/appdata.yml

You will see a line such as the following:

root: pa$$word

where pa$$word is the password of your root user

To start using the db as the root user:

mysql -u root -p
#or
mysql -u root -ppa$$word

 

In order to allow remote access on the database, do the following:

sudo nano /etc/mysql/my.cnf

Find the bind-address property, and replace it with the IP of your jumpbox

e.g. I modified

#bind-address           = 127.0.0.1

to

#bind-address = 192.168.1.36

Restart mysql:

sudo /etc/init.d/mysql restart

Now grant all privileges to a remote db user

GRANT ALL PRIVILEGES ON *.* TO ria@'%' IDENTIFIED BY 'ria0';

where ria is the user name, and ria0 is the password of a remote user (this user need not be already existing in the db, it creates a new user if it does not exist)

Now download the GUI tools for mysql and try accessing the db using

db host: 192.168.1.36 (your jumpbox host)

user: ria

pw: ria0

I started receiving an error saying

host 'mycomputername' is not allowed to access this mysql

(I dont remember the exact error string sorry)

To solve this problem, i went back to the console and ran this command:

GRANT ALL PRIVILEGES ON *.* TO ria@'mycomputername' IDENTIFIED BY 'ria0';

(We can also use IP of the external machine instead of the computer name)

Now you will be able to access the joomla jumpbox database externally.

http://wiki.jumpbox.com/doc/runtime/faq/access_mysql

http://www.jumpbox.com/node/1101

http://www.cyberciti.biz/tips/how-do-i-enable-remote-access-to-mysql-database-server.html