_


Search the PowerSeek SQL Knowledge Base:

_
PowerSeek :: PowerSeek Knowledge Base :: MySQL Trouble Shooting
_
Question: Whenever I try to login to the PowerSeek Control Panel or run any of the PowerSeek scripts I get a 'Access denied for user' error. -- or -- When I get an 'Access denied for user' error when I run setup.cgi - How do I solve this?

Answer: This most likely means that your MySQL access details namely the MySQL User Name or MySQL Password or MySQL Database Name is invalid or incorrect. (PowerSeek is configured to use a MySQL database and uses the MySQL User Name and MySQL Password and MySQL Database Name to access and store information inside the MySQL Database)

It may also be that the MySQL User does not have access to access the MySQL Database to perform various operations on the database (like Selecting Records, Adding Records, Modifying Records, etc.) Most Hosting Control Panels will normally have a section where you can set the MySQL User Access Permissions to the MySQL database. This will also be the section in the Hosting Control Panel where you set up the MySQL Database and create a MySQL user.

Reasons for this occurring might be changes on your host or you might have accidentally deleted your MySQL User Access details.

First check that the MySQL Database User has sufficient access to the MySQL Database. This can be done by going to your Hosting Control Panel (where you set up MySQL databases) and ensuring that the Database User has access permission to the Database PowerSeek is configured to use.

To check that PowerSeek is configured with the correct Database Name, Database User Name and Database Password run PowerSeek's setup.cgi script. To do this, unzip the .zip installation archive of PowerSeek. Transfer setup.cgi to your 'admin' directory where the admin .cgi script files reside. Then assign permissions of 755 to setup.cgi - There are links at the bottom of this entry that tells you how to set permissions of files. Load up setup.cgi in your browser and choose the 'I Agree To The Terms' button to go to the next screen. On the next screen you will see boxes for your database name, database user and database password. Make sure the MySQL Database Name, MySQL User Name and MySQL Password is correct.

Also See:

User Comments:

There are currently no comments available.
_
Add a Comment - Only post comments regarding this KB entry
If you need to get in contact with us then click here.
Name:
Email: (Optional)
Comment:



Type in the letters that apear in the image box

_
PowerSeek Knowledge Base Categories: