sasori Posted August 16, 2008 Share Posted August 16, 2008 let's say im running my mysql console using my wamp service how am i gonna connect to my live free hosting account's mysql server ? i tried this syntax, -h test.test.com -u myuser -p mypassword; but it doesn't work ??? Quote Link to comment Share on other sites More sharing options...
marcus Posted August 16, 2008 Share Posted August 16, 2008 Does your mysql server allow access from your IP? Quote Link to comment Share on other sites More sharing options...
sasori Posted August 16, 2008 Author Share Posted August 16, 2008 Does your mysql server allow access from your IP? how will i know sir?, Quote Link to comment Share on other sites More sharing options...
marcus Posted August 16, 2008 Share Posted August 16, 2008 If you're using a cPanel http://i33.tinypic.com/264o02p.jpg Quote Link to comment Share on other sites More sharing options...
sasori Posted August 16, 2008 Author Share Posted August 16, 2008 If you're using a cPanel http://i33.tinypic.com/264o02p.jpg based on the screenshot, does this mean i should place my own IP in that? Quote Link to comment Share on other sites More sharing options...
marcus Posted August 16, 2008 Share Posted August 16, 2008 Try it. If that doesn't work try connecting to it by an IP, instead of a server url. Quote Link to comment Share on other sites More sharing options...
sasori Posted August 16, 2008 Author Share Posted August 16, 2008 i added my ip ..but still this thing -h test.test.org -u myuser -p mypassword; doesn't work ??? Quote Link to comment Share on other sites More sharing options...
marcus Posted August 16, 2008 Share Posted August 16, 2008 Instead of test.est.org try the ip to that. Quote Link to comment Share on other sites More sharing options...
sasori Posted August 16, 2008 Author Share Posted August 16, 2008 Instead of test.est.org try the ip to that. it doesn't work either -h 192.my.ip.something -u mypass -p mypassword Quote Link to comment Share on other sites More sharing options...
marcus Posted August 16, 2008 Share Posted August 16, 2008 Have you tried just using a PHP connection? Instead of triyng to open it in your wamp service. Quote Link to comment Share on other sites More sharing options...
sasori Posted August 16, 2008 Author Share Posted August 16, 2008 Have you tried just using a PHP connection? Instead of triyng to open it in your wamp service. im just started reading about mysql a few hours ago sir.. i want to learn how to connect manually using that wamp console for mysql. i will plunge in connecting to it using php scripts ??? Quote Link to comment Share on other sites More sharing options...
sasori Posted August 16, 2008 Author Share Posted August 16, 2008 i have it working now..what i did was, i went to the directory of msyql of wamp c:\wamp\bin\mysql\mysql5.0.45\ then i typed mysql.exe -h my.domain.com -umyusername -pmypassword note: yeah , i removed the spaces between the -u and my username and also the space between -p and mypassword and it realy worked. lesson learned: never use wamp mysql console when trying to connect to a live webhosting mysql account and don't forget to add your own ip in the cpanel Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.