phpmyadmin - Error#1142

[Shay_Grey]

First time using phpmyadmin and I screwed it up.

In phpmyadmin, I mistakenly deleted a user in the privileges tab. I don't remember what it was except that it was the third one from the bottom.

The error I am now getting is this:

SQL QUERY: (? icon) (pencil icon)

INSERT INTO 'phpmyadmin'.'pma_history'(
'username',
'db',
'table',
'timevalue',
'sqlquery'
)
VALUES (
'root',",",NOW(),'SELECT*, IF ('Password'=_latin1 "","N","Y") AS "Password" FROM 'mysql','user', ORDER BY 'User' ASC, 'Host' ASC,'
)

#1142 - INSERT Command denied to user ''@'localhost' for table 'pma_history'

Any idea how to restore what I deleted?

[henry0]

Shay_Grey, welcome to WebmasterWorld!

hmmm what's done is done, sorry.

You might have deleted “root” .
You may delete any other user and create as many users as you wish with a palette of different privileges, but do not rem root.

here is what you could do
if phpMyAdmin, is located on your local machine
go to mysql/data/ select all your stored DB and copy them away from your www/
Then simply uninstall the whole php, MySQL, etc.. application and reload it.
If you are using a WAMP or a XAMP it will take you two minutes to get back in biz.

If you are on a local machine and use a custom made LAMP, you won't have much trouble to del and reload a fresh phpMyAdmin.

If this is on server, most of the time you will find your .sql in var/lib/mysql/
if not ask your ISP for the correct location or to get that for you and reinstall a new phpMyAdmin
Good luck

BTW
pencil = "edit"