Home · Latest · Trends  /  mysql

Check MySQL users for empty passwords

rated 1 times [  1] [ 0]  / comments: 6 / hits: 779  / 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


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
commented 5 months ago
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
commented 5 months ago
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
commented 4 months ago
No matter which application you are using you required a unique password. So for this there is resumevalley that can help to facilitate more and more in all the important positions.
[#184] Friday, August 16, 2019, 03:54:12
commented 2 months ago
Your blog is really great. i am glad to read your blog.i am glad to read your blog.its really cool and great.your blog is really awesome and cool.tanks for college essay writing help sharing the nice and cool post.
[#250] Sunday, September 29, 2019, 12:57:39
commented 3 weeks ago
Awesome blog. I enjoyed reading your articles. This is truly a great read for me. I have bookmarked it and I am looking forward to reading new articles. Keep up the good work! navien tankless water heaters installation
[#467] Saturday, October 19, 2019, 12:50:36
commented 8 hours ago
Only authorized users can post. Please sign in first, or register a free account


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