Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

Is it feasible to reset a normal user's mysql password without using root privileges?

I can login using old password but being a non-root user, can't use mysql table.

share|improve this question

migrated from stackoverflow.com Aug 6 '11 at 8:01

This question came from our site for professional and enthusiast programmers.

3 Answers 3

I think it is only possible if the normal user has privileges to update mysql.user table.

share|improve this answer

You can't reset other user's password without root privs.

But if you have root access to system running MySQL server, you can start mysql with --skip-grant-tables, which would allow you to log in without password as root and so change any password. See here: http://www.cyberciti.biz/tips/recover-mysql-root-password.html

share|improve this answer

you can try mysqladmin, but if you just have common table privileges it probably won't let you do it...

mysqladmin -u <USERNAME> -p password <YOUR NEW PASSWORD>

It will then ask you for your current password.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.