macOS 上 my.cnf 文件的位置 [英] Location of my.cnf file on macOS

问题描述

I'm trying to follow along this tutorial to enable remote access to MySQL. The problem is, where should my.cnf file be located? I'm using Mac OS X Lion.

解决方案

This thread on the MySQL forum says:

By default, the OS X installation does not use a my.cnf, and MySQL just uses the default values. To set up your own my.cnf, you could just create a file straight in /etc.

OS X provides example configuration files at /usr/local/mysql/support-files/.

And if you can't find them there, MySQLWorkbench can create them for you by:

1. Opening a connection
2. Selecting the 'Options File' under 'INSTANCE' in the menu.
3. MySQLWorkbench will search for my.cnf and if it can't find it, it'll create it for you

这篇关于macOS 上 my.cnf 文件的位置的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！