Skip to content

Instantly share code, notes, and snippets.

@lilongen
Last active January 29, 2018 03:17
Show Gist options
  • Save lilongen/38ec6ad31853b6b2668581effff42df9 to your computer and use it in GitHub Desktop.
Save lilongen/38ec6ad31853b6b2668581effff42df9 to your computer and use it in GitHub Desktop.
mysql5.7 usage after install
1. MySQL5.7+ generates a temporary random password after installation and stored in /var/log/mysqld.log
2. get the temporay password to reset root password
grep "A temporary password is generated for root" /var/log/mysqld.log
3. a. mysql> uninstall plugin validate_password;
b. /etc/my.cnf
validate_password_policy=LOW
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment