Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Question: Create user WITH additional params. #45

Closed
ajax-mykhailo-oleksiuk opened this issue Nov 9, 2022 · 1 comment
Closed

Question: Create user WITH additional params. #45

ajax-mykhailo-oleksiuk opened this issue Nov 9, 2022 · 1 comment

Comments

@ajax-mykhailo-oleksiuk
Copy link

Hi @petoju,

I've looked throught source code and don't see any chances to create a user with additional params like this:

CREATE USER 'francis'@'localhost' IDENTIFIED BY 'frank'
    ->     WITH MAX_QUERIES_PER_HOUR 20
    ->          MAX_UPDATES_PER_HOUR 10
    ->          MAX_CONNECTIONS_PER_HOUR 5
    ->          MAX_USER_CONNECTIONS 2;
  1. Could you please confirm this?
  2. Do you have any plans to add this or not?
@petoju
Copy link
Owner

petoju commented Nov 9, 2022

  1. Yes, there is no ability to do that.
  2. I don't have any plans as I don't believe it really helps (one large query/update thru one connection can be much worse than 20 simple queries). That said, I will accept PRs adding this behavior, as long as the code quality is reasonable and as long as it won't break existing users.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants