Can't make MySQL Connection on iPower

[ladobeugm]

I'm trying to make a MySQL Connection on a site hosted by iPower (aka iPowerWeb) and it keeps giving me this error when I try:

MySQL error #2002: Cannot connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

iPower's support is very nil so they're not helping. I followed their FTP coordinates although they don't exactly say anything about setting up testing servers. Anyone have any luck making a connection on this host?

[Newsgroup_User]

databell posted in macromedia.dreamweaver.appdev:

> I'm trying to make a MySQL Connection on a site hosted by iPower
> (aka iPowerWeb) and it keeps giving me this error when I try:

Right there in your host's Help Center, it states that they do not
allow connecting to the database remotely (from your own computer, for
example). They - and many shared hosting providers - do this for
security reasons.

Configuring: Connecting to the MySQL database remotely
http://www.ipower.com/knowledgebase/read_article.bml?kbid=1154

Here's a discussion in the General Dreamweaver group where it is
suggested to set up a Web server/PHP/MySQL on your local computer:

http://preview.tinyurl.com/4lejbk




--
Mark A. Boyd
Keep-On-Learnin' :)

[ladobeugm]

Now that really sucks. I was hoping to set up a password protection scheme so that when the client logs in, it takes them over to a specific place on my Zen Cart store. Now not just does the MySQL connection from DW not work but the store doesn't want to make a connection either. And that was working just fine prior to that! Ugh!

[Newsgroup_User]

databell posted in macromedia.dreamweaver.appdev:

> Now that really sucks. I was hoping to set up a password
> protection scheme so that when the client logs in, it takes them
> over to a specific place on my Zen Cart store. Now not just does
> the MySQL connection from DW not work but the store doesn't want
> to make a connection either. And that was working just fine prior
> to that! Ugh!

Is the store on a different server? If it's on the same iPower server,
you should be able to do it.

You just won't be able to test locally (or use DW's automatic DB
behaviors easily) without setting up a local testing server.


--
Mark A. Boyd
Keep-On-Learnin' :)