Home · Latest · Trends  /  mysql
1

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
 

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 5 months 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 5 months 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 4 months ago
0
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
 
Dolllups
commented 2 months ago
0
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
 
freddie.greenberg
commented 3 weeks ago
0
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
 
rogerlagasca
commented 8 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: 128
Total Comments: 1
Location: n/a
Following
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