MySQL Password Generator

The MySQL Password Generator Tool generates secure hashes that match the format used by MySQL’s native PASSWORD() function. It performs a double SHA-1 hash of your input string and prepends the result with an asterisk, exactly as expected by MySQL authentication systems. Everything runs locally in your browser and updates live.

Paste your password above or import a file below.
No file chosen
Supported file types: .txt, .csv, .json, .log, .md, .yaml, .yml
Total characters: 0

How to Use:

  1. Paste or type your password into the input field on the left.
  2. Optionally, upload a .txt, .csv, or similar file using the Choose File button.
  3. The right-hand output box shows the hashed result instantly.
  4. Click Copy Output to copy the hash to your clipboard.
  5. Select Export to File to save the result as a .txt.
  6. Use Clear All to reset both fields and file state.

What MySQL Password Generator Tool can do:

This tool reproduces MySQL’s legacy password hashing by using two rounds of SHA-1 and formatting the output as *HEX. It’s a fast, private way to generate database-ready hashes without needing a server or SQL console. You can test or precompute hashes for scripts, user creation, or migrations with full support for file input, live preview, and export.

Example:

Input:

secret123

Output:

*9A1A0D385BA72ACF47DF7DBAB6B8AC16230C0E45

Common Use Cases:

  • SQL dump and migration scripts
  • Storing sample hashed passwords
  • Testing login hash matching
  • Teaching MySQL authentication formats

Useful Tools & Suggestions:

If you’re setting up credentials across different systems, MariaDB Password Generator is a quick way to keep things secure on that platform too. And for extra flexibility, Strong Password Generator lets you tweak strength, symbols, and length to match your security standards.

Related Tools