Even though Navicat has an SSH option, it didn't work for me. Thanks for some help from #linode and
other tuts out there I was able to get this to work
SSH to your linode and forward local port 13306 to your linode's mysql port 3306
Code:
ssh -L13306:127.0.0.1:3306 host@yourLinodeIP
Fire up mysql with the user and database you want to access (you'll be prompted for password)
Code:
mysql -u database_username -p database_name
Now fire up you local Navicat application. Set the following in the connection settings:
Code:
Connection Name: whatever
Host name/ IP address: localhost
Port: 13306
Username: (your database username)
Password: (your database password)
Hit the 'Test Connection' button to see if you succeeded
Now the next step would be to set up a script to automate this.
Edit: Fixed thread title
FAQ
Search
Members
Register
Login [ Anonymous ]
