Return to the Forum Home
 Post New TopicNote: Polls are considered new topics.  If you post a poll, it will be created as a new subject in this forum, not as a reply within this topic.Topic Replies: PopIt!Post A Reply
MyPop™ | register | search | faq | forum home


PreviousGo to the next oldest topic in this forum Go to the next newest topic in this forumNext
 friends of ED » friends of ED forums » Books and Information » #1130 - Host 'localhost' is not allowed to connect to this MySQL server

Rating:   Not yet rated
Author Topic:   #1130 - Host 'localhost' is not allowed to connect to this MySQL server
Cal
friend of ED
Describes the mood or content of the topic posted Click Here to See the Profile for Cal   Reply With QuoteEdit or Delete MessageReport This Post
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"... Frown

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!
Cal

Posts: 55 | From: Escondido,California, USA | Registered: 02-29-04
David Powers
Author
Describes the mood or content of the topic posted Click Here to See the Profile for David Powers   Reply With QuoteEdit or Delete MessageReport This Post
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.

David Powers
Author: PHP Solutions
Author: Foundation PHP for Dreamweaver 8
http://foundationphp.com/

Posts: 4331 | From: London, UK | Registered: 12-18-03
Cal
friend of ED
Describes the mood or content of the topic posted Click Here to See the Profile for Cal   Reply With QuoteEdit or Delete MessageReport This Post
Thanks, David!

It took a few tries, but finally got everyone
communicating again.

Lesson learned!
Cal Big Grin

Posts: 55 | From: Escondido,California, USA | Registered: 02-29-04
geraldgrogan
new friend of ED
Describes the mood or content of the topic posted Click Here to See the Profile for geraldgrogan   Reply With QuoteEdit or Delete MessageReport This Post
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
David Powers
Author
Describes the mood or content of the topic posted Click Here to See the Profile for David Powers   Reply With QuoteEdit or Delete MessageReport This Post
Reinstalling does not affect existing data.

David Powers
Author: PHP Solutions
Author: Foundation PHP for Dreamweaver 8
http://foundationphp.com/

Posts: 4331 | From: London, UK | Registered: 12-18-03
Sheila
new friend of ED
Describes the mood or content of the topic posted Click Here to See the Profile for Sheila   Reply With QuoteEdit or Delete MessageReport This Post
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
David Powers
Author
Describes the mood or content of the topic posted Click Here to See the Profile for David Powers   Reply With QuoteEdit or Delete MessageReport This Post
Sorry, I know nothing about XAMPP. Have you tried getting support in the XAMPP forum?

David Powers
Author: PHP Solutions
Author: Foundation PHP for Dreamweaver 8
http://foundationphp.com/

Posts: 4331 | From: London, UK | Registered: 12-18-03

All times are
Post New TopicNote: Polls are considered new topics.  If you post a poll, it will be created as a new subject in this forum, not as a reply within this topic.Post A Reply
Print Page
Printable
Email a Friend
Email a Friend
Topic Replies: PopIt!
PopIt!
MyPop™
MyPop™
Contacts
Contacts
Administrative Links:
Close Topic
Close
Manage Topic
Manage
Delete Topic
Delete
Admin Options
PreviousGo to the next oldest topic in this forum Go to the next newest topic in this forumNext

Rate Topic:

Hop To:

All content copyright 2001-2010 friends of ED. No reuse without permission.

OpenTopic 3.1.0