I don’t know what language you are using, but currently the drivers of various languages support database switching, which means that the database separation of authentication and operation can be achieved. You can select admin for authentication when connecting to the database, and then switch to the local database for operations after connecting. Note, make sure that your user in the admin has permission to operate the local database!
I don’t know what language you are using, but currently the drivers of various languages support database switching, which means that the database separation of authentication and operation can be achieved. You can select admin for authentication when connecting to the database, and then switch to the local database for operations after connecting. Note, make sure that your user in the admin has permission to operate the local database!