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>

You have answered your own question. The error message you receive says it all:-

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

This means that either your authorisation information is incorrect, or your MySQL Server has remote connections turned off.

This subject has been covered a number of times in this forum, please remember to search the forum before placing your question.

All the best

Tim Green

Extension & PHP TalkZone Manager
<font size=1>-------------------------------------------
<i>Please read the Forum FAQ before posting
a question to this TalkZone.</i>
-------------------------------------------
www.UDzone.com : A dynamic Dreamweaver,
Ultradev and Fireworks site for developers
by developers.
-------------------------------------------</font id=size1>

Hi tim,

i've wrote to my ISP to see if the mySQl remote connection is turned off.

But if it's turn on all ready the info which i'm placing in the forms must be wrong.
could you look over it to see what the problem might be.

thanks <img src=../images/dmxzone/forum/icon_smile_blush.gif border=0 align=middle>

If the info is wrong, then it is your username and password as the error you are getting is an <b>Authentication</b> error.

Tim Green

Extension & PHP TalkZone Manager
<font size=1>-------------------------------------------
<i>Please read the Forum FAQ before posting
a question to this TalkZone.</i>
-------------------------------------------
www.UDzone.com : A dynamic Dreamweaver,
Ultradev and Fireworks site for developers
by developers.
-------------------------------------------</font id=size1>

Hi tim,

i wrote my ISP and they said “they don't allow remote mySQL connections”

What's the difference if a ISP has a mySQL database with remote access.
Now i find out that mine won't allow it, so is there any ISP's that you know of that can handle a site with the same speces as my own.

Maybe if you give your ISP a little push, and ask for remote access for only minimal priveleges, for example only SELECT, meaning with that username you would not be able to do updates, inserts, etc. MySql can set up users with different priveleges, and allow access to only specific domains etc.

Tell them you need it to integrate with Dreamweaver, and that you'll be using phpMyAdmin to do your actual database work.

I'm not sure -- can you install a local copy of MySql on a Mac?

Hi tim, if you could explain WHY in need the remote access to me, then they will set it up . This would be a big help to me thanks. will

Well, if you want to use Ultradev's Server Behaviours and Data Bindings, you need to have access to the database. As far as I can remember, you won't be able to drag records from the Data binding palette without making a successful database connection. (Someone correct me if I'm wrong.) You could set up a copy of MySql on your computer, but I don't think that is even possible with OS 9.1.

Hi dylan,

i think that you can only install mySQL on
OS X and i'm using 9.1.

The tech support guy just aked me

“Where is Dreamweaver? Does Dreamweaver pull database data from your database to your local machine? If so, why do you need this?”

I hate to be the middle man, but your knowledge on this subject is very important to me.

thanks, will

Hi dylan,

they said that “We can do it on one condition. You must give us your IP address that you will be using Dreamweaver from. It must be a dedicated IP that doesn't
change.”

But i'm running dreamweaver of my local computer, what should i do.

thanks, will

Hi Will,

I'm prertty sure that Dreamweaver will go through your IP address. Everyone has an IP address that connects to the net. I know mine changes a little every time I connect. I'm not sure exactly where you can find it out... Here, I found a place that will tell you:
www.lawrencegoetz.com/programs/ipinfo/

I think your other choice would be to use an Access database or something on your home computer, with exactly the same format as the one at your ISP. You'd be able to work with this on your computer, and then when you upload, all you would have to do was change the database that your jdbc driver is referencing.