©SQL :: Manager
HomeProgram InformationTechnical detailsFree downloadDonate for a cup of coffee
This website works better with Javascript
The MyWAY SQL Manager can be downloaded here for free: as PHP installation file as GZIP file as ZIP archive
If the download from this page does not work, you can also download the program here (Virus checked at heise.de).
By downloading you accept the General Terms and Conditions
The program MyWAY SQL-Manager only works with Javascript
myway SQL Manager for MySQL and MariaDB, Download on Uptodown
Database permissions of MySQL and MariaDB user accounts

Edit access rights of MySQL and MariaDB user accounts for database

Database user This module is part of the database administration and configuration
MyWAY - Edit database user permissions for database

Module for editing database user permissions on the MySQL Server.

Edit permissions for the database.

Edit permissions for database objects (tables, table columns, views, procedures and functions).

Global rights: The permissions are determined on a global level.
Switching off causes the permissions to be copied from the global level to the database level.

Set permissions Set all permissions for the database user
Revoke permissions Revoke all permissions for the database user
Color information Displays the color information for permission dependencies
FLUSH PRIVILEGS Reload privileges (FLUSH PRIVILEGS)
User permissions Edit user rights for database.
Table permissions Edit user rights for tables.
Table column permissions Edit user rights for table columns.
View permissions Edit user rights for views.
Procedure permissions Edit user rights for procedures.
Function permissions Edit user rights for functions.
MySQL - Edit database user permissions - Menu

Labeled menu by double-clicking title bar.

MySQL - Edit database user permissions for tables of the database - User selection

Edit database user permissions for tables in the database via user selection.

Parent rights: The permissions are determined by the higher level (global, database).
Turn off causes the permissions from the higher level to be copied to the table level.

MySQL - Edit database user permissions for tables of the database - Table selection

Edit database user permissions for tables in the database via table selection.

Parent rights: The permissions are determined by the higher level (global, database).
Turn off causes the permissions from the higher level to be copied to the table level.

MySQL - Edit database user permissions for table columns - Selection via user / table

Edit database user permissions for table columns with selection via user and table.

Parent rights: The permissions are determined by the higher level (global, database, table).
Turn off causes the permissions from the higher level to be copied to the table column level.

MySQL - Edit database user permissions for table columns - Selection via table / user

Edit database user permissions for table columns with selection via table and user.

Parent rights: The permissions are determined by the higher level (global, database, table).
Turn off causes the permissions from the higher level to be copied to the table column level.

MySQL - Edit database user permissions for table columns - Selection via table / table columns

Edit database user permissions for table columns with selection via table and table column.

Parent rights: The permissions are determined by the higher level (global, database, table).
Turn off causes the permissions from the higher level to be copied to the table column level.

MySQL - Edit database user permissions for views of the database - User selection

Edit database user permissions for views in the database via user selection.

Parent rights: The permissions are determined by the higher level (global, database).
Turn off causes the permissions from the higher level to be copied to the view level.

MySQL - Edit database user permissions for views of the database - View selection

Edit database user permissions for views in the database via view selection.

Parent rights: The permissions are determined by the higher level (global, database).
Turn off causes the permissions from the higher level to be copied to the view level.

MySQL - Edit database user permissions for procedures of the database - User selection

Edit database user permissions for procedures in the database via user selection.

Parent rights: The permissions are determined by the higher level (global, database).
Turn off causes the permissions from the higher level to be copied to the procedure level.

MySQL - Edit database user permissions for procedures of the database - Procedure selection

Edit database user permissions for procedures in the database via procedure selection.

Parent rights: The permissions are determined by the higher level (global, database).
Turn off causes the permissions from the higher level to be copied to the procedure level.

MySQL - Edit database user permissions for functions of the database - User selection

Edit database user permissions for functions in the database via user selection.

Parent rights: The permissions are determined by the higher level (global, database).
Turn off causes the permissions from the higher level to be copied to the function level.

MySQL - Edit database user permissions for functions of the database - Function selection

Edit database user permissions for functions in the database via function selection.

Parent rights: The permissions are determined by the higher level (global, database).
Turn off causes the permissions from the higher level to be copied to the function level.

More information about table level permissions: Table permissions
View level permissions: View permissions
Permissions at procedure and function level: Routine permissions
Updated: 2025-11-04ImprintContactTerms & conditionsPrivacy & CookiesUpdatesSitemapFacebookLinkedin©2020-2025 Heino Cunze-Fischer