Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Execute "use mysql" before doing changes with the user manager

tam's profile image tam posted 2 years ago in Feature discussion Permalink

When working my Heidi on a remote server which is a master in a multiple master replication environment, I have to take care, when using the user manager, that I first select a database, which is not replicated, otherwise the "RENAME USER ..." (for example) is replicated on the salve, which mostly breaks the replication, because masters and slave generally have different users.

The simple solution would be to execute a "use mysql" before the user manager is doing changes.

Thanks in advance.

ansgar's profile image ansgar posted 2 years ago Permalink

Well you might not have privileges for changing into the "mysql" database, but privileges to run RENAME USER or whatever. This is the reason why HeidiSQL uses the various SQL commands for managing accounts, not some UPDATE, DELETE or INSERT INTO user.

Why not synchronize user accounts and privileges between your master and slave server? Otherwise I guess you should just not use HeidiSQL's user manager.

tam's profile image tam posted 2 years ago Permalink

Hello Ansgar,

thanks for the quick answer. Syncing the users is, in my case, not a good idea.

To open the user manager on needs RELOAD and SELECT privileges, isn't this enough to do a USE MYSQL?

Please login to leave a reply, or register at first.