maria-discuss team mailing list archive
Mailing list archive
Re: Best way to fetch user’s password hash?
On Aug 10, Felipe Gasper wrote:
> Hi all,
> What is the best way to fetch a user’s password hash? I’d ideally like
> something that works in both MySQL and MariaDB, as many versions as
> Thank you!
You can select from mysql.user. You can use IF() function to create a
select that returns a password no matter what column it's in.
It'd be the most universal way, I think.
There're also SHOW GRANTS and SHOW CREATE USER, but they output is
version dependent and might have weird privilege requirements to see the
Chief Architect MariaDB