blocks|key|778942|text|按照建议，我编辑了这条消息以放置正确的答案。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|778943|mysql数据库的‘物理’位置在/usr/local/mysql下|778944|mysql是指向当前活动mysql安装的符号链接，在我的示例中，确切的文件夹是mysql-5.6.10-osx10.7-x86_64。|778945|在该文件夹中，您将看到另一个数据文件夹，其中包含您的数据库的受限文件夹。|778946|你不能从查找器中实际看到数据库的大小(这是我的问题)，因为文件夹是受保护的，但你可以使用sudo+du+-sh+/usr/local/mysql/data/{your-database-name}从终端看到，这样你就会得到一个很好的格式化的大小输出。|offset|length|style|CODE|778947|在这些文件夹中，你有不同的文件，所有的文件夹都在你的数据库中，所以更安全的做法是检查数据库的文件夹以获得一个大小。|778948|就这样。享受吧！|778949|entityMap^0|0|0|0|0|18|1I|0|0|0^^$0|@$1|2|3|4|5|6|7|T|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|U|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|V|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|W|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|X|8|@$J|Y|K|Z|L|M]]|9|@]|A|$]]|$1|N|3|O|5|6|7|10|8|@]|9|@]|A|$]]|$1|P|3|Q|5|6|7|11|8|@]|9|@]|A|$]]|$1|R|3|-4|5|6|7|12|8|@]|9|@]|A|$]]]|S|$]]

As suggested, I edited this message to place a proper answer.

The 'physical' location of the mysql databases are under /usr/local/mysql

the mysql is a symlink to the current active mysql installation, in my case the exact folder is mysql-5.6.10-osx10.7-x86_64.

Inside that folder you'll see another data folder, inside it are RESTRICTED folders with your databases.

You can't actually see the size of your databases (that was my issue) from the Finder because the folder are protected, you can though see from the terminal with <code>sudo du -sh /usr/local/mysql/data/{your-database-name}</code> and like this you'll get a nice formatted output with the size.

In those folder you have different files with all the folders present in your database, so it's safer to check the db's folder to get a size.

That's it. Enjoy!

blocks|key|779034|text|如果软件是Sequel+pro，则在Mac+OSX上默认安装mysql的数据位于以下位置：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|779035|/usr/local/var/mysql|code-block|syntax|javascript|779036|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|$]]

If the software is Sequel pro the default install mysql on Mac OSX has data located here:

<pre><code>/usr/local/var/mysql
</code></pre>

blocks|key|562601|text|使用以下命令检查mysql的根文件夹：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|562602|mysql_config|code-block|syntax|javascript|562603|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|$]]

Check where is the root folder of mysql with:

<pre><code>mysql_config
</code></pre>

blocks|key|562648|text|好吧，如果你不知道my.cnf在哪里(比如安装了自制软件的Mac+)，或者你正在寻找其他选择：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|562649|ps+aux%7Cgrep+mysql
abkrim++++++++++++1160+++0.0++0.2++2913068++26224+++??++R++++Tue04PM+++0:14.63+/usr/local/opt/mariadb/bin/mysqld+--basedir=/usr/local/opt/mariadb+--datadir=/usr/local/var/mysql+--plugin-dir=/usr/local/opt/mariadb/lib/plugin+--bind-address=127.0.0.1+--log-error=/usr/local/var/mysql/iMac-2.local.err+--pid-file=iMac-2.local.pid|code-block|syntax|javascript|562650|你得到了datadir=/usr/local/var/mysql|offset|length|style|CODE|562651|entityMap^0|0|0|4|S|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Q|8|@$I|R|J|S|K|L]]|9|@]|A|$]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

Well, if yo don't know where is my.cnf (such Mac OS X installed with homebrew), or You are looking found others choices:

<pre><code>ps aux|grep mysql
abkrim 1160 0.0 0.2 2913068 26224 ?? R Tue04PM 0:14.63 /usr/local/opt/mariadb/bin/mysqld --basedir=/usr/local/opt/mariadb --datadir=/usr/local/var/mysql --plugin-dir=/usr/local/opt/mariadb/lib/plugin --bind-address=127.0.0.1 --log-error=/usr/local/var/mysql/iMac-2.local.err --pid-file=iMac-2.local.pid
</code></pre>

You get <code>datadir=/usr/local/var/mysql</code>

blocks|key|779172|text|如果您使用Homebrew安装MySQL@5.7，则位置为|type|unstyled|depth|inlineStyleRanges|entityRanges|data|779173|/usr/local/Homebrew/var/mysql|code-block|syntax|javascript|779174|我不知道其他版本的位置是否相同。|779175|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

If you are using Homebrew to install MySQL@5.7, the location is

<pre><code>/usr/local/Homebrew/var/mysql
</code></pre>

I don't know if the location is the same for other versions.

blocks|key|562701|text|如果你在MacOS上通过自制软件安装MySQL，你可能需要删除旧的数据目录/usr/local/var/mysql。否则，它将在初始化过程中失败，并显示以下错误：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|562702|==>+/usr/local/Cellar/mysql/8.0.16/bin/mysqld+--initialize-insecure+--user=hohoho+--basedir=/usr/local/Cellar/mysql/8.0.16+--datadir=/usr/local/var/mysql+--tmpdir=/tmp
2019-07-17T16:30:51.828887Z+0+[System]+[MY-013169]+[Server]+/usr/local/Cellar/mysql/8.0.16/bin/mysqld+(mysqld+8.0.16)+initializing+of+server+in+progress+as+process+93487
2019-07-17T16:30:51.830375Z+0+[ERROR]+[MY-010457]+[Server]+--initialize+specified+but+the+data+directory+has+files+in+it.+Aborting.
2019-07-17T16:30:51.830381Z+0+[ERROR]+[MY-013236]+[Server]+Newly+created+data+directory+/usr/local/var/mysql/+is+unusable.+You+can+safely+remove+it.
2019-07-17T16:30:51.830410Z+0+[ERROR]+[MY-010119]+[Server]+Aborting
2019-07-17T16:30:51.830540Z+0+[System]+[MY-010910]+[Server]+/usr/local/Cellar/mysql/8.0.16/bin/mysqld:+Shutdown+complete+(mysqld+8.0.16)++Homebrew.|code-block|syntax|javascript|562703|entityMap^0|11|K|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@$9|N|A|O|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|P|8|@]|D|@]|E|$I|J]]|$1|K|3|-4|5|6|7|Q|8|@]|D|@]|E|$]]]|L|$]]

If you install MySQL via homebrew on MacOS, you might need to delete your old data directory <code>/usr/local/var/mysql</code>. Otherwise, it will fail during the initialization process with the following error:

<pre><code>==&gt; /usr/local/Cellar/mysql/8.0.16/bin/mysqld --initialize-insecure --user=hohoho --basedir=/usr/local/Cellar/mysql/8.0.16 --datadir=/usr/local/var/mysql --tmpdir=/tmp
2019-07-17T16:30:51.828887Z 0 [System] [MY-013169] [Server] /usr/local/Cellar/mysql/8.0.16/bin/mysqld (mysqld 8.0.16) initializing of server in progress as process 93487
2019-07-17T16:30:51.830375Z 0 [ERROR] [MY-010457] [Server] --initialize specified but the data directory has files in it. Aborting.
2019-07-17T16:30:51.830381Z 0 [ERROR] [MY-013236] [Server] Newly created data directory /usr/local/var/mysql/ is unusable. You can safely remove it.
2019-07-17T16:30:51.830410Z 0 [ERROR] [MY-010119] [Server] Aborting
2019-07-17T16:30:51.830540Z 0 [System] [MY-010910] [Server] /usr/local/Cellar/mysql/8.0.16/bin/mysqld: Shutdown complete (mysqld 8.0.16) Homebrew.
</code></pre>

blocks|key|562741|text|在M1和homebrew上，“数据目录”是：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|562742|/opt/homebrew/var/mysql|code-block|syntax|javascript|562743|主要路径是：|562744|/opt/homebrew/Cellar/mysql|562745|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

On M1 and homebrew the &quot;data directory&quot; is:
<pre><code>/opt/homebrew/var/mysql
</code></pre>
And the main path is:
<pre><code>/opt/homebrew/Cellar/mysql
</code></pre>

I installed mysql in Mac after downloding its dmg file version 64 bit.
While trying to create a database it gave me error 1006 -- can't create database. After browsing a number of website, it seems due to user ownership setting of mysql "data directory" location that needs to be changed.

Where is mysql default "data directory"? I could not find /var/lib/mysql in localhost.

THANKS.

mysql data directory location

数据库

MySQL

MacOS

我在下载了64位的dmg文件后，在Mac上安装了mysql。在尝试创建数据库时，出现错误1006 -- can't create database。在浏览了多个网站后，似乎由于用户对mysql“数据目录”位置的所有权设置需要更改。mysql默认的“数据目录”在哪里？我在localhost中找不到/var/lib/mys...

问mysql数据目录位置
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问mysql数据目录位置EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问mysql数据目录位置
EN