[SOLVED] MySQL root removed

abakhiet · 09-16-2010, 08:36 AM

Hola,
Please help me, when i'm trying make some edit to a mysql user, i delete by error my root user and i can't do anything now.
I try to add this command, but the output was:

Quote:

mysqladmin -u root password new-password
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'

Please help me.
Thanks in ADVANCE

druuna · 09-16-2010, 08:43 AM

Hi,

This should work: Resetting the Root Password: Unix Systems (dev mysql)

Hope this helps.

abakhiet · 09-16-2010, 09:34 AM

hmm, sory i think you are not understand me, i delete the root user from mysql

druuna · 09-16-2010, 10:03 AM

Hi,

I did understand you and assumed your mysql knowledge would be sufficient to go from what I posted before.

Maybe this is more to your liking: How to recreate root account in MySQL

Hope this helps.

abakhiet · 09-16-2010, 11:49 AM

Thanks for you, every thing is done, and my root is returns to its work ...

druuna · 09-16-2010, 12:32 PM

You're welcome