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