MySQL Notes Installation (01)

Posted on   |   In   |     |   Views

MySQL Installation on Mac

In the newest version of MySQL or later one, it has not need to install the startup item “MySQL_StartupItem.pkg”, also use the default password as “root any more. After installed, Pop-up prompts a temporary password, as the message says:

1
2
2016-03-08T15:35:58.686693Z 1 [Note] A temporary password is generated for root@localhost: E%*oVnN?d7sx
If you lose this password, please consult the section How to Reset the Root Password in the MySQL reference manual.

Configure Env.

In terminal, type in “sudo vi /etc/bashrc”，then configure mysql and mysqladmin path in bash.

1
2
3
#mysql
alias mysql='/usr/local/mysql/bin/mysql'
alias mysqladmin='/usr/local/mysql/bin/mysqladmin'

or in user’s path, touch ~/.bash_profile

1
2
MYSQL_HOME='usr/local/mysql/bin'
PATH=$PATH:$MYSQL_HOME

Revise the default password

1
mysqladmin -u root -p password

Login in terminal

1
mysql -u root -p