WampServer

Hello,

Is there a posibility to reinstall only mysql?

I made some changes into the user database and I cannot connect anymore

ERROR 1130 (HY000): Host 'localhost' is not allowed to connect to this MySQL ser
ver

Thanks

Rather than reinstall it, try doing an upgrade.

But if you really want to reinstall it, I'd download the MySQL and install it where you currently have it with an overwrite command.

Before you do that, though, have you tried to undo the changes you made? Also check your privilges to make sure they're set correctly.

As a suggestion for you, before you make any changes to your db make a full backup of the current db, including all data. Save it as a "Replace" command if you can, or "Insert". Then when you run into this problem drop the tables and upload the old db to the SQL and it will bring everything back to where it was before the changes are made.

STK

Hello,

I just uninstall/reinstall wamp and all the databases were kept.

And I have full controll as a root on localhost

I changed my password, everything was ok until I rebooted, then I got the dreaded 1130 error.
re-installed wamp. my database is gone, but at least I can get in again.

you can see my phpmyadmin users tutorial here:
[forum.wampserver.com]

CyberSpatium
WAMP English Forum Admin