mysql安装时碰到的问题

mukey

$MYSQL_ROOT/share/mysql/mysql.server脚本的问题
如果/etc/my.cnf文件不存在, mysql.server可以正常启动
当把同目录下的my-medium.cnf拷为/etc/my.cnf时, mysql.server无法启动

包为从CU上下的:mysql-5.0.56.tar.gz, 以前系统安装过mysql, 现在重装
大家有没有碰到这个问题. 大家帮我研究一下.

/usr/local/mysql/share/mysql$ ./mysql.server stop
Shutting down MySQL                                        [  ç¡®å®š  ]
/usr/local/mysql/share/mysql$ cd ../../
bin/        info/       libexec/    mysql-test/ sql-bench/  
include/    lib/        man/        share/      var/        
/usr/local/mysql/share/mysql$ cp ../../share/mysql/my-medium.cnf /etc/my.cnf  
/usr/local/mysql/share/mysql$ ./mysql.server start
Starting MySQL../mysql.server: line 159: kill: (8965) - ûÓÐÄǸö½ø³Ì
                                                           [失败]
/usr/local/mysql/share/mysql$ rm /etc/my.cnf
rm£ºÊÇ·ñɾ³ýÒ»°ãÎļþ¡®/etc/my.cnf¡¯? y
/usr/local/mysql/share/mysql$ ./mysql.server start
Starting MySQL                                             [  ç¡®å®š  ]
/usr/local/mysql/share/mysql$ ps -ef|grep mysql
root      9029     1  0 23:56 pts/3    00:00:00 /bin/sh /usr/local/mysql/bin/mysqld_safe --datadir=/usr/local/mysql/var --pid-file=/usr/local/mysql/var/localhost.localdomain.pid
mysql     9052  9029  0 23:56 pts/3    00:00:00 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/var --user=mysql --pid-file=/usr/local/mysql/var/localhost.localdomain.pid --skip-external-locking
root      9070  3954  0 23:56 pts/3    00:00:00 grep mysql


从$MYSQL_ROOT/var/localhost.localdomain.err文件中看到:
090316 00:06:03  mysqld started
090316  0:06:03 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 42
94967295
090316  0:06:03 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 42
94967295
090316  0:06:03  InnoDB: Started; log sequence number 0 43655
^G/usr/local/mysql/libexec/mysqld: File './mysql-bin.000002' not found (Errcode: 13)
090316  0:06:03 [ERROR] Failed to open log (file './mysql-bin.000002', errno 13)
090316  0:06:03 [ERROR] Could not open log file
090316  0:06:03 [ERROR] Can't init tc log
090316  0:06:03 [ERROR] Aborting

090316  0:06:03  InnoDB: Starting shutdown...
090316  0:06:04  InnoDB: Shutdown completed; log sequence number 0 43655
090316  0:06:04 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete

090316 00:06:04  mysqld ended

shmiya

检查一下配置文件，找到原先的binlog写在哪里的

你再看一下新的my.cnf的binlog写在哪里。。。复制一份回来

确认mysql有权限去写binlog,如果不需要，可以关掉binlog