close ad
Install the LAtest Updates to Work with CC 2017 and CC 2018
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Warning: mysql_pconnect() [function.mysql-pconnect]: Access denied for user

Thread began 7/06/2015 9:54 pm by bjgarner241692 | Last modified 7/07/2015 5:35 pm by Ray Borduin | 563 views | 3 replies |

bjgarner241692

Warning: mysql_pconnect() [function.mysql-pconnect]: Access denied for user

I get this error on loading a results page, however, I could test the query from within Dreamweaver with no problem.

Problem was that there was a $ sign in the database password, which is apparently not a legal character for a MySQL password.

I have included that just to help out others who stumble on the same error. However, I still have an issue.

I created some pages using a MySQLi connect string rather than the MySQL connect string I have always used. I did this from within the DataAssist wizard. Like the other page, I can successfully run the query using TEST in Dreamweaver, but on loading the page I get this error.

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in .....
and
Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in

I am stumped. The server supports MySQLi, so why is it not recognizing the page? If I change the connection string to the MySQL version, the page runs just fine.

Sign in to reply to this post

Ray BorduinWebAssist

The error is referring to mysql functions and not mysqli... but you imply that you are using mySQLi on the page... so there seems to be a disconnect.

Updating a page to use mysqli isn't just a matter of updating the connection. It requires updating all of the recordsets, inserts, and updates as well. My guess is that you updated the connection, but still have code on the page that refers to the mysql connection and that no longer works.

Sign in to reply to this post

bjgarner241692

I think you are half right.

I did this with data assist wizard. First step is to create a connection and you have a choice between mysql or mysqli. I chose mysqli but the wizard created pages for mysql.

If I point to the mysql connection script the pages work fine.

Why did it not create mysqli pages to match the connection chosen?

Sign in to reply to this post

Ray BorduinWebAssist

Data Assist hasn't been updated to work with MySQLi yet. We will be adding that in the next major update. For now you need to use a standard MySQL connection to work with Data Assist.

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...