New User for Flexible Azure Database for MySQL-Server

Question

Hello,

we've setup a flexible Azure Database for MySQL-Server. Now a developer tried to setup a new user (with the given admin account):

create user monisoft identified by 'password'
grant insert,select,update,delete on monisoft.* to monisoft;

Unfortunately he didn't get access to the database with this user - is there anything we have also to setup?

Thank You!

Answer 1

Hi @Admin Aaron Strzemiacka

maybe it is just your copy and paste of code, or you missed it:

Flush privileges;  

According to my experience, you have done everything correctly, and it should work.

Maybe the documentation gives you some more advice:
https://learn.microsoft.com/en-us/azure/mysql/single-server/how-to-create-users#create-a-non-admin-user