MySQL mac 安装

选择community server, 然后下载了dmg文件

其中，安装过程中，会告诉你一个临时的密码，一定记住。

 

安装完毕后，打开终端，启动mysql server

<span style="color: #0000ff;">sudo</span> /usr/local/mysql/support-files/mysql.server start

然后，启动mysql

mysql -u root -<span style="color: #000000;">p
# 需要输入安装时提供的临时密码
# 进入MySQL后，重设密码
mysql</span>> SET PASSWORD = PASSWORD(<span style="color: #800000;">"</span><span style="color: #800000;">你的密码</span><span style="color: #800000;">"</span>);

 

导入数据

<span style="color: #000000;"># 创建数据库
</span><span style="color: #0000ff;">create</span> <span style="color: #0000ff;">database</span><span style="color: #000000;"> snps
</span><span style="color: #0000ff;">use</span> <span style="color: #0000ff;">database</span><span style="color: #000000;"> snps

# 创建表
</span><span style="color: #0000ff;">create</span> <span style="color: #0000ff;">table</span><span style="color: #000000;"> snps_table
(
    id </span><span style="color: #0000ff;">char</span>(<span style="color: #800000; font-weight: bold;">20</span><span style="color: #000000;">),
    chr </span><span style="color: #0000ff;">char</span>(<span style="color: #800000; font-weight: bold;">10</span><span style="color: #000000;">),
    pos </span><span style="color: #0000ff;">int</span><span style="color: #000000;">
);

# </span><span style="color: #0000ff;">load</span> data <span style="color: #0000ff;">to</span> <span style="color: #0000ff;">table</span>
<span style="color: #0000ff;">load</span> data local infile <span style="color: #ff0000;">‘</span><span style="color: #ff0000;">test.csv</span><span style="color: #ff0000;">‘</span> <span style="color: #0000ff;">into</span> <span style="color: #0000ff;">table</span> snps_table fields terminated <span style="color: #0000ff;">by</span> <span style="color: #ff0000;">‘</span><span style="color: #ff0000;">,</span><span style="color: #ff0000;">‘</span> lines terminated <span style="color: #0000ff;">by</span> <span style="color: #ff0000;">‘</span><span style="color: #ff0000;">
</span><span style="color: #ff0000;">‘</span><span style="color: #000000;">;

# </span><span style="color: #0000ff;">check</span><span style="color: #000000;"> data
</span><span style="color: #0000ff;">select</span> <span style="color: #808080;">*</span> <span style="color: #0000ff;">from</span> snps_table

 

暂时就这样

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

MySQL mac 安装

标签：

本文系统来源：http://www.cnblogs.com/foreverycc/p/5484272.html

【说明】：本文章由站长整理发布，文章内容不代表本站观点，如文中有侵权行为，请与本站客服联系(QQ:254677821)！