Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
11.6.1
-
None
-
Linux
Description
create user test identified by 'test';
|
Query OK, 0 rows affected (0.001 sec)
|
 |
MariaDB [(none)]> grant all privileges on *.* to test;
|
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
|
I am 'root@localhost', and if I restart the server with skip-grant-tables, I cannot assign privileges. I need to assign all privileges to a user because for backup I need to dump the mysql.user table, and this fails without full privileges, I mean, if you try then you get nothing, mariadb-dump cannot dump that critical table. So I am in a circle. Is there a solution to this nightmare?
Attachments
Issue Links
- duplicates
-
MDEV-33554 Upgrade from 11.2 to 11.3 changes root's privileges restricting GRANT ALL
- Closed