How to remove password complexity from MySQL

Hello Techrunn readers, this document deals with how to remove password complexity from mysql.
Removing password complexity is not a good habit, even though there is some certain condition which makes us remove the complexity due to lack of application support to special characters etc.

By default password validate plugin installed with MySql. In order to remove password complexity, you just need to remove the plugin. Here are the steps to achieve this.

Step 1 : Login to mysql using root user.

mysql -u root -p Password

Step 2: Remove the validate_password Plugin

uninstall plugin validate_password;

Step 3: Now you can reset the password with less complexity.

mysql_secure_installation

That’s it

Happy Learning!!!

© 2018, Techrunnr. All rights reserved.

#1
Questions Answered
Articles Written
Overall Points

Prabhin Prabharkaran

He is Technical professional. He is a person who loves to share tricks and tips on the Internet. He Posts what he does!!

Leave a Reply

Your email address will not be published. Required fields are marked *

Please wait...

Subscribe to our newsletter

Want to be notified when our article is published? Enter your email address and name below to be the first to know.