In phpmyadmin our main user usually "root" its stored on a Da开发者_开发问答taBase called "mysql" under the "users" table.
My question is, the password under a user, in which format is encrypted? md5? sha1? base64?
This is not really related to phpMyAdmin ; it depends on the MySQL server itself -- phpMyAdmin being only the tool you're using to interrogate MySQL.
Anyway, this section of MySQL's manual should help you : Password Hashing in MySQL : (quoting) :
what is stored in the
Password
column of theuser
table is not the plaintext version of the password, but a hash value computed from it.
Password hash values are computed by thePASSWORD()
function.
精彩评论