TablePlus Documentation
HomeDownloadPricing
Search…
TablePlus Documentation
Overview
Getting Started
GUI Tools
The Interface
Open Anything
Code Review & Safemode
Connections
Database
Working with Table
Filter
Database Objects
Import & Export
Backup & Restore
User Management
Query Editor
Editor Basics
Multiple Carets
Query Favorite & Keyword Binding
Query History
Streaming Results & Async Loading
Autocomplete
Split Panes
Split Results into Tabs
Working With Query Results
Query Reformat
Query Parameters
Customize Query Editor
Preferences
General
Fonts & Colors
Crash & Security
Keymap
Utilities
Plugin
DBngin
Shortcut Keys
Licensing
Troubleshooting
Powered By GitBook
User Management
From the workspace, navigate to menu Connection > User Management…, or you can click on the User Management button at the toolbar.
If the User Management button is not on the toolbar, right click on the toolbar and choose Customize Toolbar... and add it in.
User Management feature is currently available for MySQL only.

Create a new user via GUI

    Open the User Management dialog
    Use the + button at the bottom left to create a new user.
    Input the username and password for the new user you need.

Grant privileges to new user

If you want to grant global privileges to the new user, switch to the Global Privileges tab and configure.
The new user will have certain privileges for all the databases. If you check and grant all privileges from this setting, beware that the new user will have the same power as the default root user. You probably want to do that to a Backup root user account.
In most cases, you will be granting privileges to the new users based on some specific databases that account should have access to, then use the Database Privileges tab to configure.
Select the database and grant the corresponding privileges to the new user.

Set resource limits

An addition setting for the new user is that you can define the resource limits. This includes:
    Max Updates: The number of updates the account can execute within one hour.
    Max Connections: The number of times the account can connect to the server within an hour.
    Max Questions: The number of queries the account can execute within one hour.
After that, click Apply to finish creating the new user.

Update the privileges of a current user

From the User Management dialog, TablePlus lists all current users of the database on the left side. You can select any user to view the current privileges and make changes if needed.
If you want to remove all of the rights assigned to the selected user account, you can go back to edit, uncheck the privileges and then save the changes.
To delete a user, select the user and hit - button near the bottom left then save.
GUI Tools - Previous
Backup & Restore
Next - Query Editor
Editor Basics
Last modified 2yr ago
Copy link
Contents
Create a new user via GUI
Grant privileges to new user
Set resource limits
Update the privileges of a current user