PDA

View Full Version : MySQL host address.

john3166
22/03/2007, 15:03
Hi,

I wondered if anyone could help please? I would like to use a MySQL client (SQLYog, Navicat etc) to administrate the SQL database on my hosting account. I have tried my webite address (http://username.adsl24.co.uk) and the IP address provided in my welocome email as host details, but it will not connect.

I obviously need the address for my connection string in PHP.

Is there another address that I could use please?

Thank you

John
cliff
22/03/2007, 15:26
Hi John
Something i have never done, but if you follow this LINK (http://adsl24.co.uk/tutorials/xskin2/mysql.htm) it may be what you need .

Cliff:)
James
22/03/2007, 21:31
Host is "localhost"
Port is "3306"

James
john3166
23/03/2007, 14:34
Thankyou for the advice Cliff and James, however still cannot get it to connect - works fine with my other website.

Pity really because designing the database is much easier using SQLyog and Navicat.

Anyway, i'll keep trying! Thanks

John :)
James
24/03/2007, 15:08
Are you running a php script on your free webspace trying to connect the the mysql on our server? Or using a program on your own PC trying to connect to mysql on our server?

Thanks

James
john3166
24/03/2007, 19:36
Are you running a php script on your free webspace trying to connect the the mysql on our server? Or using a program on your own PC trying to connect to mysql on our server?

Thanks

James

Hi James,

I use a program on my PC called SQLyog (shareware app), I enter the host name in the "mysql host address" box (this is usually the website address) and provide the username and password that are defined in the database.

http://img78.imageshack.us/img78/1610/sqlex0.jpg

Obviously using localhost will connect locally to my machine and not across the internet to my remote database.

I have tried all different combinations of my website address and shared IP address, but to no avail!

The program works fine with my other hosting provider, can you think of any other address that I should be entering???

Thank you very much

John
James
25/03/2007, 11:32
This is because mysql access to our server is only allowed from a script/program running on our server (e.g. localhost). Outside access (inbound to our server on port 3306) is not allowed for security reasons. You can use the phpMyadmin tool in your cPanel to manage your mySQL database though...
john3166
25/03/2007, 13:55
This is because mysql access to our server is only allowed from a script/program running on our server (e.g. localhost). Outside access (inbound to our server on port 3306) is not allowed for security reasons. You can use the phpMyadmin tool in your cPanel to manage your mySQL database though...

Thats great, thanks for the info James. I think that I will create the database locally and then generate an SQL script to create the database using the tools in Cpanel.

Cheers

John
James
25/03/2007, 17:30
No problem. I am glad to help :)

James