User manager show "empty password"

[expired user #7681]'s profile image [expired user #7681] posted 7 years ago in General Permalink

If you open the "user manager", you will see that it always shows "empty password", but it does exists. The query is: SELECT user, host, authentication_string FROM mysql.user; and should be SELECT user, host, password FROM mysql.user;.

If authentication_string is something new, maybe you can support both, checking if password is not empty too.

ansgar's profile image ansgar posted 7 years ago Permalink

Since MySQL 5.7.6, the password is stored in authentication_string, not in the password column. Or?

[expired user #7681]'s profile image [expired user #7681] posted 7 years ago Permalink

It seems correct, but by some reason my MariaDB still uses password column. It is a fresh install of version 10.1.14 for Win64. It should be happen on 5.5, right?

Please login to leave a reply, or register at first.