Link You Today
Bookmark your Free, Libre software & tech link

Troubleshooting MySQL access privileges issues: Q & A

mariadb, mysql, percona

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