Check MySQL users for empty passwords

rated 1 times [ 1] [ 0] / comments: 4 / hits: 472 / 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 3 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 2 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 2 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 days ago

Dolllups

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

Sponsor

Posted