CODEWITHSUNDEEP
phpmysqlauthenticationphpmyadmin
rupGo
rupGo

Reputation: 410

phpmyadmin auth protocol for encryption

In phpmyadmin our main user usually "root" its stored on a DataBase called "mysql" under the "users" table.

My question is, the password under a user, in which format is encrypted? md5? sha1? base64?

Upvotes: 0

Views: 607

Answers (1)

Pascal MARTIN
Pascal MARTIN

Reputation: 401182

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 the user table is not the plaintext version of the password, but a hash value computed from it.
Password hash values are computed by the PASSWORD() function.

Upvotes: 2

Related Questions