close ad
WARNING: Do Not Install the DREAMWEAVER CC 2017 Update »
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Unable to edit your database with the provided user credentials. Please make sure the connection user has write access to this database.

Thread began 5/31/2013 1:57 am by biesheuvel378713 | Last modified 6/20/2013 10:41 am by Jason Byrnes | 458 views | 8 replies |

biesheuvel378713

Unable to edit your database with the provided user credentials. Please make sure the connection user has write access to this database.

I've read some topics about this error, tried rebuilding the site definition but it doesn't work, I don't know....

I use Dreamweaver CS6
WIn 8 64bit

Sign in to reply to this post

Jason ByrnesWebAssist

the error happens if the Testing server section of the Site Definition is not set correctly.

Edit the site definition, and goto the Servers section.

Edit the server setting that has the texting option checked.

Make sure that the Web URL is correct for the site.

If you use an FTP connection to the testing server, you may need to set the root directory to point to the root of your site.

Sign in to reply to this post

biesheuvel378713

The testing server was defined ok. But what I didn't noticed was that the database connection file wasn't copied to the testing server, after I copied the database connection file to the server everything was allright. Sorry for taking your time (it was early in the morning for me) and thanks for putting me on the right trail.

Maybe another question, but I hope you can give an answer:

I create a site on my own server for a good friend of my with powercms. So at least I have some control of what version of php will be running at it. But I 've read that you guys are updating Databridge and Design Extender for work with mysqli. If so will the powercms be able to be updated to the version that uses mysqli in the near future?

PLease keep up the good work and thanks for your answer!

Sign in to reply to this post

Jason ByrnesWebAssist

Yes, when we update design Extender to use mySQLi, you will be able to upgrade existing Power CMS installs that where originally created with Design Extender to use mySQLi as well.

Sign in to reply to this post

biesheuvel378713

Ok thanks, that's great news! Have a nice weekend!

Sign in to reply to this post

jeffsure

Same Problem

I'm getting the same error message. I've double- and triple-checked my server settings, both remote and testing. Everything appears to be correct. I can connect to each just fine, but I get that error every time. I've tested the mysql connection in DW and it connects fine. I'm not sure what to do.

I'm using DW CS6 Mac, PowerCMS Builder, and connecting to godaddy.com (ugh, not by my choice)

Sign in to reply to this post

Jason ByrnesWebAssist

In the Settings for the testing server, make sure that you have the correct WebURL Entered.

in some cases, you may need to specify a site root as well.

The FTP or Database connection can still be made if these settings are not correct, but if the Web URL does not match to the same location that the FTP is connecting to, you will get that error.

Sign in to reply to this post

jeffsure

Thanks, Jason. I checked again, and I'm sure the settings are correct. I've attached a screen shot to show you. Maybe there's something I'm missing?

UPDATE: Never mind. I did some poking around and discovered that I'm using PowerCMS Builder 1.0.1, not compatible with CS6. I upgraded to Design Extender, and now all is well. Seems to be working.

Sign in to reply to this post

Jason ByrnesWebAssist

glad to hear it is working now.

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...