To whom it may concern,

I' m a newbie trying to connect UD to mySQL database.

I will first go over every step that i have done up until this point.

I'm on a G4 with OS 9.1.
I have installed PHAkt 1.2 .
My ISP is a Linux Redhat server,
called www.performancehosting.net.
They provide my with phpmyADIM 2.2.3.
Which has a JDBC connection, so i can hook up my connection to the MAC.
When i check my driver connection in
“Modify Connection” there in no error messages.

I enter all the info and Test it I get:

Invalid authorization specification: Access denied for user: 'bgerman@ool - 182f655.dyn.optonline.net (using password:yes)

Now i'll go over all the info i put in and why

Connection name: conndatabase

Ultradev Connection
DB type: mySQL
Host:www.bigcreative.tv
URL:jdbc:mySQL:
//www.bigcreative.tv/bgerman_users
User Name: bgerman
Password:******* (it's correct)

PHP Connection
DB type:mySQL
Host:localhost
Database name: bgerman_users
User Name:bgerman
Password:****** (its correct)

Now here are some questions,
when i enter in info for Host: i put the website URL that i'm working on should it be my ISP ftp address.

I've looke at Tim Greens help page:
www.udzone.com/showDetail.asp?TypeId=2&NewsId=1202

It says that this is the hostname or IP address of my mySQL server.
Would that be my website or preformancehosting.net

I've also look at the Help Page Bob Costa put up.
www.udzone.com/showdetail.asp?TypeId=1221

I feel like they both give me different ways to insert the info.

Also inorder for me to enter my mySQL database i must put in
User: bgerman
Password:******* (its correct)

Then in phpmyAdmin it say database
bgerman_users is running on localhost.
and in the left frame is shows.

bgerman_users(1)
users (which is the name of my table)

If any one can help me connect to the database you will make me the happiest person in the world, at least for now.
<img src=../images/dmxzone/forum/icon_smile_big.gif border=0 align=middle>

Hi,

As fairly new to this things myself, I recognize the situation you're in: it seems that you do not have remote access to the database on your server. No panic, just replace www.bigcreative.tv by localhost (exactly the same as the connection on your PC). Look at it from the viewpoint of the server: localhost is accepted as a computer that has access to the database on that server (because it's the server itself of course), but bigcreative.tv isn't. If you make sure that on the server you have the correct login and password, I'm sure it will work. One more tip: create the connection you described here from scratch using Tim Greens JDBC extension, otherwise not everything might be changed correctly.

Dries