Msg#: 4352982 posted 7:01 am on Aug 18, 2011 (gmt 0)
I am testing things out of free hosting with cPanel etc, but I would like to connect to MySQL through Windows Command, or I guess Putty. I am just not sure how to do this and if it is possible at all. In the end I want to be at mysql> on a server (instad of ftp> or c:\ in the command line if you know what I mean)
I have ftp info for the server (000webhost), I am able to connect through ftp client, I created an MySQL database in cPanel also. I just want to know if I can get there with either CMD or Putty (?) or something like that.
Msg#: 4352982 posted 1:11 pm on Aug 18, 2011 (gmt 0)
In order to use the command line in MySQL you will want to connect using secure shell (SSH) and PuTTY is the tool for Windows. But first you must turn on SSH access at the server. If you are allowed to do so via your control panel, go ahead. If not, you will have to talk to your hosting provider.