如何在Debian中更改挂载的virtualbox共享文件夹的所有权/权限?

我试图挂载一个共享文件夹,并将其用作mysql数据目录。

成功安装和设置我的datadirconfiguration后,mysqld失败,因为它缺乏适当的权限

我已经把它挂载到/ var / lib / mysql,以前用/ srv / sql的尝试遇到了同样的问题:

drwxr-xr-x 1 root root 272 Feb 27 12:22 mysql 

试图运行chown -R mysql:mysql /var/lib/mysql没有什么区别,创build一个子文件夹并尝试使用它。

这是syslog中的mysql条目:

 Feb 27 12:22:23 tomjn-debian-dev-vm mysqld_safe: Starting mysqld daemon with databases from /var/lib/mysql Feb 27 12:22:23 tomjn-debian-dev-vm mysqld: 130227 12:22:23 [Warning] Setting lower_case_table_names=2 because file system for /var/lib/mysql/ is case insensitive Feb 27 12:22:23 tomjn-debian-dev-vm mysqld: 130227 12:22:23 [Note] Plugin 'FEDERATED' is disabled. Feb 27 12:22:23 tomjn-debian-dev-vm mysqld: #007/usr/sbin/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13) Feb 27 12:22:23 tomjn-debian-dev-vm mysqld: 130227 12:22:23 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. Feb 27 12:22:24 tomjn-debian-dev-vm mysqld: 130227 12:22:24 InnoDB: Initializing buffer pool, size = 8.0M Feb 27 12:22:24 tomjn-debian-dev-vm mysqld: 130227 12:22:24 InnoDB: Completed initialization of buffer pool Feb 27 12:22:24 tomjn-debian-dev-vm mysqld: 130227 12:22:24 InnoDB: Operating system error number 13 in a file operation. Feb 27 12:22:24 tomjn-debian-dev-vm mysqld: InnoDB: The error means mysqld does not have the access rights to Feb 27 12:22:24 tomjn-debian-dev-vm mysqld: InnoDB: the directory. Feb 27 12:22:24 tomjn-debian-dev-vm mysqld: InnoDB: File name ./ibdata1 Feb 27 12:22:24 tomjn-debian-dev-vm mysqld: InnoDB: File operation call: 'open'. Feb 27 12:22:24 tomjn-debian-dev-vm mysqld: InnoDB: Cannot continue operation. Feb 27 12:22:24 tomjn-debian-dev-vm mysqld_safe: mysqld from pid file /var/run/mysqld/mysqld.pid ended Feb 27 12:22:39 tomjn-debian-dev-vm /etc/init.d/mysql[5085]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in Feb 27 12:22:39 tomjn-debian-dev-vm /etc/init.d/mysql[5085]: #007/usr/bin/mysqladmin: connect to server at 'localhost' failed Feb 27 12:22:39 tomjn-debian-dev-vm /etc/init.d/mysql[5085]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' Feb 27 12:22:39 tomjn-debian-dev-vm /etc/init.d/mysql[5085]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists! Feb 27 12:22:39 tomjn-debian-dev-vm /etc/init.d/mysql[5085]: 

虚拟机本身有debian 6,安装了apache / php / mysql,只做了很less的修改(我改变了my.cnf来使用不同的datadir,然后把它改回来)。 主机是OS X Mountain Lion和Virtualbox 4.2.6,安装了附件/扩展程序和USB插件

请尝试使用mysql用户标识手动安装共享文件夹:

这里是一个例子:

 $ id mysql uid=105(mysql) gid=112(mysql) groups=112(mysql) 

那么你会做:

 $ sudo mount -t vboxsf share_name -o rw,dmode=777,gid=112,uid=105 /var/lib/mysql