reset mysql root account password

sniper8752 · 05-07-2013, 05:33 PM

How do I reset the mysql root account password? I am running ubuntu.

kbp · 05-07-2013, 05:41 PM

C'mon .. a tiny bit of searching gives this: http://dev.mysql.com/doc/refman/5.0/...rmissions.html.

Please try to help yourself a little before posting .. if the instructions didn't work for you, then would be a good time to post.

sniper8752 · 05-07-2013, 05:55 PM

Sorry - should have mentioned, I did try this...

I tried this, but when I do step #2, the last line does not show up for me for the output.

http://www.cyberciti.biz/tips/recove...-password.html

Why does it just hang there? Is it because of the "&" symbol?

kbp · 05-07-2013, 06:30 PM

Ok.. you should be able to just press the enter key after step 2 to get your prompt back

fortran · 05-08-2013, 01:50 AM

If you want to reset root password from command line, follow the method described by kbp above.

If you know root password and you want to change it using UI like phpmyadmin (not command line), you can follow this method but this method works if you know the password.
1) Log-into phpmyadmin using root. Root must have password, you can't log into account using blank or no password.
If you do not have root password, log-in with any user who has privileges like root.
2) Open database mysql and open table user.
3) See there should be username root in the list.
4) Now open this site & generate an encrypted password.
5) Put this encrypted password in password field of root in user table of mysql database.
Now you can log-into root with changed password but for this method you must know password of root or any equivalent user who can change the password in user table.
As you said how to reset, you did not request how to recover forgotten password.

TB0ne · 05-08-2013, 09:33 AM

Quote:

Originally Posted by pavi_kanetkar

If you want to reset root password from command line, follow the method described by kbp above.
If you know root password and you want to change it using UI like phpmyadmin (not command line), you can follow this method but this method works if you know the password.

1) Log-into phpmyadmin using root. Root must have password, you can't log into account using blank or no password.
If you do not have root password, log-in with any user who has privileges like root.
2) Open database mysql and open table user.
3) See there should be username root in the list.
4) Now open this site & generate an encrypted password.
5) Put this encrypted password in password field of root in user table of mysql database.
Now you can log-into root with changed password but for this method you must know password of root or any equivalent user who can change the password in user table.
As you said how to reset, you did not request how to recover forgotten password.

Why would ANYONE go to some website to generate a password? And more importantly, why wouldn't you just use phpmyadmin to change the password directly if you've already got it?? There's already a change password box, and you don't need to enter an 'encrypted' password, since the phpmyadmin tool does that behind the scenes:
http://www.synology.com/support/faq_show.php?q_id=319

OP, have you gotten your prompt back as kbp suggested? If not, you can just SSH to the Linux system, get a root shell, and type in "mysql". At that point, you SHOULD be in MySQL as the root user, and able to follow these directions:
http://en.kioskea.net/faq/630-mysql-...-root-password
http://dev.mysql.com/doc/refman/5.0/...rmissions.html

sniper8752 · 05-08-2013, 11:43 AM

I was able to recover my root account. I was not able to go in as admin and modify the users. It looks like only a root account user/privileged can perform this task.

fortran · 05-09-2013, 07:11 AM

Quote:

Originally Posted by TB0ne

Why would ANYONE go to some website to generate a password? And more importantly, why wouldn't you just use phpmyadmin to change the password directly if you've already got it?? There's already a change password box, and you don't need to enter an 'encrypted' password, since the phpmyadmin tool does that behind the scenes:
http://www.synology.com/support/faq_show.php?q_id=319

Ya but by this method user can change his/her password only, if he want to change root's password, he can't do this using phpmyadmin because OP said root has no password and without password OP can't log-in as root in phpmyadmin.

That's why I said if user has root privileges. he can change root's password using UI.

TB0ne · 05-10-2013, 10:02 AM

Quote:

Originally Posted by pavi_kanetkar

Ya but by this method user can change his/her password only, if he want to change root's password, he can't do this using phpmyadmin because OP said root has no password and without password OP can't log-in as root in phpmyadmin.

That's why I said if user has root privileges. he can change root's password using UI.

...which STILL doesn't explain why he needs to go to a website to generate a password, since if the user HAD root privileges, they wouldn't NEED to generate anything, just click a button. Also, the 'method' works for ANY password, not just a normal users.