Home / server / Questions / 326649
Accepted
Frank Vilea
Asked: 2011-11-02 05:08:44 +0800 CST

Security: Where are MySQL passwords stored?

  • 772

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

mysql security

3 Answers

  1. Best Answer

    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

    • 17

  2. 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.

    • 7

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

    http://www.grahamwideman.com/gw/tech/mysql/perms/index.htm

    • 0