Plain Text to Hash Converter (bcrypt, for Database)
Turn a plain-text password into the hash your database expects — bcrypt for PHP password_hash and Laravel, WordPress 6.8+ and phpass, MySQL native password, Django PBKDF2, MD5 or SHA — check a hash against a password and get a ready UPDATE query for phpMyAdmin.
About Plain Text to Hash Converter (bcrypt, for Database)
This free tool converts a plain-text password into the hash your database stores, so you can reset a login straight from phpMyAdmin. phpMyAdmin inserts exactly what you type, and an application compares the hash of the password, not the password itself — so you need the hash. Type the new password, pick the format and copy the result.
It supports bcrypt for PHP password_hash, Laravel and most modern PHP apps, WordPress 6.8+ and the older phpass $P$ format, MySQL native password, Django PBKDF2-SHA256, and plain MD5, SHA-1, SHA-256 and SHA-512. Fill in the table and column names to get a ready UPDATE query, or paste a stored hash to check whether a password matches it. Hashing runs in your browser and nothing is uploaded.
How to use Plain Text to Hash Converter (bcrypt, for Database)
- Type the new password in plain text.
- Pick the format your application uses — bcrypt for most PHP apps and Laravel, WordPress, MySQL, Django or plain MD5/SHA.
- Copy the hash, or fill in the table and column names to get a ready UPDATE query.
- In phpMyAdmin open the SQL tab and run the query, or paste the hash into the password column with the Function box left empty.
Frequently asked questions
Why can’t I just type the password in phpMyAdmin?
Applications store a hash, not the password itself, and compare the hash when you log in. phpMyAdmin inserts exactly what you type, so a plain password will never match. Paste the hash from this tool into the column instead, and leave phpMyAdmin’s Function box empty so it is not hashed a second time.
Which format should I choose?
Look at an existing row in the same column: $2y$ is bcrypt (PHP password_hash, Laravel), $wp$2y$ is WordPress 6.8+, $P$ is phpass (older WordPress, phpBB), * plus 40 characters is MySQL native password, pbkdf2_sha256$ is Django, and 32 or 64 hex characters are MD5 or SHA-256. Paste it in the Check box and the tool tells you the format.
Why is the bcrypt hash different every time?
bcrypt, phpass and PBKDF2 add a random salt, so the same password gives a new hash each time. Every one of them is valid — the salt is stored inside the hash and the login check reads it from there.
Is my password sent anywhere?
No. Hashing runs in your browser; only the bcrypt library file is downloaded from a public CDN. Nothing you type is uploaded or saved.
How do I reset a WordPress password in phpMyAdmin?
Open the wp_users table, edit your user and paste a WordPress hash from this tool into user_pass with the Function box empty — or copy the UPDATE query with table wp_users, column user_pass and where user_login. Log in with the new password.
How do I make a bcrypt hash for Laravel?
Choose bcrypt and cost 12 (Laravel’s default), type the password and copy the $2y$ hash into the users table’s password column. Laravel’s Hash::check accepts it.
People also search for
bcrypt generator · plain text to hash · password hash generator online · php password_hash online · wordpress password hash generator · phpmyadmin password hash · laravel bcrypt generator · mysql password hash · bcrypt verify online · django password hash generator