T
T
T3R3AND2020-05-17 01:55:00
linux
T3R3AND, 2020-05-17 01:55:00

Restricting database connections?

Hello! There is a Linux server, I want to make sure that certain users have restrictions on simultaneous connections to their database, how to implement it?

------
Moderators please do not delete! Please correct if something is wrong.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
S
Saboteur, 2020-05-17
@saboteur_kiev

set a connection limit for mysql users with the command:
ALTER USER 'user1'@'localhost' WITH MAX_USER_CONNECTIONS 1;

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question