mysql installation - sandeepvalapi/DevOps GitHub Wiki

Install MYSQL in Mac OSX

1. Download mysql from below link Download here
2. Extract and double click on the dmg file
3. Once extracted, follow the steps and in the last step you will be show with a popup which has one time root password in it.
4. Make note of one time password. Thats all, installation is completed.
5. Update environment variables by navigating to ~/.bash_profile and add below line export PATH=$PATH:/usr/local/mysql/bin
6. Now after installation, open Terminal and type mysql -u root -p
7. Now enter the copied one time password
8. Now Change your Master root password to any other by following below steps https://www.variphy.com/kb/mac-os-x-reset-mysql-root-password

Note: As per Mysql 5.7 they changed password column to authentication_string. Please consider this when you try to update your password https://stackoverflow.com/questions/30692812/mysql-user-db-does-not-have-password-columns-installing-mysql-on-osx