> ## Content Index
> Fetch the complete content index at: https://www.bagz.fr/llms.txt
> Use this file to discover other available public pages before exploring further.

# Manage permissions on MySQL for remote users
- URL: https://www.bagz.fr/manage-permissions-on-mysql-for-remote-users/
- Published: 2015-12-24T13:56:03.000Z
- Updated: 2015-12-24T13:56:03.000Z
- Author: bgazui
- Tags: Database, #Migrated-1790668826633, #wp, #wp-post, #Import 2026-09-29 08:00

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* :show grants for 'myuser'@'myfirewalleddomain.local';
- Revoke all privileges on *my\_db* for user *myuser* on server *myfirewalleddomain.local* :revoke ALL PRIVILEGES ON \`my\_db\`.\* FROM 'myuser'@'myfirewalleddomain.local';
- Grant access for *SELECT* on *my\_db* for user *myuser* on server *myfirewalleddomain.local* with a password:GRANT SELECT ON \`my\_db\`.\* TO 'myuser'@'myfirewalleddomain.local' IDENTIFIED BY 'mYsupErs3curePassw0Rd' WITH GRANT OPTION;
- Grant all privileges on *my\_db* for user *myuser* on server *myfirewalleddomain.local* with a password:GRANT ALL PRIVILEGES ON \`my\_db\`.\* TO 'myuser'@'myfirewalleddomain.local' IDENTIFIED BY 'mYsupErs3curePassw0Rd' WITH GRANT OPTION;