mysql数据目录位置 [英] mysql data directory location
问题描述
我将Mac的dmg文件版本下移64位后，在Mac中安装了mysql. 尝试创建数据库时，出现错误1006-无法创建数据库.浏览了许多网站后，似乎由于需要更改mysql数据目录"位置的用户所有权设置.
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.
mysql默认的数据目录"在哪里?我在本地主机中找不到/var/lib/mysql.
Where is mysql default "data directory"? I could not find /var/lib/mysql in localhost.
谢谢.
推荐答案
查看是否在/etc/my.cnf下有一个文件.如果是这样，它应该告诉您数据目录在哪里.
See if you have a file located under /etc/my.cnf. If so, it should tell you where the data directory is.
例如:
[mysqld]
set-variable=local-infile=0
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
...
我的猜测是您的mysql可能已安装到/usr/local/mysql-XXX.
My guess is that your mysql might be installed to /usr/local/mysql-XXX.
您可能会发现这些MySQL参考手册链接很有用:
- Installing MySQL 8.0 on MacOS
- Installing MySQL 5.7 on MacOS
- Installing MySQL 5.6 on MacOS
- Installing MySQL 5.5 on MacOS
这篇关于mysql数据目录位置的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
