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);

Comments

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

ajalexxx

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

fredluis721

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

joshuaprice153

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

Dolllups

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

freddie.greenberg

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

rogerlagasca

Only authorized users can post. Please sign in first, or register a free account

Sponsor

Posted