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.
max_queries_per_hour
Moderator: Lillian.W@AST
-
- Posts: 6
- youtube meble na wymiar Warszawa
- Joined: Fri Dec 13, 2019 5:34 pm
max_queries_per_hour
Hardware: AS3102T || AS-202TE
-
- Posts: 6
- Joined: Fri Dec 13, 2019 5:34 pm
Re: max_queries_per_hour
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
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