Title: "Troubleshooting MySQL access privileges issues: Q & A"
Date: 2017-03-24 19:35:09
Categories: [data base]
tags: [mysql, mariadb, percona]
Authors: sedlav
Sveta Smirnova provides a guide for the "Troubleshooting MySQL access privileges issues". Here are some of the questions answered by Sveta Smirnova:
- Should the root@localhost user be given ALL privileges or Super privileges? Does All include Super privileges also?
- What privileges are required for a non-root or non-super user to be to use mysqldump to dump the database and then restore it on a different server?
- What privileges are required for a non-root or non-super user to be to use mysqldump to dump the database and then restore it on a different server?
Link