Deleted the root acount and now can;t get in.

[AltF4]

The title says it, but I get this messge:



Welcome to phpMyAdmin 2.9.0.2

phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in config.inc.php and make sure that they correspond to the information given by the administrator of the MySQL server.
Error

MySQL said: Documentation
#1045 - Access denied for user 'root'@'localhost' (using password: NO)

All I want to do is reset ALL of the files. How do I do that?

[LiLcRaZyFuZzY]

did you delete the `mysql` dB/ the `user` table? or just the `root` user from the `mysql.user` table?

do you know how to access mysql through the command line?

[AltF4]

No I do not. I just deleted the root account and made a new one.

[chazzy]

phpMyAdmin has a config file somewhere ( i think it's literally config.php ) that contains the dba level user that it connects as.

is this on your own private machine or a hosted system? if it's hosted, they should be able to fix it for you.

[AltF4]

I am hosting it, and I cannot find where in the config.php file.

Is there a way JUST to redo all the files back to default?

[chazzy]

you can just go ahead and reinstall it, that should work.

[LiLcRaZyFuZzY]

you could also just overwrite the "mysql" folder in mysql/data
i'll send you the compressed version

[AltF4]

I did. It is localhost if that helps.

[LiLcRaZyFuZzY]

what?! now im confused,
you did reinstall it, and it still doesn't work?