在OSX狮子(Lion)上安装MYSQL(Install MySQL on Mac OSX)

﹏ヽ暗。殇╰゛Y 2022-09-22 11:57 224阅读 0赞

这篇文章简述了在Mac OSX狮子(Lion)上安装MySQL Community Server最新版本 v10.6.7的过程.

[MySQL][]是最流行的开源数据库管理系统。首先，从 [MySQL的下载页面][MySQL 1]上下载适用于你机器环境的MySQL版本。比如，对于Mac OSX狮子，可以下载64位版本的mysql-5.5.22-osx10.6-x86\_64.dmg。MySQL的详细安装说明在 *MySQL参考手册*(MySQL Reference Manual)的 *安装和升级(Installing and Upgrading)*章。MySQL参考手册可以在 [MySQL文档页面][MySQL 2]上在线阅读或下载。

下面是针对mysql-5.5.22-osx10.6-x86\_64.dmg的安装流程。下载这个文件后，双击装载(Mount)这个硬盘镜像. 如下图所示，这个镜像包含三个可安装项目。

[![在OSX狮子(Lion)上安装MYSQL(Install <wbr>MySQL <wbr>on <wbr>Mac <wbr>OSX)][OSX_Lion_MYSQL_Install_wbr_MySQL_wbr_on_wbr_Mac_wbr_OSX]][OSX_Lion_MYSQL_Install_wbr_MySQL_wbr_on_wbr_Mac_wbr_OSX_OSX_Lion_MYSQL_Install_wbr_MySQL_wbr_on_wbr_Mac_wbr_OSX]

第一项 *mysql-5.5.22-osx10.6-x86\_64.pkg*是MySQL应用程序本身。双击这个文件开始安装。安装的过程很直接，所以就不详述了。如果遇到问题，可以从 *ReadMe.txt*文件中寻找答案 *。*

在安装完MySQL后，可以选择安装其它的两个项目。 *MySQL.prefPance*在系统偏好设置(SystemPreferences)中创建一个MySQL项目(如图1所示)。用户可以通过它启动和停止MySQL服务器(如图2所示)。

如果你想让MySQL在系统启动时自动启动，就必须用第三个包 *MySQLStartupItem.pkg*安装MySQL自动启动模块(MySQL Startup Item) *。*双击 *MySQLStartupItem.pkg*即开始安装。安装的过程很直接，如果遇到问题，可以从 *ReadMe.txt*文件中寻找答案 *。*MySQL自动启动模块被装在/Library/StartupItems/MySQLCOM目录. 这个模块还在系统配置文件'/etc/hostconfig'中添加了一项' *MySQLCOM=YES-'*  。如果不想自动启动MySQL，可以将这一项设为NO，即' *MySQLCOM=NO-*'.

[![在OSX狮子(Lion)上安装MYSQL(Install <wbr>MySQL <wbr>on <wbr>Mac <wbr>OSX)][OSX_Lion_MYSQL_Install_wbr_MySQL_wbr_on_wbr_Mac_wbr_OSX 1]][OSX_Lion_MYSQL_Install_wbr_MySQL_wbr_on_wbr_Mac_wbr_OSX_OSX_Lion_MYSQL_Install_wbr_MySQL_wbr_on_wbr_Mac_wbr_OSX 1]

图1：在系统偏好设置中的MySQL项目

双击 *MySQL*图标会打开MySQL控制面版.  
[![在OSX狮子(Lion)上安装MYSQL(Install <wbr>MySQL <wbr>on <wbr>Mac <wbr>OSX)][OSX_Lion_MYSQL_Install_wbr_MySQL_wbr_on_wbr_Mac_wbr_OSX 2]][OSX_Lion_MYSQL_Install_wbr_MySQL_wbr_on_wbr_Mac_wbr_OSX_OSX_Lion_MYSQL_Install_wbr_MySQL_wbr_on_wbr_Mac_wbr_OSX 2]

图2：在系统偏好设置中启动/停止MySQL服务器

**用MySQL启动项目(MySQL Startup Item)开始和停止MySQL服务器**

除了可以在系统偏好设置中开始和停止MySQL服务器外，也可以用MySQL启动项目(MySQL Startup Item)做同样的操作。如果要启动MySQL服务器，可以用下面的命令。

shell> sudo /Library/StartupItems/MySQLCOM/MySQLCOM start
    (可能需要输入密码)

停止MySQL服务器则用下面的命令。

shell> sudo /Library/StartupItems/MySQLCOM/MySQLCOM stop

**为用户'root'设置密码**

**MySQL缺省有一个用户'root'。MySQL安装后，用户'root'的密码为空。你可以用下面的命令设置'root'的密码。**

shell> mysqladmin -u root password NEWPASSWORD

新密码设置完成后，你可以用下面的命令或phpAdmin登陆到MySQL。然后，你可以在MySQL的命令行环境中重运行MySQL的命令(例如 'show databases')以确认系统安装正确。

Welcome to the MySQL monitor. Commands end with ; or \g.  Your MySQL connection id is 364 Server version: 5.1.62 MySQL Community Server (GPL) Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> show databases;  +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | test | +--------------------+ 3 rows in set (0.00 sec)

[\[转到中文版本\]][Link 1]

This articles describes how to install the latest version v5.5.22 of MySQL Community Server on Mac OSX Lion (v10.6.7).

[MySQL][]  is the most popular open source database management system. To install MySQL, first download the version that suits your enviroment from  [MySQL's downloading page][MySQL_s downloading page]. For example, for my Mac OSX Lion laptop, I downloaded mysql-5.5.22-osx10.6-x86\_64.dmg.   MySQL's installation instructions can be found in the  *Installing and Upgrading* chapter of MySQL's Reference Manual, which can be viewed online or downloaded on  [MySQL's documentation page][MySQL 2].

Specifically, to install MySQL via  mysql-5.5.22-osx10.6-x86\_64.dmg, double-click to mount this disk image. As shown below, this disk image contains three installable items.

[![在OSX狮子(Lion)上安装MYSQL(Install <wbr>MySQL <wbr>on <wbr>Mac <wbr>OSX)][OSX_Lion_MYSQL_Install_wbr_MySQL_wbr_on_wbr_Mac_wbr_OSX]][OSX_Lion_MYSQL_Install_wbr_MySQL_wbr_on_wbr_Mac_wbr_OSX_OSX_Lion_MYSQL_Install_wbr_MySQL_wbr_on_wbr_Mac_wbr_OSX]

The first item,  *mysql-5.5.22-osx10.6-x86\_64.pkg, *is the MySQL application itself. Double-click this package file and then follow the instructions to install MySQL. It is a straightforward process. If you see any erros, please check  *ReadMe.txt* for special case handlings.

After installing MySQL, you can optionally install the other two items.  *MySQL.prefPance* creates an entry in "System Preferences" so that you can start/stop MySQL service from "System Preferences" pane. To install, double-click  *MySQL.prefPane.* If the installation succeeds, you should see an entry in "System Preferences", as shown below.

*MySQLStartupItem.pkg* should be installed if you want MySQL to start automatically during system startup. Double-click this package file and follow the instructions. The installation process is also quite straightforward. Consult  *ReadMe.txt* for error handlings. The Startup Item is installed into /Library/StartupItems/MySQLCOM. It also adds an entry ' *MySQLCOM=YES-'*  in the system configuration file '/etc/hostconfig'. To disable automatic startup, you can set ' *MySQLCOM=NO-*'.

[![在OSX狮子(Lion)上安装MYSQL(Install <wbr>MySQL <wbr>on <wbr>Mac <wbr>OSX)][OSX_Lion_MYSQL_Install_wbr_MySQL_wbr_on_wbr_Mac_wbr_OSX 1]][OSX_Lion_MYSQL_Install_wbr_MySQL_wbr_on_wbr_Mac_wbr_OSX_OSX_Lion_MYSQL_Install_wbr_MySQL_wbr_on_wbr_Mac_wbr_OSX 1]

Double-click  *MySQL* icon will open the MySQL pane.  
[![在OSX狮子(Lion)上安装MYSQL(Install <wbr>MySQL <wbr>on <wbr>Mac <wbr>OSX)][OSX_Lion_MYSQL_Install_wbr_MySQL_wbr_on_wbr_Mac_wbr_OSX 2]][OSX_Lion_MYSQL_Install_wbr_MySQL_wbr_on_wbr_Mac_wbr_OSX_OSX_Lion_MYSQL_Install_wbr_MySQL_wbr_on_wbr_Mac_wbr_OSX 2]

**Start/Stop MySQL Server Using MySQL Startup Item**

In addition to start/stop MySQL server from "System Preferences" pane, you can also start/stop it using MySQL Startup Item. To start the server, type the following command in a shell window.

shell> sudo /Library/StartupItems/MySQLCOM/MySQLCOM start
    (ENTER PASSWORD, IF NECESSARY)

To stop the MySQL server, use the following command.

shell> sudo /Library/StartupItems/MySQLCOM/MySQLCOM stop

**Set the password for the user 'root'**

By default, MySQL has a user 'root' with empty password. After installation completes, you can reset the password by running the following command

shell> mysqladmin -u root password NEWPASSWORD

After setting the password, log in to the MySQL server in the shell command or using phpAdmin

shell> mysql -u root --password=NEWPASSWORD test

If log in succeeds, you should see some outputs like below. You can run some sql commands (e.g., 'show databases') to verify MySQL is working properly.

Welcome to the MySQL monitor. Commands end with ; or \g. 
    Your MySQL connection id is 364
    Server version: 5.1.62 MySQL Community Server (GPL)
    
    Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.
    
    Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.
    
    Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
    mysql> show databases; 
    +--------------------+
    | Database |
    +--------------------+
    | information_schema |
    | mysql |
    | test |
    +--------------------+
    3 rows in set (0.00 sec)

[MySQL]: http://www.mysql.com/
[MySQL 1]: http://www.mysql.com/downloads/mysql
[MySQL 2]: http://dev.mysql.com/doc/
[OSX_Lion_MYSQL_Install_wbr_MySQL_wbr_on_wbr_Mac_wbr_OSX]: http://s8.sinaimg.cn/middle/9d6e0355tbc591c685c07&690
[OSX_Lion_MYSQL_Install_wbr_MySQL_wbr_on_wbr_Mac_wbr_OSX_OSX_Lion_MYSQL_Install_wbr_MySQL_wbr_on_wbr_Mac_wbr_OSX]: /images/20220721/c17e0a7be1a74624b7d250e2413191b2.png
[OSX_Lion_MYSQL_Install_wbr_MySQL_wbr_on_wbr_Mac_wbr_OSX 1]: http://s15.sinaimg.cn/middle/9d6e0355tbc593ed229ae&690
[OSX_Lion_MYSQL_Install_wbr_MySQL_wbr_on_wbr_Mac_wbr_OSX_OSX_Lion_MYSQL_Install_wbr_MySQL_wbr_on_wbr_Mac_wbr_OSX 1]: /images/20220721/2a889a5d73004a8f92ac232a36d8b15a.png
[OSX_Lion_MYSQL_Install_wbr_MySQL_wbr_on_wbr_Mac_wbr_OSX 2]: http://s3.sinaimg.cn/middle/9d6e0355tbc593f4c70a2&690
[OSX_Lion_MYSQL_Install_wbr_MySQL_wbr_on_wbr_Mac_wbr_OSX_OSX_Lion_MYSQL_Install_wbr_MySQL_wbr_on_wbr_Mac_wbr_OSX 2]: /images/20220721/116827926beb4fb9831f1c10cd762c63.png
[Link 1]: http://blog.sina.com.cn/s/blog_9d6e035501010jv5.html#chinese
[MySQL_s downloading page]: http://www.mysql.com/downloads/mysql/

发表评论取消回复

表情：

评论列表（有 0 条评论，224人围观）

还没有评论，来说两句吧...

相关阅读

相关 Mac OSX上安装yarn配置环境变量

者今天用mac下载yarn，结果被困扰了一上午。。。第一个原因是因为下载Homebrew用了很久很久很久的时间。。第二个原因就是下载完yarn后使用不了，说找...

比眉伴天荒/ 2024年04月18日 14:59/ 0 赞/ 66 阅读

相关 mac osx使用linux,Mac OSX 或 Linux 运用 tftp

Mac OSX 或 Linux 使用 tftp tar xzvf opentftpmtV1.65.tar.gz cd opentftp 如果是linux可以直接用 Ma

旧城等待，/ 2023年01月21日 13:24/ 0 赞/ 2 阅读

相关在OSX狮子(Lion)上安装MYSQL(Install MySQL on Mac OSX)

这篇文章简述了在Mac OSX狮子(Lion)上安装MySQL Community Server最新版本 v10.6.7的过程. [MySQL][]是最流行的开源数

﹏ヽ暗。殇╰゛Y/ 2022年09月22日 11:57/ 0 赞/ 225 阅读

相关 Mac OSX 安装redis

一、安装redis 1、到官网下载redis最新版本，我下载的是3.0.3 [http://redis.io/][http_redis.io] 2、拷贝redis-3.0

曾经终败给现在/ 2022年07月28日 00:06/ 0 赞/ 202 阅读

相关 Mac OSX网络诊断命令

http://www.cnblogs.com/vamei/p/3784866.html 作者：Vamei 出处：http://www.cnblogs.com/vamei 欢迎

偏执的太偏执、/ 2022年07月13日 05:59/ 0 赞/ 243 阅读

相关 MAC OSX 快速安装 Redis

MAC OSX 快速安装 Redis 一,【前言】安装软件, 常用的用两种方式, 一种是去官网下载,然后一步一步的安装. 方式一: 用b

柔情只为你懂/ 2022年05月30日 00:51/ 0 赞/ 223 阅读

相关 MAC OSX 快速安装 Zookeeper

MAC OSX 快速安装 Zookeeper 一,【前言】安装软件, 常用的用两种方式, 一种是去官网下载,然后一步一步

忘是亡心i/ 2022年05月30日 00:51/ 0 赞/ 232 阅读

相关 MAC OSX 快速安装 rabbitMQ

MAC OSX 快速安装 rabbitMQ 一,【前言】安装软件, 常用的用两种方式, 一种是去官网下载,然后一步一步的安装. M

╰+攻爆jí腚メ/ 2022年05月30日 00:51/ 0 赞/ 240 阅读

相关 Mac OSX下的MySQL数据库升级

> Mac OSX 下的数据库升级最麻烦的不过权限的问题. > > 本文的MySQL的安装方式为OSX下DMG磁盘镜像的安装方式, Mac Ports/Homebrew 的方

傷城~/ 2022年02月23日 03:16/ 0 赞/ 201 阅读

相关 minikube OSX安装

四步安装命令 1.安装vsbox brew cask install virtualbox 2.安装docker brew install

绝地灬酷狼/ 2022年01月28日 08:29/ 0 赞/ 215 阅读