0
votes
0answers
16 views

Am I using this command correctly? Can't understand why I get the error I am getting. Myqsl - Centos 6

So, I am trying to connect to a database through mysql ssh, but whenever I run the command Connect postfix@127.0.0.1 on postfix It returns with: ERROR 2005 (HY000): Unknown MySQL server host 'on' ...
0
votes
2answers
98 views

Command-line access to remote MySQL server

I administer a website on a remote, shared host. My web host offers MySQL, and I am able to access this from my Mac OS X computer using a GUI program, Sequel Pro. That works great. But I want to ...
0
votes
2answers
59 views

mysql, ssh, rsync, git hang with dns name but not IP address on Ubuntu 12.04

Certain network based programs recently (problem did not exist a couple of weeks ago) started hanging for me. Some that I've experienced the problem with are mysql, ssh, rsync, and git. My first ...
1
vote
2answers
234 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
263 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
28 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
296 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
1k 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
162 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
152 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
118 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
116 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
533 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
327 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
706 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
434 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: ...
5
votes
3answers
2k 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
888 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
577 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
833 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 ...