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 Aug 6 '11 at 8:01

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

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:

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


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