posted
Did a dumb thing....I had everything set up, and accidently deleted localhost connection in MySQL (using phpMyAdmin).
"#1130 - Host 'localhost' is not allowed to connect to this MySQL server"...
I tried to use the config wizard to reset the instance...no dice...then deleted the instance, and started over...still unable to connect. Is there a config.inc.php edit I can make or just re-install MySQL altogether? Thanks! CalPosts:
55 | From:
Escondido,California, USA | Registered: 02-29-04
posted
I'm not quite sure what you have done, but since you refer to the configuration wizard, you're obviously on Windows. Uninstall MySQL, go to C:\Program Files\MySQL\MySQL Server 5.0\data, and delete the mysql folder. Then reinstall MySQL.
posted
I read your post while searching for a solution to the very same issue. I did the exact same thing while attempting to grant access to all users, instead I removed access from all users (including myself).
mysqladmin: connect to server at 'localhost' failed error: 'Host 'localhost' is not allowed to connect to this MySQL server'
Any ideas how I can recover?
If I reinstall will I loose all of the data in the database?Posts:
1 | Registered: 05-05-07
posted
I also have this message 'Host is not allowed to connect to this MySQL server'. I am using localhost only as I am not using that machine to connect to the internet. I want to use it for testing and development only.
Mysql was installed through XAMPP. I don't have a mysql folder in Program Files, nor can do I have an entry in the Add/Remove programs. I cannot even remove XAMPP through control panel. How do I fix this problem? Any help would be greatly appreciated.Posts:
1 | From:
UK | Registered: 06-17-07