how to remove password complexity from mysql1 min read

Prabhin Prabharkaran Administrator
DevOps Engineer

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

follow me

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
#2
#3
Questions Answered
Articles Written
Overall Points

Related posts

Leave a Reply