[SOLVED] mysql help

[sasori]

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  ???

[marcus]

Does your mysql server allow access from your IP?

[sasori]

Does your mysql server allow access from your IP?

 

how will i know sir?,

[marcus]

If you're using a cPanel

 

http://i33.tinypic.com/264o02p.jpg

[sasori]

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?

[marcus]

Try it. If that doesn't work try connecting to it by an IP, instead of a server url.

[sasori]

i added my ip ..but still this thing

 

-h test.test.org -u myuser -p mypassword;

 

doesn't work ???

[marcus]

Instead of test.est.org try the ip to that.

[sasori]

Instead of test.est.org try the ip to that.

 

it doesn't work either

 

-h 192.my.ip.something -u mypass -p mypassword

[marcus]

Have you tried just using a PHP connection? Instead of triyng to open it in your wamp service.

[sasori]

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 ???

[sasori]

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