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.
Step 2: Remove the validate_password Plugin
Step 3: Now you can reset the password with less complexity.
© 2018, Techrunnr. All rights reserved.