Home · Latest · Trends  /  mysql
1

Check MySQL users for empty passwords

rated 1 times [  1] [ 0]  / comments: 0 / hits: 150  / 6 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
 
Share
Sponsor
Posted
rob

rob

Member since Feb 22, 2017
Total Code Snippets: 118
Total Comments: 1
Location: n/a
Following
User not following anyone yet.
rob snippets
2 yaers ago, wed, feb 22, 2017
2 yaers ago, wed, feb 22, 2017
2 yaers ago, wed, feb 22, 2017
2 yaers ago, wed, feb 22, 2017
2 yaers ago, wed, feb 22, 2017
2 yaers ago, wed, feb 22, 2017
2 yaers ago, wed, feb 22, 2017
2 yaers ago, wed, feb 22, 2017