blocks|key|880516|text|要检查MAMP的MySQL版本，请在终端中使用以下命令：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|880517|/Applications/MAMP/Library/bin/mysql+--version|code-block|syntax|javascript|880518|假设您已经启动了MAMP。|880519|输出示例：|880520|./mysql++Ver+14.14+Distrib+5.1.44,+for+apple-darwin8.11.1+(i386)+using++EditLine+wrapper|880521|mysql更新:mysql此外，如果你想知道在系统中的安装位置，可以使用以下命令：|offset|length|style|BOLD|880522|type+-a+mysql|880523|type+-a等同于OS+X+bash+shell中的tclsh内置命令where。如果找到MySQL，它将显示：|CODE|880524|mysql+is+/usr/bin/mysql|880525|如果未找到，将显示：|880526|-bash:+type:+mysql:+not+found|880527|默认情况下，Mac上不安装MySQL。|880528|符号：对于XAMPP，命令应该是：|880529|/Applications/XAMPP/xamppfiles/bin/mysql+--version|880530|entityMap^0|0|0|0|0|0|M|J|0|0|0|1L|0|7|10|5|0|0|0|A|0|0|0|J|0|0|H|0|0^^$0|@$1|2|3|4|5|6|7|1B|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|1C|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|1D|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|1E|8|@]|9|@]|A|$]]|$1|K|3|L|5|D|7|1F|8|@]|9|@]|A|$E|F]]|$1|M|3|N|5|6|7|1G|8|@$O|1H|P|1I|Q|R]]|9|@]|A|$]]|$1|S|3|T|5|D|7|1J|8|@]|9|@]|A|$E|F]]|$1|U|3|V|5|6|7|1K|8|@$O|1L|P|1M|Q|R]|$O|1N|P|1O|Q|W]|$O|1P|P|1Q|Q|W]]|9|@]|A|$]]|$1|X|3|Y|5|D|7|1R|8|@]|9|@]|A|$E|F]]|$1|Z|3|10|5|6|7|1S|8|@$O|1T|P|1U|Q|R]]|9|@]|A|$]]|$1|11|3|12|5|D|7|1V|8|@]|9|@]|A|$E|F]]|$1|13|3|14|5|6|7|1W|8|@$O|1X|P|1Y|Q|R]]|9|@]|A|$]]|$1|15|3|16|5|6|7|1Z|8|@$O|20|P|21|Q|R]]|9|@]|A|$]]|$1|17|3|18|5|D|7|22|8|@]|9|@]|A|$E|F]]|$1|19|3|-4|5|6|7|23|8|@]|9|@]|A|$]]]|1A|$]]

To check MySQL version of MAMP , use the following command in Terminal: 

<pre><code>/Applications/MAMP/Library/bin/mysql --version
</code></pre>

Assume you have started MAMP .

Example output:

<pre><code>./mysql Ver 14.14 Distrib 5.1.44, for apple-darwin8.11.1 (i386) using EditLine wrapper
</code></pre>

UPDATE: Moreover, if you want to find where does mysql installed in system, use the following command:

<pre><code>type -a mysql
</code></pre>

<code>type -a</code> is an equivalent of tclsh built-in command <code>where</code> in OS X bash shell. If MySQL is found, it will show :

<pre><code>mysql is /usr/bin/mysql
</code></pre>

If not found, it will show:

<pre><code>-bash: type: mysql: not found
</code></pre>

By default , MySQL is not installed in Mac OS X.

Sidenote: For XAMPP, the command should be:

<pre><code>/Applications/XAMPP/xamppfiles/bin/mysql --version
</code></pre>

blocks|key|3004844|text|如果您使用mysql二进制文件或dmg将其安装在您的系统上，而不是使用MAMP，则可以在/usr/local/mysql中找到它。|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|CODE|entityRanges|data|3004845|entityMap^0|18|G|18|G|0^^$0|@$1|2|3|4|5|6|7|I|8|@$9|J|A|K|B|C]|$9|L|A|M|B|D]]|E|@]|F|$]]|$1|G|3|-4|5|6|7|N|8|@]|E|@]|F|$]]]|H|$]]

It will be found in <code>/usr/local/mysql</code> if you use the mysql binaries or dmg to install it on your system instead of using MAMP

blocks|key|123464|text|如果您从mysql控制台运行SHOW+VARIABLES，您可以查找basedir。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|BOLD|entityRanges|data|123465|当我运行以下命令时：|123466|mysql>+SHOW+VARIABLES+WHERE+`Variable_name`+=+'basedir';|code-block|syntax|javascript|123467|在我的系统上，我得到/usr/local/mysql作为返回值。(我没有使用MAMP+-我在homebrew中安装了MySQL。|123468|我的机器上的mysqld是在/usr/local/mysql/bin中，所以basedir是安装所有东西的地方。|123469|另请参阅util：|123470|mysql>+SHOW+VARIABLES+WHERE+`Variable_name`+=+'datadir';+|123471|来找出数据库的存储位置。|123472|更多信息：http://dev.mysql.com/doc/refman/5.0/en/show-variables.html|123473|和http://dev.mysql.com/doc/refman/5.0/en/server-options.html#option_mysqld_basedir|123474|entityMap|0|LINK|mutability|MUTABLE|url|http://mxcl.github.io/homebrew/|1|http://dev.mysql.com/doc/refman/5.0/en/show-variables.html|2|http://dev.mysql.com/doc/refman/5.0/en/server-options.html#option_mysqld_basedir^0|E|E|Y|7|0|0|0|A|G|1A|8|0|0|6|6|E|K|0|0|0|0|5|1M|1|0|1|28|2|0^^$0|@$1|2|3|4|5|6|7|1D|8|@$9|1E|A|1F|B|C]|$9|1G|A|1H|B|D]]|E|@]|F|$]]|$1|G|3|H|5|6|7|1I|8|@]|E|@]|F|$]]|$1|I|3|J|5|K|7|1J|8|@]|E|@]|F|$L|M]]|$1|N|3|O|5|6|7|1K|8|@$9|1L|A|1M|B|C]]|E|@$9|1N|A|1O|1|1P]]|F|$]]|$1|P|3|Q|5|6|7|1Q|8|@$9|1R|A|1S|B|C]|$9|1T|A|1U|B|C]]|E|@]|F|$]]|$1|R|3|S|5|6|7|1V|8|@]|E|@]|F|$]]|$1|T|3|U|5|K|7|1W|8|@]|E|@]|F|$L|M]]|$1|V|3|W|5|6|7|1X|8|@]|E|@]|F|$]]|$1|X|3|Y|5|6|7|1Y|8|@]|E|@$9|1Z|A|20|1|21]]|F|$]]|$1|Z|3|10|5|6|7|22|8|@]|E|@$9|23|A|24|1|25]]|F|$]]|$1|11|3|-4|5|6|7|26|8|@]|E|@]|F|$]]]|12|$13|$5|14|15|16|F|$17|18]]|19|$5|14|15|16|F|$17|1A]]|1B|$5|14|15|16|F|$17|1C]]]]

If you run <code>SHOW VARIABLES</code> from a mysql console you can look for basedir.

When I run the following:

<pre><code>mysql&gt; SHOW VARIABLES WHERE `Variable_name` = 'basedir';
</code></pre>

on my system I get <code>/usr/local/mysql</code> as the Value returned.
(I am not using MAMP - I installed MySQL with <a href="http://mxcl.github.io/homebrew/" rel="noreferrer">homebrew</a>.

<code>mysqld</code>on my machine is in <code>/usr/local/mysql/bin</code> so the basedir is where most everything will be installed to.

Also util:

<pre><code>mysql&gt; SHOW VARIABLES WHERE `Variable_name` = 'datadir'; 
</code></pre>

To find where the DBs are stored.

For more:
<a href="http://dev.mysql.com/doc/refman/5.0/en/show-variables.html" rel="noreferrer">http://dev.mysql.com/doc/refman/5.0/en/show-variables.html</a>

and
<a href="http://dev.mysql.com/doc/refman/5.0/en/server-options.html#option_mysqld_basedir" rel="noreferrer">http://dev.mysql.com/doc/refman/5.0/en/server-options.html#option_mysqld_basedir</a>

blocks|key|123485|text|如果你使用DMG+(最简单的下载方法可以在这里找到http://dev.mysql.com/downloads/mysql/)在终端try：cd+/usr/local/中下载mySQL|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|123486|当您输入ls时，您应该会看到mysql-YOUR-VERSION。您还将看到mysql，这是安装目录。|123487|来源：http://geeksww.com/tutorials/database_management_systems/mysql/installation/how_to_download_and_install_mysql_on_mac_os_x.php|123488|entityMap|0|LINK|mutability|MUTABLE|url|http://dev.mysql.com/downloads/mysql/|1|http://geeksww.com/tutorials/database_management_systems/mysql/installation/how_to_download_and_install_mysql_on_mac_os_x.php^0|1Y|E|P|11|0|0|4|2|0|3|3H|1|0^^$0|@$1|2|3|4|5|6|7|T|8|@$9|U|A|V|B|C]]|D|@$9|W|A|X|1|Y]]|E|$]]|$1|F|3|G|5|6|7|Z|8|@$9|10|A|11|B|C]]|D|@]|E|$]]|$1|H|3|I|5|6|7|12|8|@]|D|@$9|13|A|14|1|15]]|E|$]]|$1|J|3|-4|5|6|7|16|8|@]|D|@]|E|$]]]|K|$L|$5|M|N|O|E|$P|Q]]|R|$5|M|N|O|E|$P|S]]]]

If you downloaded mySQL using a DMG (easiest way to download found here <a href="http://dev.mysql.com/downloads/mysql/" rel="noreferrer">http://dev.mysql.com/downloads/mysql/</a>) in Terminal try: <code>cd /usr/local/</code>

When you type <code>ls</code> you should see mysql-YOUR-VERSION. You will also see mysql which is the installation directory.

Source: <a href="http://geeksww.com/tutorials/database_management_systems/mysql/installation/how_to_download_and_install_mysql_on_mac_os_x.php" rel="noreferrer">http://geeksww.com/tutorials/database_management_systems/mysql/installation/how_to_download_and_install_mysql_on_mac_os_x.php</a>

blocks|key|1262550|text|如果你已经安装了MySql，你也可以进入Mac的“系统偏好设置”菜单，点击"MySql“，然后点击”配置“标签来查看所有dmg目录的位置。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1262551|参考：https://dev.mysql.com/doc/refman/8.0/en/osx-installation-prefpane.html|offset|length|1262552|entityMap|0|LINK|mutability|MUTABLE|url|https://dev.mysql.com/doc/refman/8.0/en/osx-installation-prefpane.html^0|0|3|1Y|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|O|8|@]|9|@$D|P|E|Q|1|R]]|A|$]]|$1|F|3|-4|5|6|7|S|8|@]|9|@]|A|$]]]|G|$H|$5|I|J|K|A|$L|M]]]]

If you've installed with the dmg, you can also go to the Mac "System Preferences" menu, click on "MySql" and then on the configuration tab to see the location of all MySql directories.

Reference: <a href="https://dev.mysql.com/doc/refman/8.0/en/osx-installation-prefpane.html" rel="noreferrer">https://dev.mysql.com/doc/refman/8.0/en/osx-installation-prefpane.html</a>

blocks|key|880678|text|对我来说，它是在/usr/local/opt中安装的|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|880679|我用于安装的命令是brew+install+mysql@5.6|880680|entityMap^0|8|E|0|9|M|0^^$0|@$1|2|3|4|5|6|7|J|8|@$9|K|A|L|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|M|8|@$9|N|A|O|B|C]]|D|@]|E|$]]|$1|H|3|-4|5|6|7|P|8|@]|D|@]|E|$]]]|I|$]]

for me it was installed in /usr/local/opt

The command I used for installation is brew install mysql@5.6

blocks|key|880656|text|或者使用古老的"find“。例如，为了查找旧的mysql+v5.7：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|880657|cd+/
find+.+type+-d+-name+"mysql@5.7"|code-block|syntax|javascript|880658|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Or use good old "find". For example in order to look for old mysql v5.7: 

<pre><code>cd /
find . type -d -name "mysql@5.7"
</code></pre>

blocks|key|123539|text|对我来说，我能够在路径"/opt/homebrew/etc“中获得位置。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|123540|我已经使用自制软件安装了mysql。|123541|如果您无法获得确切的路径，请启动mysql服务器->+mysql.server启动|123542|然后运行mysql+-v检查版本，它会带你进入mysql。运行SHOW+VARIABLES+WHERE+Variable_name+=+'basedir‘。导航到路径"/opt/homebrew/etc“|offset|length|style|CODE|123543|entityMap^0|0|0|0|1G|D|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|O|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|P|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|Q|8|@$H|R|I|S|J|K]]|9|@]|A|$]]|$1|L|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|M|$]]

For me I was able to get the location at the path &quot;/opt/homebrew/etc&quot;
I have installed mysql using homebrew.
If you are not able to get the exact path start the mysql server -&gt; mysql.server start
then run mysql -v to check the version, it will bring you in to the mysql.
run SHOW VARIABLES WHERE <code>Variable_name</code> = 'basedir'.
Navigate to path &quot;/opt/homebrew/etc&quot;

How do I find out where MySQL is installed on Mac OS X 10.7.9? I have MAMP installed so I presume that it is bundled with this install?

Find out where MySQL is installed on Mac OS X

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

教程

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云智能顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

EdgeOne AI 安全实战专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

聚焦“写作效率、视觉美观与运行性能”三方面进行全面升级，为您提供更高效、稳定的创作环境

社区富文本&Markdown编辑器全新改版上线，欢迎大家体验!

诚挚邀请您参与本次调研，分享您的真实使用感受与建议。您的反馈至关重要，感谢您的支持与参与！

社区新版编辑器体验调研

如何找出MySQL在MacOSX10.7.9上的安装位置？我已经安装了MAMP，所以我假设它是与此安装捆绑在一起的？

问了解MySQL在Mac上的安装位置
EN

回答 8

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问了解MySQL在Mac上的安装位置EN

回答 8

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问了解MySQL在Mac上的安装位置
EN