MySQL Root - Max Quirers Per Hour - URGANT

[Neo13]

EDIT:
Error is:
.#1226 - User 'root' has exceeded the 'max_questions' resource (current value: 10)

Urgant error!

I accidently set for user account "root" max quieres 10 per hour. now soon as i load up sql it already reaches the max.

I havnt added anymore users so if you could tell me the file where users are kept and data.

First i try and fix it in the users data file or where ever it is w/e

if not i replace it.

Any ideas on what i can do?

Im using:
Windows XP
Xampp Beta - MySQL 5.0 - Apache 2.2.2 - With Perl Addon

Now im just stuck.

Thanks for the lovely xampp and i hope i get a fix soon!
Cheerz
Matthew.

[Tessi]

Hi Neo,

I accidently set for user account "root" max quieres 10 per hour. now soon as i load up sql it already reaches the max.

What about changing this back to its old value in the same way (well ...same accident)?

best regards,
Tessi

[Neo13]

Hi Neo,

I accidently set for user account "root" max quieres 10 per hour. now soon as i load up sql it already reaches the max.

What about changing this back to its old value in the same way (well ...same accident)?

best regards,
Tessi

How? I dont know how because i locked myself out of phpmyadmin because it still says that the max quirers are reached.

Reboot and it loads abit and then locks again because its reached just by loading phpmyadmin.

[Wiedmann]

Simply use the mysql console client "mysql.exe".

[Neo13]

Simply use the mysql console client "mysql.exe".

Do i have to run commands on that or will it just load up a panel?

Opened up says:

ERROR 1045 (28000): Access denied for user 'ODBC'@'localhost' (using password: NO)

[Neo13]

Well any suggestions? I need a fix!

[Naneau]

Code: Select all

start >> execute >> cmd >> cd-to-xampp-dir >> cd mysql >> cd bin

type the following:

Code: Select all

mysql.exe -u root -p

Give your root password when it asks for it. You are now in the mysql console. You now want to select the database to use, which, in this case, is the mysql database.

Code: Select all

USE mysql

the information you want to change (max questions) is in the 'user' table. For root I would strongly advice a setting of '0', to avoid problems like this.

Code: Select all

UPDATE mysql SET `max_questions` = 0 WHERE `user` = 'root';

will do that for you. Good luck!

P.S. to exit the mysql command line tool type:

Code: Select all

exit

[Neo13]

EDIT: I done it but it didnt work

says that mysql.mysql dont exist

the tabe

when i put in:

Code: Select all

UPDATE mysql SET `max_questions` = 0 WHERE `user` = 'root';

[Neo13]

worked thanks ur the best

[Naneau]

no problem, using an sql command line tool can be a bit difficult if you've never done it before :)