昨天布置一台mysql服务器,需要用到几个实例测试,原来布置的时候一直比较顺利,这次却碰到了几个问题,贴出了共享呢一下!
1. 111019 15:04:28 mysqld_safe The file /usr/local/mysql/bin/mysqld
does not exist or is not executable. Please cd to the mysql installation
directory and restart this script from there as follows:
./bin/mysqld_safe&
See http://dev.mysql.com/doc/mysql/en/mysqld-safe.html for more information
错误码如上,之前没有出现过,现在出现的是mysqld_safe在调用/usr/local/mysql/bin/mysqld的时候 这个文件不存在或者是不能够执行。这个是因为我在/etc/my.cnf这个地方没有指定在每个实例节点的basedir,添加上去basedir=/opt/mysql/即可
2. WARNING: Log file disabled. Maybe directory or file isn't writable?
mysqld_multi log file version 2.16; run: Wed Oct 19 15:07:28 2011 Starting MySQL servers
111019 15:07:29 mysqld_safe Logging to '/data/mysql_data/error.err'.
111019 15:07:29 mysqld_safe Logging to '/data/mysql_data3307/error.err