Please answer the questions below, it helps us to keep track of the issue. Please do not ignore it or your issue will be closed.
Which driver are you using and version of it (Ex: PostgreSQL 10.0):
MySQL 8
Which TablePlus build number are you using (the number on the welcome screen, Ex: build 81):
496
The steps to reproduce this issue:
When granting privileges in TablePlus (Win + Mac), it should reference the database like prod\_forums instead of prod_forums. This is because an underscore is a wildcard character in MySQL. A backslash is needed before an actual underscore for it to be treated literally. Otherwise prod_forums might match as prod*forums such as prodaforumsprodbforums etc.
Note! This is also the reason User Management (Win+Mac) doesn't display the database level priviliges as it can't match the correctly formated record prod\_forum with prod_forum. So this GUI element needs also support for this.
huyphams
commented
1 year ago
Please answer the questions below, it helps us to keep track of the issue. Please do not ignore it or your issue will be closed.
Which driver are you using and version of it (Ex: PostgreSQL 10.0): MySQL 8
Which TablePlus build number are you using (the number on the welcome screen, Ex: build 81): 496
The steps to reproduce this issue: When granting privileges in TablePlus (Win + Mac), it should reference the database like
prod\_forumsinstead ofprod_forums. This is because an underscore is a wildcard character in MySQL. A backslash is needed before an actual underscore for it to be treated literally. Otherwiseprod_forumsmight match asprod*forumssuch asprodaforumsprodbforumsetc.Note! This is also the reason User Management (Win+Mac) doesn't display the database level priviliges as it can't match the correctly formated record
prod\_forumwithprod_forum. So this GUI element needs also support for this.