Root locked out - Error 1226

[lost]

I accidently changed the 'max connections' resource in the MySQL admin section to be '1' instead of 0, which means i've locked myself out through the GUI.
Can someone please help me change it through the command line or any other way!!

[frankm]

try shutting down your apache server - that will free the 1 possible connection :) then wait a while for all "WAITING FOR .." threads to complete and try to login again and shut the mysql server down.

If that still doesnt work, alter the my.cnf file to accept multiple connection again and kill the mysql server the hard way (kill <pid>). When you re-started the mysql daemon, run a mysqlcheck -A -r command to check + repair broken tables/indices

good luck

[blinxdk]

Edit /etc/my.cnf or /etc/mysql/my.cnf or equivilant.

Change/insert max_connections = xxx, then reload mysql (that might be enough too).

You might have trouble reloading mysql as that proberly uses mysqladmin and a connection, so a last way out is to kill the mysql server and then restart.

I take no responsibility if that corrupts your data...

[frankm]

I take no responsibility if that corrupts your data...

that applies to my post as well :)

[lost]

Thanks guys, but shutting down the apache server along with the mysql server doesn't work????

Also, i can't find a file /etc/my.cnf or equivalent.

I can't access the command line either.

[lost]

I'm not sure if the 'my.ini' file is an equivalent, but i did check in there and there is a line for max_connections...the weird thing is that its set to 100!!
i'm soo confused :confused:

[blinxdk]

Well you changed the variable for the running server, so it will not be adjusted before you reload the mysql server. Is this Windows or Linux or?

Under Linux a kill -HUP <pid> might do the trick - not 100% sure.

[lost]

I didn't change it though...it was already at 100.
Its under Windows.

[blinxdk]

hmm.. I don't really know anything about windows - if it's running as a service, maybe you can restart that? Else I hear the fix to everything under windows is a reboot :)

[lost]

Tried the reboot, still nothing.
I ended up removing and installing MySQL...everything is fine and dandy.

Thanks for your help.