Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

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

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

share|improve this answer

Your Answer

 
discard

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