Why do I get an "Access denied" error when trying to use mysqldump?
Posted: Mon Apr 05, 2021 4:09 pm
You may encounter this error when trying to use mysqldump on your webhosting as mysqldump tries to export tablespaces by default. Tablespaces were introduced in MySQL 5.7, however we do not allow the usage of them due to security issues associated with their usage in a shared environment.
You can get successfully dump your databases by adding the "--no-tablespaces" parameter to your command. For example:
You can get successfully dump your databases by adding the "--no-tablespaces" parameter to your command. For example:
Code: Select all
mysqldump -p --no-tablespaces your_database > db_backup.sql