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

Unable to update users in MariaDB 10.4.1+ #3517

Open
lukewhitt opened this issue Aug 14, 2019 · 4 comments

Comments

@lukewhitt
Copy link

commented Aug 14, 2019

  • Sequel Pro Version: Nightly Build 5446 (97c1b85)
  • macOS Version: 10.14.5
  • MariaDB Version: 10.4.6

Description
Using the 'Users' GUI, I am unable to create or update any user details for users in MariaDB 10.4.1+.

Steps To Reproduce

  1. Ensure MariaDB installation is 10.4.1 or above
  2. Open Sequel Pro and attempt to create a new user via the UI

Expected Behaviour
You should be able to create a new user via the UI successfully. Other operations such as updating permissions should work within that UI too.

Additional Context
MariaDB as of 10.4.1 have modified the way they structure and store permissions internally. The mysql.user table is now a read-only view onto the new table mysql.global_priv. When attempting to update the user via the SequelPro UI, it appears the following query is run:
UPDATE mysql.user SET max_questions = 0, max_updates = 0, max_connections = 0 WHERE User = '<user>' AND Host = 'localhost'; - this operation fails due to the new read only view.

@gridsystem

This comment has been minimized.

Copy link

commented Sep 10, 2019

For anyone else struggling to google their way to this bug, the exact error from Sequel Pro is

Column 'max_questions' is not updatable

@gridsystem

This comment has been minimized.

Copy link

commented Sep 10, 2019

This issue also seems to leave me unable to add privileges to users, which is pretty much all I normally use Sequel Pro for 🤷‍♂

@SenH

This comment has been minimized.

Copy link

commented Sep 11, 2019

It's fixed in PR #3504
You can clone & compile this repo ftm: https://github.com/ahoz/sequelpro

@lukewhitt

This comment has been minimized.

Copy link
Author

commented Sep 11, 2019

@SenH Apologies, I did perform a search but didn't find any references to Maria 10.4.1+

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
3 participants
You can’t perform that action at this time.