Home · Latest · Trends  /  mysql
1

Check MySQL users for empty passwords

rated 1 times [  1] [ 0]  / comments: 3 / hits: 373  / 1 year 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

0
If you are a fan of 5v5 MOBA games, download Mobile Legends Bang Bang for PC! Best Mobile Legends guide, hacks and cheats here. Download game mobile legend Bang Bang for PC now!
[#58] Thursday, June 6, 2019, 07:50:55
 
ajalexxx
commented 2 weeks ago
0
Many thanks for the exciting blog posting. I really enjoyed reading it, you are a brilliant writer. I actually added your blog to my favorites and will look forward for more updates. Great Job,Keep it up. tree trimming
[#61] Wednesday, June 12, 2019, 03:57:57
 
fredluis721
commented 1 week ago
0
Hello, i think that i saw you visited my website so i came to return the favor? I’m trying to find things to improve my site!I suppose its ok to use some of your ideas!! electrician Tallahassee
[#91] Thursday, June 20, 2019, 01:45:14
 
joshuaprice153
commented 9 hours ago
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: 124
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