MySQL配置文件放置路径问题

luwenju

我的MySQL安装路径是   /usr/local/mysql       安装时只用了./configure --prefix=/usr/local/mysql这一个选项

那么配置文件my.cnf应该放到哪呢？  除了放置到/etc/my.cnf   还可以放置到MySQL安装路径/usr/local/mysql下的那个目录啊？   麻烦各位指点一下  谢谢了

[ 本帖最后由 luwenju 于 2010-1-6 10:44 编辑 ]

mysqlkiki

MYSQL_HOME is an environment variable containing the path to the directory in which the
server-specific my.cnf file resides. (This was DATADIR prior to MySQL version 5.0.3.)
If MYSQL_HOME is not set and you start the server using the mysqld_safe program, mysqld_safe
attempts to set MYSQL_HOME as follows:
   *  Let BASEDIR and DATADIR represent the pathnames of the MySQL base directory and
      data directory, respectively.
   *  If there is a my.cnf file in DATADIR but not in BASEDIR, mysqld_safe sets MYSQL_HOME to
     DATADIR.
   *  Otherwise, if MYSQL_HOME is not set and there is no my.cnf file in DATADIR, mysqld_safe
     sets MYSQL_HOME to BASEDIR.

luwenju

呜呜   我英语看不懂

mysqlkiki

原帖由 luwenju 于 2010-1-6 10:39 发表
呜呜   我英语看不懂

就是说my.cnf放在/usr/local/mysql下面或者/usr/local/mysql/var下面，都可以！

luwenju

o  谢谢

chenyx

放到/usr/local/mysql下吧

luwenju

放到usr/local/mysql/etc下面可以吗？

cenalulu

原帖由 luwenju 于 2010-1-6 16:27 发表
放到usr/local/mysql/etc下面可以吗？

不行吧
basedir
datadir
etc
$HOME
这四个目录下都ok

dunk007

优先级从低到高依次为：
1. /etc
2. /etc/mysql
3. $BASEDIR/mysql
4. cur_dir
5. ~/