1
Check MySQL users for empty passwords
rated 1 times
[
1]
[
0]
/ comments: 0 / hits: 197
/ 8 months ago, thu, jul 5, 2018, 11:19:36
Good way to check MySQL for users with empty passwords
# Run the following
SELECT User,host
FROM mysql.user
WHERE (plugin IN('mysql_native_password', 'mysql_old_password')
AND (LENGTH(Password) = 0
OR Password IS NULL))
OR (plugin='sha256_password' AND LENGTH(authentication_string) = 0);
More From
» mysql
Comments
There are no comments for this Snippet yet
Only authorized users can post. Please sign in first, or register a free account