开发者

How do I change the permissions that MySQL uses to create database directories and files?

开发者 https://www.devze.com 2022-12-11 01:05 出处:网络
I have a self-installed MySQL service running on my OS X Snow Leopard machine, compiled using the automated installer from mysql.com.

I have a self-installed MySQL service running on my OS X Snow Leopard machine, compiled using the automated installer from mysql.com.

The problem I'm having is that I want to sync my database files, from the "data" directory, using Dropbox. All directories and files created within that folder are being assigned to the user "_mysql" and group "wheel", with the permission of 700. This permission is leaving the files effectively locked, with a red "no entry" icon overlay, and not allowing Dropbox, or me, access to them.

As a temporary measure I can manually change the file permissions to 755 to give me the required access. However, any new database files created by MySQL will still be given the default permission value of 700. Not ideal.

What I need to do is either change the 开发者_运维知识库user/group that MySQL uses to creates these files or change the default permissions value to something that will allow other users/groups to at least read the database files.


After some research I found that you can change the user MySQL runs as with a simple, yet relatively unknown, option in the configuration file.

http://dev.mysql.com/doc/refman/5.0/en/changing-mysql-user.html

0

精彩评论

暂无评论...
验证码 换一张
取 消