1044 Error On Export As Sql Statment

[lmneditor]

The encountered problem is this: when attempting to export data (singly or in bunches), a “1044” error box appears with the added message “Access denied to 'username'@'%' for 'databasename.' This might be related to a connection description error, but I have been unable to locate any reference to either the error number or the actual error. Since access is necessary for various functions, it's rather important that I result this issue, even though I have been able to export individual tables to CSV files.

Suggestions appreciated.

[peterlaursen]

Most likely it is a privilege issue with 'Lock tables' or 'Flush log'.

What is your MySQL version? the LOCK_TABLE privilege was added recently and maybe user does not have it. And 'flush logs' is for use with replication primarily (and user must have replication related privileges) – though you may have a binary log also without replication.

Try fill-out the dialogue as attached

@Ritesh I request that program default will be to uncheck 'lock tables' . I think this is 3rd time we have this issue since MySQL added the LOCK_TABLE privilege

[lmneditor]

peterlaursen wrote on Mar 14 2006, 11:56 AM:

Most likely it is a privilege issue with 'Lock tables' or 'Flush log'.

What is your MySQL version? the LOCK_TABLE privilege was added recently and maybe user does not have it. And 'flush logs' is for use with replication primarily (and user must have replication related privileges) – though you may have a binary log also without replication.

Try fill-out the dialogue as attached

@Ritesh I request that program default will be to uncheck 'lock tables' . I think this is 3rd time we have this issue since MySQL added the LOCK_TABLE privilege

This site is running version 3.23.49. User Manager->Edit User returns the same error as above. I will confirm user privileges with ISP.

[peterlaursen]

Quote:

User Manager->Edit User returns the same error as above

This is very usual. Most ISP's will only let you manage user privileges from their own 'Control Panel' application. But if you don't 'lock tables' I think you will only need SELECT privilege. However to flush-hosts, flush-logs, flush-privileges, flush-status, flush-tables, flush-threads, refresh & reload you must have RELOAD privilege as well. refer to http://dev.mysql.com/doc/refman/4.1/en/pri…s-provided.html

But are they ordinary user tables that you try to backup? If it is some kind of system tables I doubt that they will let you

If it is a DB used by a PHP application (such as a forums software, guestbook software etc.) you should be able to log on with SQLyog using the credentials of that PHP-script.

Also:

if you enable batch logging from 'preferences' you should be able to see in HISTORY what was the last (unsuccessfull) command sent by SQLyog.

[Ritesh]

By default, LOCK TABLE and all FLUSH options are unchecked in Scheduled Export Wizard.

LOCK TABLES FOR READ is checked by default in Export Database As SQL Statements option. It will be UNCHECKED (by deafult) starting from BETA 3.

[Author]

Posts