Connecting to SQL via dreamweaver

james gilfoyle · May 20th, 2008, 5:14 AM

Hey guys,

I've got a hosting account on SH140 and cant seem to find the address for the SQL server so that i can use it in the connection information in Dreamweaver so that i can actually begin my development.

Localhost doesnt work btw... it wont let me select the databases or anything. I remember having the same problem when i was over on Netrillium and they did something and fixed this...

Was wondering if you could give me any advice?

Thanks in advance!

James

**Mark** · May 20th, 2008, 12:48 PM

Hi James, the first thing you need to do is add your IP address in the cPanel MySQL page, under "Access Hosts" to allow access to the sql server from your computer. Once that is done, change the hostname in dreamweaver to your domain name. You shouldn't have any problems after that unless your IP changes again.

Localhost is just an alias to 127.0.0.1 which is the loop back address, so it would only work for scripts on the actual server, not externally.

May 20th, 2008, 5:14 AM	#1 (permalink)
james gilfoyle Registered User Fresh Surpasser Joined in Jan 2008 20 posts Gave thanks: 2 Thanked 0 times	Connecting to SQL via dreamweaver Hey guys, I've got a hosting account on SH140 and cant seem to find the address for the SQL server so that i can use it in the connection information in Dreamweaver so that i can actually begin my development. Localhost doesnt work btw... it wont let me select the databases or anything. I remember having the same problem when i was over on Netrillium and they did something and fixed this... Was wondering if you could give me any advice? Thanks in advance! James

May 20th, 2008, 12:48 PM	#2 (permalink)
Mark Surpass Developer Excelling Contributor Joined in Jan 2004 Lives in Florida Hosted on decc.surpasshosting.com 509 posts Gave thanks: 20 Thanked 78 times	Hi James, the first thing you need to do is add your IP address in the cPanel MySQL page, under "Access Hosts" to allow access to the sql server from your computer. Once that is done, change the hostname in dreamweaver to your domain name. You shouldn't have any problems after that unless your IP changes again. Localhost is just an alias to 127.0.0.1 which is the loop back address, so it would only work for scripts on the actual server, not externally. __________________ Mark Surpass Hosting Developer sɹnoʎ uɐɥʇ ɹǝʇʇǝq sı bıs ʎɯ

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)