Connect my database through DWMX 04


#1

Hi There

I’m trying to connect my database from DWMX 04.

Here is my setting:
Connection name: myconnection
MySQL Server: mysql.mydomain.com
username: whatever
password: youguess
Database: fonky (the name of my db created from phpAdmin)

When I test the connection I have this error message:
"1130 Host ‘67-189-72-131.vnnyca.adelphia.net is not allowed to connect to this MySQL server’

What am I doing wrong here?
Do I need to do something in my site definition?
Or what?

Help please
Thanks

boco
After ecstasy, the laundry


#2

you’ll have to set up your database to allow connectiosn from an IP besides DH’s. Just log into your panel and go godies>mysql and edit the user.

It’s set this was a a security feature.

-Matttail


#3

I don’t get it Mat

I went there, that’s actually where I set up the database.
I don’t see at all what you nean!!!??!?!??

boco
After ecstasy, the laundry


#4

Log into your panel > Goodies > Mysql
Find the database you are trying to access and click the modify button across from the user set up on that database. You’ll then find a page with several settings. There’s a bok underneath where it says"
From what hosts (computers) may art_googlies connect to the “art_googlies” database?"
and it even shows your IP address. Fill it in, then you should be abel to connect after then chnages take effect.

-Matttail


#5

Mattt

YOU ARE THE BOMB.
IT WORKS!!!

But just curious.
What does this mean?
One per line, use % as a wildcard
What’s a wildcard
Why do we have a period after the %?

Also, I’m running PHP 5 in my computer OS X, is it a problem, since Dreamhost is running PHP 4?

Thanks a lot again.

boco
After ecstasy, the laundry


#6

the wild card is would be like anything.dreamhost.com - that covers all possibilties of subdomains of Dreamhost. So any of the DH servers can access the database, but no one else.

It’s just like saying “Jokers are wild” when playing uno. That joker can represent any card you’d like it to represent.

And one per line just means that’s how you seperate entries.

There could be some issues with the PHP version difference, but I don’t really know anything about PHP. I’m sure there is some new feature support and command variables that will be suport and work on your system, and then you’ll publish to DH and things won’t work, or will work differently. One way around this would be to search the forum and the wiki and install php5 your self. It’s been done before, and you should be able to find some helpful instructions.

-Matttail


#7

Thanks a lot Mattt

You’ve been very helpful.

boco
After ecstasy, the laundry


#8

you’re welcome, and I like your sig a lot. :slight_smile:

-Matttail


#9

Cool!

I checked wiki, you’re right, there is a way of installing PHP 5.
I’ll do it sometimes if I really have to.
Maybe be DH will upgrade by that time.

See you around.

boco
After ecstasy, the laundry