How To Reset root MySQL Password

0
1 year ago
by dextone in , , ,

Today my friend was asking me how to reset or change his root MySQL password, he was faced this problem earlier and got fixed by doing this trick as he wrote them on his blog, but now he said the trick is wasn’t works anymore, he is using Linux Fedora 13 OS on his server and so do I with my desktop, so I got to help him since I am a very nice guy LOL! :D

Okay, so here what I was doing to help him :

I’m trying to kill all mysql proccess with this commands.

killall -9 mysqld ; killall -9 mysqld_safe

And I need to start new mysql proccess without the grant tables.

/usr/libexec/mysqld --skip-grant-tables --user=root &

After the proccess started, I need to update the root passwd in the mysql dbase and flush the privileges.

mysql;
use mysql;
update user set password=password("pler123") where user="root";
flush privileges;
exit;

Now I need to kill my mysql without the grant tables proccess, and start a new one with grant tables loaded, as I updated the privileges earlier.

killall -9 mysqld ; killall -9 mysqld_safe; /etc/init.d/mysqld start

Done. :D

Now he can login into his MySQL database as root with the new passwd, its “pler123″. LOL :D

~dextone

Lets Support Fedora

0
1 year ago
by dextone in ,

Help us spread the excitement!

Are you as excited about the upcoming Fedora release as we are? Share in the fun of the countdown – add a Fedora release countdown widget to your website!

When placed on your website, the counter will appear just like this:
Fedora 14

How to add the counter to your website

To add a Fedora Release counter to your own site, simply place the following code wherever you want it to appear:

<script id="fedora-banner" src="http://fedoraproject.org/static/js/release-counter-ext.js?lang=en" type="text/javascript">

The lang parameter can be changed to display the counter in a different language. Currently, the values de, en, hu, is, it, pt_BR, ru, and tr are supported. When no language is specified, English will be used.

Hello world!

0
1 year ago
by dextone in

This blog is still under maintenance, all my old posts from my old hosting box are shredded, now I must start all of this crap from ZERO!

~dextone

Go to Top