I accidentally removed all privileges for root
user in mysql
database user
table.
By helping best at MySQL Error: : 'Access denied for user 'root'@'localhost' I can now access database but I cannot grant all privileges to my root
user at localhost
.
Via PHPMyAdmin interface when I go and try to add, I get this error:
#1290 - The MariaDB server is running with the --skip-grant-tables option so it cannot execute this statement
But I cannot access database and phpmyadmin without skip-grant-tables
option.
This is the query runs but returns error:
GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' REQUIRE NONE WITH GRANT OPTION MAX_QUERIES_PER_HOUR 2147483647 MAX_CONNECTIONS_PER_HOUR 2147483647 MAX_UPDATES_PER_HOUR 2147483647 MAX_USER_CONNECTIONS 2147483647;
What should I do?