1
vote
2answers
167 views

How to connect local apps (i.e. rubymine, prosequel) to remote server using AWS private key?

Programs that allow remote connections (usually in ssh) typically request a user name/pwd to connect to a remote server: see the below examples from sequelpro and rubymine, respectively: Sequel pro: ...
0
votes
0answers
39 views

Unable to connect to the server via SSH and MySQL

I have the following network structure: Server has multiple Ethernet ports, PC1 connected to the first one and a router is connected to the second Ethernet port. From PC1 I can connect to the ...
0
votes
0answers
194 views

mysqldump to local mysql database through ssh

This command: ssh bruchowski@www.example.com 'mysqldump -u bruchowski -p dbname' > mysql -u root dbname Produces this error: mysqldump: Got error: 1045: Access denied for user ...
0
votes
1answer
27 views

How to make the Delete key work in mysql prompt?

I use Putty to connect to a Linux machine from a Windows machine via ssh. The keyboard works just fine in Bash. But in the mySQL prompt, the Del key prints a ~ intsead of erasing a character. Any ...
0
votes
1answer
256 views

unable to connect to mysql over ssh tunnel to virtual machine

my setup host: win 7 guest : opensuse [10.0.2.15] Ports forwarded 80, 22 from 127.0.0.1 to 10.0.2.15 Connection to VM using winscp with user@127.0.0.1:22 using public key authentication is working. I ...
0
votes
1answer
596 views

Can I output results of a MySQL query to a Excel file via Putty?

I'm on a local windows machine. The MySQL DB is on a CentOS machine elsewhere on the same local network. I want to output the results of the query that I'm typing directly into Putty into an Excel (or ...
0
votes
3answers
148 views

Home Web Server Server Does Not Correctly Respond to SSH, MySQL, etc

I am attempting to setup my home web server (Ubuntu Server 12.04) such that I can ssh to it from outside of my home network as well as connect to the MySQL databases that I have created on it. ...
1
vote
4answers
119 views

Accessing a mySQL database on an external server

I have a large (multi-gigabyte) SQL database on an external server. I can access it through SSH, but manually querying the data will be a major pain. I really need a GUI. I'm using Ubuntu 13.04, but ...
0
votes
1answer
108 views

mysql and ssh tunnel

I got some troubles establishing connect to remote database via ssh tunnel. Open ssh tunnel ssh -fNg -L 3307:127.0.0.1:3306 user@remote-host Check it netstat -lep --tcp All OK tcp 0 0 *:3307 ...
1
vote
1answer
111 views

MySQL access database through remote machine without user access

I'm trying to access a MySQL database on a remote machine. I do not have user access to the machine that the server is running on, but I do have access to another remote machine on the same network. ...
0
votes
1answer
477 views

How to config putty remote port forwarding to connect mysql?

I installed MySQL to a Windows box. I want to connect it from a Linux box. I run plink to setup a remote port forwarding in Windows box. I try to connect it from Linux box, but it's not working. ...
0
votes
2answers
2k views

Trying to Set Up SSH Tunneling To MySQL Server for MySQL Query Browser

I'm trying to set up SSH tunneling on a remote web server to another MySQL server so that the database can be browsed easily with MySQL Query Browser. I'm following this page but cannot connect to the ...
1
vote
1answer
301 views

Remote restore gz mysql database

I tried $> ssh root@ip "gunzip < [backupfile.sql.gz] | \ mysql -u [uname] -p[pass] [dbname]"` but get the error: ERROR 1044 (42000) at line 42: Access denied for user '[uname]'@'%' ...
0
votes
1answer
593 views

Import a local SQL File To a Remote Server Using SSH Tunnel

I have a connection between my localhost and a remote server using putty SSH tunnel. Thats fine. Now I need a command to get the sql file on my local machine i.e. c:\folder\test.sql and import it ...
2
votes
2answers
365 views

How to connect MySQL database through two SSH hosts

How do I connect to MySQL database through two SSH hosts ? Here is my situation: I have two SSH hosts as show below. MySQL is running in BOX2 host. MyBox(GUI client) -----SSH(port 22)--->BOX1(IP: ...
4
votes
3answers
1k views

How to script a database migration using an SSH tunnel?

I am trying to create a sync.sh script that coordinates with our less-than-ideal version control for our website. This script will migrate a live copy of the database to our development environment ...
3
votes
2answers
2k views

connecting to mysql over ssh

All the computers involved are Mac OS X 10.6.x machines. I am on computer A, and have mysql running on it, and can connect to it as A~ $ mysql -u punkish -p database and so on. I have access to ...
0
votes
1answer
833 views

Using ssh port tunneling to connect to mysql server from home

I'm using SqlYog and PUTTY in order to connect to a MySQL server sitting on a remote server. I'm able to the MySQL server sitting on the host I connect to through PUTTY, but the thing is I use PUTTY ...
1
vote
1answer
559 views

mac os x connect to mysql via ssh in drupal

I am on a mac os 10 and I want to connect a local copy of a drupal site to a remote mysql data. I can access the server using ssh as root, the database is setup and running, how can I connect to the ...
1
vote
4answers
763 views

Cross platform centralized password manager [duplicate]

Possible Duplicates: Password manager for multiple computers? Cross-platform centralized desktop password manager Do any of you know a password manager, that would maybe look a bit like ...
2
votes
2answers
3k views

Why isn't my port forwarding with mysql working on my server?

I have a mysql server running on some server in our network. Now, only connections from localhost are accepted by the server and I can't connect to it remotely. Now, I want to set up a port ...