Page 1 of 1

Ooops... accident!

PostPosted: 25. December 2006 03:09
by jp128
I accidentally deleted the mysql root username... i dont know what I was thinking! what do I do?!

Re: Ooops... accident!

PostPosted: 25. December 2006 03:28
by Izzy
jp128 wrote:I accidentally deleted the mysql root username... i dont know what I was thinking! what do I do?!

You could try:
xampp\mysql\restroot.bat

PostPosted: 25. December 2006 03:32
by jp128
Error

MySQL said:
Cannot connect: invalid settings.

PostPosted: 25. December 2006 03:40
by Izzy
Try logging in to phpMyAdmin using the user pma usually with no password.

If you have the privelges with pma try and create the root user again from the Priveleges menu in phpMyAdmin.

Also I found this from a Google search:
http://www.experts-exchange.com/Databas ... 54667.html

I did not test it but you might care to if the pma is not successful.
If it works for you then post back here so others might benefit also.

If all else fails then the general consensus is to re-install.