It is currently Sun Jun 13, 2021 1:11 am
All times are UTC + 8 hours

max_queries_per_hour

A set of PHP-scripts to manage MySQL over the web.

max_queries_per_hour

Postby santtu1980 » Mon Feb 22, 2021 4:51 pm

Damn.
For security reasons I've changed max_queries_per_hour setting to 1 for the root user. Now if I reset the root pswd from ADM the logging process succeeded but still cannot log in because "#1226 - User 'root' has exceeded the 'max_queries_per_hour' resource (current value: 1)"

Tried to login via SSH and reset that 'max_queries_per_hour' value. But linux is too hard for me. Can someone help to reset that setting.
Hardware: AS3102T || AS-202TE
santtu1980
 
Posts: 6
Joined: Fri Dec 13, 2019 5:34 pm

Re: max_queries_per_hour

Postby santtu1980 » Tue Feb 23, 2021 11:44 pm

Finally I solved this endless loop. Using try and fail-method several times!

Set SHH on on your NAS if it is not yet. (Services->Terminal->Enable SSH)
Reset mariaDB password. (open MariaDB settings->Reset Password) root/admin
Open Mysql from SSH terminal. (use putty or similar)
mysql -u root -p
enter password
reset mariaDB password after login
GRANT USAGE ON *.* TO 'root'@'localhost' REQUIRE NONE WITH GRANT OPTION MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0;

If everything went well you can now log in via phpmyadmin
Hardware: AS3102T || AS-202TE
santtu1980
 
Posts: 6
Joined: Fri Dec 13, 2019 5:34 pm

Return to phpmyadmin

  • You cannot post new topics in this forum
    You cannot reply to topics in this forum
    You cannot edit your posts in this forum
    You cannot delete your posts in this forum
    You cannot post attachments in this forum
  • Who is online

    Users browsing this forum: No registered users and 1 guest