How do I sign on to SSH?

[pmcinvest]

I've tried creating an ODBC link to my db with no success http://www.bluehostforum.com/showthread.php?t=4074

I've learned that SSH is the better way to connect.
I've read everything I could find on SSH in forums and Knowledge Base.

I try to log on with my url (sans www.), username (same as I log onto BH) and password (same as I log onto BH). SSH tells me I'm entering the wrong password for that username. ?????????????

I'm trying to log in on port 22 because I've read that is the port to use with SSH. But my db is on port 3306. Assuming I do connect someday, how do I connect to my db on port 3306 from a log in on port 22? Do I log on to port 3306 directly instead of port 22?

[cyberbofh]

Just one little remark... do you have ssh access??

You have to request ssh access to use it
See also: How can I get SSH/Shell access on my account? (http://helpdesk.bluehost.com/kb/index.php?x=&mod_id=2&id=203)

You can find more info in the Knowledgebase (http://helpdesk.bluehost.com/kb/index.php?kb_keywords=ssh&mod_id=2)

[pmcinvest]

I have requested and activated SSH. My question is what am I doing wrong in the Login? There is no login window unless SSH is activated. I've read the item you referenced. I've read every post containing "secure server" and "SSH" in both the forums and Knowledge Base. It's deja vu all over again?

[cyberbofh]

Hmm..
It seams you already have done a lot to get this working..
Dunno if it helps, but you can have a look at these webpages:
MySQL® Connector/ODBC (http://www.mysql.com/products/connector/odbc)
Using Excel to analyze MySQL data (http://searchopensource.techtarget.com/tip/0,289483,sid39_gci1192976,00.html?Offer=OSmbtip127 )
Connecting Excel to Linux databases (http://searchopensource.techtarget.com/tip/0,289483,sid39_gci1122668,00.html)http://www.awimb.com/fudforum/images/smiley_icons/thumbup.gif

[areidmtm]

To connect to a MySQL server with SSH, you have to create an SSH tunnel. You cannot (as far as I know) create an SSH with excel. You will have to download a program called Putty and then create one in there. But you have to have putty running all the time you want to connect to the DB.

[pmcinvest]

Thank you. I have been looking at PUTTY and may explore that option in depth at a later time. I need to have something up and running NOW. So, until I find something better I'm planning on the following:

I have found a good php script for creating an html doc from the db, the source code of which is a CSV file readable by excel. http://www.faqts.com/knowledge_base/view.phtml/aid/11347 (This site's knowledgebase looks very interesting but I couldn't take the time to explore it right now.)

I've added code that can save the result as an xls file on my office hard drive or a txt file on the BH drive. I'm going to try pw protecting the folder. A cron job could run the php script to update the txt file as often as I like. A cron job would not be practical with an xls file because I have to respond to the download each time, while the txt file on the BH drive is saved automatically.

The php file would be in the same pw protected folder and the folder would have an index.htm file to prevent folder browsing if anyone somehow got into the folder. Anyone see a security problem with this strategy?

[pmcinvest]

I found SQLyog, a nice GUI for connecting to my db. It allows downloads, uploads and a live interface with direct editing of the db.

I've successfully linked to my db by logging into the server.

I'm now having problems making an SSH tunnel connection. I've tried my BH un/pw combination without success. I've tried my db un/pw without success. I'm trying to connect to my dedicated IP on port 22. I've set up my office IP on the whitelist and added xxx.xxx.%.% to my access hosts.

I'm having a similar (perhaps the same) problem using the BH SSH tunnel script. SSH is turned on and I see the java program. I enter my IP, port 22 and username, select "password" and hit "connect". It keeps saying "password authentication failed". I've used both my BH and db un/pw but no luck. I've no doubt it's something numbingly simple that I'm doing wrong but I haven't a clue. HELP!!!!!!!

Merry Christmas, Happy Channichah, Happy Kwanzaa, Happy Holidays, Happy Winter Break (pick whichever applies) and a joyous New Year.

[pmcinvest]

OK, just as suspected the answer was very simple.

The username is NOT the domain name with which I log into BH.
The username is NOT the un with which I log into my db.
The username is NOT the "user" listed in phpMyAdmin.
The username IS the first part of "user" listed in phpMyAdmin before the "@".

If that bit of info was available in forums or knowledgebase, I missed it.

Now, if only I knew what to do once logged in.

[mwmoriarty]

I found SQLyog, a nice GUI for connecting to my db. It allows downloads, uploads and a live interface with direct editing of the db.

I've successfully linked to my db by logging into the server.

I'm now having problems making an SSH tunnel connection. I've tried my BH un/pw combination without success. I've tried my db un/pw without success. I'm trying to connect to my dedicated IP on port 22. I've set up my office IP on the whitelist and added xxx.xxx.%.% to my access hosts.

I'm having a similar (perhaps the same) problem using the BH SSH tunnel script. SSH is turned on and I see the java program. I enter my IP, port 22 and username, select "password" and hit "connect". It keeps saying "password authentication failed". I've used both my BH and db un/pw but no luck. I've no doubt it's something numbingly simple that I'm doing wrong but I haven't a clue. HELP!!!!!!!

Merry Christmas, Happy Channichah, Happy Kwanzaa, Happy Holidays, Happy Winter Break (pick whichever applies) and a joyous New Year.


Could you please detail what you used with SQLyog in the following fields:
MySQL Host Address:
Username:
Password:
Port:
Default Charset:

Also, did you have to 'whitelist' your IP address? and did you add your IP address to the 'Access Hosts' section of the MySQL panel?

Thank you