0

Is there any way with which I can view the password of mysql current user using query.

Deepak Singh Rajput
  • 315
  • 1
  • 4
  • 13
  • No, passwords are hashed. You should know the password though if you are connecting, it is one of the parameters. – user3783243 Feb 19 '22 at 19:39
  • Does this answer your question? [How do I retrieve my MySQL username and password?](https://stackoverflow.com/questions/4371/how-do-i-retrieve-my-mysql-username-and-password) – user3783243 Feb 19 '22 at 19:40

1 Answers1

1

MySQL passwords for users are stored within MySQL itself; they are stored in the mysql.user table. The passwords are hashed by default using the PASSWORD() function. You cannot find the password from the hash.