[Initialize mysql database]Initial setup for newly install mysql instance #mysql

initialize.sh

# grep initial password for version 5.7 and above
grep 'temporary password' /var/log/mysqld.log 

# reinitialize database (create database directories and system databases)
mysqld --initialize --console

# set new password (no hash function or password function called)
set password = 'new password';

# do as it says
uninstall plugin validate_password;

# disable validate_password plugin
sudo vi /etc/my.cnf # add 'validate_password=off'