I am trying to grant the permission for the administrator ( me) to have multiple connections in the same time. I used this sql command:
grant usage on *.* to user id1186804_admin@% with max_user_connections 2000;
but every time i have two types of errors: one about the syntax, and one about the fact that the request is denied. Can anyone help me please?
The reason why I want to do this, is because every time I have more than one user connected, I have the error from the bellow screenshot: