mysty Posted August 16, 2006 Share Posted August 16, 2006 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? Link to comment https://forums.phpfreaks.com/topic/17783-connecting-to-server/ Share on other sites More sharing options...
JadedLucidity Posted August 17, 2006 Share Posted August 17, 2006 You are trying to connect to your sql service on your local machine that your setting at? "start" menugo to "run"type in boxmysql --user=your_user --password=yourpassword dbyouwanttoconnecttoclick ok.this will bring up mysql command line Link to comment https://forums.phpfreaks.com/topic/17783-connecting-to-server/#findComment-75994 Share on other sites More sharing options...
mysty Posted August 17, 2006 Author Share Posted August 17, 2006 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. Link to comment https://forums.phpfreaks.com/topic/17783-connecting-to-server/#findComment-76109 Share on other sites More sharing options...
JadedLucidity Posted August 17, 2006 Share Posted August 17, 2006 Call your isp, I am no help there. sorry :-[ Link to comment https://forums.phpfreaks.com/topic/17783-connecting-to-server/#findComment-76435 Share on other sites More sharing options...
fenway Posted August 18, 2006 Share Posted August 18, 2006 Sounds like a firewall / IP restriction issue -- most servers are set up to permit local connections only. Link to comment https://forums.phpfreaks.com/topic/17783-connecting-to-server/#findComment-76817 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.