MySQL/MariaDB: unable to make changes with correct permisions and user. NOT A PASSWORD PROBLEM

Question

getting some odd behaviour with my remote connexion to the db. user table looks like this:

+-----------+-----------+
| host      | user      |
+-----------+-----------+
| %         | manage    |
| %         | remoteusr |
| 127.0.0.1 | root      |
| ::1       | root      |
| localhost | root      |
+-----------+-----------+

running select current_user(); gives me this:

+----------------+
| current_user() |
+----------------+
| manage@%       |
+----------------+

and show grants; gives me this:

+---------------------------------------------------------------------------------+
| Grants for manage@%                                                             |
+---------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'manage'@'%' IDENTIFIED BY PASSWORD '-REDACTED-' |
+---------------------------------------------------------------------------------+

so for all intents, this should allow me to do whatever the hell i want from wherever the hell i connect. but when i try to create a new user, this is the error i get:

MariaDB [thing_db]> grant all privileges on thing_db.* to 'remoteusr'@'%';
ERROR 1044 (42000): Access denied for user 'manage'@'%' to database 'thing_db'

totally stumped here. based on the docs, there is no alternate permission that could be authenticated against. when i select user(), i get manage@localhost, which should still allow me to do what i need as there is no empty @locahost in the user table.

this seems a pretty straightforward thing and i've flush privileges; several times to no effect.

so what the heck is going on here that i'm missing?

slaakso · Accepted Answer · 2020-07-17 16:27:30Z

2

You have all permissions apart from the GRANT priv, meaning you cannot grant privileges to other user. See WITH GRANT OPTION from the documentation.

answered Jul 17, 2020 at 16:27

slaakso

9,1452 gold badges19 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

WhiteRau Over a year ago

...you've got to be kidding... slap. doesn't the GRANT ALL PRIVILEGES... include actual GRANT privileges?? i used to enumerate them, but started using the ALL keyword... how do i actually GRANT GRANT???

WhiteRau Over a year ago

nm. sorted. had to use GRANT GRANT OPTIONS.... thank you so much. feel like a twit... but that's ok. problem sorted.

Collectives™ on Stack Overflow

MySQL/MariaDB: unable to make changes with correct permisions and user. NOT A PASSWORD PROBLEM

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related