MySQL mac Installation

The installation of MySQL Mac took some effort. Initially want to save trouble with brew installation, the result is always a problem, the original brew installation MySQL is not so simple, but also some configuration. Simply go to the website to download:

http://www.mysql.com/downloads/selection

Select Community Server and download the DMG file

Which, during the installation process, will tell you a temporary password, be sure to remember.

When the installation is complete, open the terminal and start the MySQL server

sudo /usr/local/mysql/support-files/mysql.server start

Then, start MySQL

Mysql-u root-p# need to enter the temporary password provided during installation # after entering MySQL, reset password mysql> Set PASSWORD = PASSWORD (" your password " /c8>);

Import data

# Create a databaseCreate DatabaseSNPs Use Databasesnps# Creating a tableCreate Tablesnps_table (IDChar( -), ChrChar(Ten), POSint);# LoadData to TableLoadData local infile'Test.csv'  into TableSnps_table Fields terminated by ','Lines terminated by '\ r';# CheckDataSelect *  fromSnps_table

That's it for the moment

ref:http://xiaoxuetu.github.io/2015/11/19/mysql-environment/

MySQL mac Installation