introduction screenshots faq forum blog modules components download
Please use the search function and/or read the FAQ first.

Go to Topic: PreviousNext
Go to: Message ListNew TopicSearchLog InPrint View

Deleted root user. Getting Error #1130. Please help



Posted by: akolamb1
October 23, 2010 07:09AM
Hello all,
Installed EasyPHP and everything was running great.
But i accidently deleted the root user in mySQL.
Now i am getting the following error on [127.0.0.1]
#1130 - Host 'localhost' is not allowed to connect to this MySQL server

I have tried reinstalling easyPHP, but the error still remains.
Please help.
Thanks in advance.
Options: ReplyQuote
Posted by: Thierry
October 23, 2010 12:02PM
where do you delete it ?? in phpmyadmin configuration ?

Maybe you have to delete EasyPHP folder in your VirtualStore folder (google for location)
Options: ReplyQuote
Posted by: Rich
October 24, 2010 02:35PM
I did the same by accident trying to figure out how to change the password. I think I deleted the root user as when trying to go to [127.0.0.1] I get the error

Error
MySQL said:

#1130 - Host 'localhost' is not allowed to connect to this MySQL server

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

I have tried uninstalling and reinstally easy php 3 times but with no luck and after reading another post by Thierry saying to delete virtualstore, I tried this and it made no difference.

Any other help?
Options: ReplyQuote
Posted by: Amour
October 27, 2010 07:44AM
You can try to change my.ini to add "skip-grant-tables" and try to create root again ;)

After, you can stop MySQL and remove skip-grant-tables of my.ini
Options: ReplyQuote
Posted by: akolamb1
October 29, 2010 12:15AM
Hi used the help from the website below.
After some attempts i was able to restore the root user!!

[www.ustrem.org]
Options: ReplyQuote
Posted by: Amour
October 29, 2010 06:39AM
I already explained how to do that ;)
Options: ReplyQuote


Go to: Message ListSearchLog In
Your Name: 
Your Email: 
Subject: 
Spam prevention:
Please, enter the code that you see below in the input field. This is for blocking bots that try to post this form automatically. If the code is hard to read, then just try to guess it right. If you enter the wrong code, a new image is created and you get another chance to enter it right.