Some time back I accidentally deleted the mysql root user. Then when checked mysql then mysql is not accessible to me from root user.
I am using the fedora 14 on my machine. After trying so many things at the end I found the solution.
use the following steps:
First I stoped mysql using following command.
#/etc/init.d/mysqld stop
Then I created one file with following conent
#file mysql_reset
UPDATE mysql.user SET Password=PASSWORD(‘newpassword’) WHERE User=’root’;
#mysqld_safe –init-file=/home/techiego/mysql-init &
Than again I stooped mysql process and restarted mysql. I was able to access my mysql again.
mistakenly I deleted the mysql root user
I REALLY liked your post and blog! It took me a minute bit to find your site…but I bookmarked it. Would you mind if I posted a link back to your post?
I would like to say “wow” what a inspiring post. This is really great. Keep doing what you’re doing!!
Intriguing post. I have been searching for some good resources for solar panels and discovered your blog. Planning to bookmark this one!
Hello, this is my first time i visit here. I found so many interesting in your blog especially on how to determine the topic. keep up the good work.
I was just having a conversation over this I am glad I came across this it cleared some of the questions I had.
This post makes a lot of sense !
I REALLY liked your post and blog! It took me a minute bit to find your site…but I bookmarked it. Would you mind if I posted a link back to your post?
I’ve just started off a blog, the knowledge you give on this site has aided me extremely. Thank you for all your time & work.
I would like to say “wow” what a inspiring post. This is really great. Keep doing what you’re doing!!
This post makes a lot of sense !
Good! Thank you! I always wanted to write in my site something like that. Can I take part of your post to my blog?
Good! Thank you! I always wanted to write in my site something like that. Can I take part of your post to my blog?
I was just having a conversation over this I am glad I came across this it cleared some of the questions I had.
I’ve been checking your blog for a while now, seems like everyday I learn something new
Thanks
Interesting read, perhaps the best article iv’e browse today. We learn everyday cheers to you!