:::: MENU ::::

Monthly Archives / December 2015

  • Dec 24 / 2015
  • 0
Database

Manage permissions on MySQL for remote users

MySQL has always been one of the most used database engine for websites. Its security is really important, isolating and managing access must be taken in consideration.

Hereafter are some commands to perform some checking and some updates.
I will consider those variables for my examples, but you should customize them with your own:

  • Show permissions for user myuser on server myfirewalleddomain.local :
  • Revoke all privileges on my_db for user myuser on server myfirewalleddomain.local :
  • Grant access for SELECT on my_db for user myuser on server myfirewalleddomain.local with a password:
  • Grant all privileges on my_db for user myuser on server myfirewalleddomain.local with a password:
Question ? Contact