_


Search the PowerSeek SQL Knowledge Base:
_
PowerSeek :: PowerSeek Knowledge Base :: Data Backups
_
Question: When I try to backup or restore data with the backup facility I get the following.

Software error:
SQL Syntax Error: Access denied for user: 'your_data_base_user' (Using password: YES)
Answer: Configure the backup utility to use mysqldump.

To use 'Use MySQL's DATA INFILE AND OUTFILE SQL Syntax' your database user (username) needs file privileges to your PowerSeek database. If you are on a virtual hosting account and have access to a MySQL Admin Panel, you will most likely be able to grant 'file' privileges to your MySQL database user from there. The database user is the user name that you entered when you ran setup.cgi so the PowerSeek can access your MySQL database.

If you are on your own server you will need to assign file privileges to your MySQL database user.
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: