Question 20318 in Mysql Question posted in
The official MySQL documentation can be found here.

Login to phpMyAdmin with encrypted password – Mysql

I am using MariaDB 10.6.

I have a user "test" with a password, the password is MySQL encrypted, which is like ‘*E494B31EA7DDA68A012783C852F1AB397877B17A‘

The only thing is I don’t have the plain password, or honestly, I don’t want to store them.

I want to log in to phpMyAdmin via singon auth type, but how do I make login using this encrypted password and not the plain password? Is there any way?

Tags:

2

Answers


  1. 0

    In a word, no.

    The point of these hashed passwords is that it’s possible to validate the plain text password without storing in in a form that can be retrieved by an intruder to your database.

    Login or Signup to reply.
  2. 0

    phpMyAdmin isn’t a database, it’s just an aggregation tool. To login to phpMyAdmin, you’ll have to use the username and password setup on your MySQL database.

    MySQL comes with a default user/pass, but it lets you add your own users for accessing the database. By default, the passwords are encrypted when created via the MySQL command line.

    If you have a hashed/encrypted password and need to find out what the plain text value is, you can usually search it up and find out online, as hash algorithms like MD5 are no longer considered secure because most of the common hashes have been cracked.

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search