Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

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

Where are MySQL passwords stored and are they encrypted or even hashed?

share|improve this question
up vote 11 down vote accepted

MySQL passwords are stored in the user table of the mysql database and are encrypted using it's own algorithm.

You can find more information in the MySQL documentation

share|improve this answer
The encryption algorithm is essentially SHA1 – Morgan Tocker Nov 1 '11 at 17:52

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, however there are other alternatives, though none are plain-text.

share|improve this answer

I guess that you mean the database privileges... They are stored in the schema and privilege tables. More specific info is available here:

share|improve this answer
Why would you assume they mean database privileges when the OP specifically states passwords? – DKNUCKLES Nov 1 '11 at 13:20
What I meant was that the OP really wanted the table that holds the global database user list (with passwords) and their privileges... not simply a user created "user authentication" table. Since the question was very vague, it is hard to determine it's true purpose. – compcentral Nov 1 '11 at 13:24

Your Answer


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

Not the answer you're looking for? Browse other questions tagged or ask your own question.