Troubleshooting MySQL access privileges issues- Q & A.md 841 B


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