Jump to content

Archived

This topic is now archived and is closed to further replies.

mysty

connecting to server

Recommended Posts

I am able to use localhost to create my MySql databases and add data etc.  However, when I try to use the command prompt to connect to the server version (my ISP host), I don't know how to do that.  I tried SQLyog and was able to connect to the server, but can't do it using the cmd prompt.  When in SQLyog for host, I typed "mysql.domainname.com" (without the quotes and using my real domain name).  When I try that in mysql it does not work.  For example, "mysql -h mysql.domainname.com, -u username, -p password;".  For the host name in the example I have tried "http://my.... ",  "www.my...", http://www.my...", plus a few others, but to no avail.  Any ideas?  Do I need to contact my ISP to find out what is correct?

Forgot to add that I can use PHPmyadmin and get to localhost, but not the server.  How do I do that?

Share this post


Link to post
Share on other sites
You are trying to connect to your sql service on your local machine that your setting at?
"start" menu
go to "run"

type in box
mysql --user=your_user --password=yourpassword dbyouwanttoconnectto

click ok.

this will bring up mysql command line

Share this post


Link to post
Share on other sites
I can connect to the database from localhost.  My problem is trying to connect using my local ISP host server when using mysql from the command prompt.

Share this post


Link to post
Share on other sites
Sounds like a firewall / IP restriction issue -- most servers are set up to permit local connections only.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.