Hello, I already have mysql 4 installed on datadir /var/lib/mysql and basedir /var/lib on RHEL5 running on port 3306. I want to run another instance in /home/mysql5 with datadir = /home/mysql5 and basedir=/home on port 3307. I installed as follows, but when I try to start mysql5, it fails to start or kills itself. Note I am trying to use mysql5 as user/group for mysql5 instance. Here are the details:
[root@ server ~]# groupadd mysql5 [root@ server ~]# useradd mysql5 -g mysql5 [root@ server ~]# ./configure --prefix=/home/mysql5 --with-unix-socket-path=/home/mysql5/mysql5.sock --with-tcp-port=3307 --with-pic --with-mysqld-user=mysql5 [root@ server ~]# It installed successfully. [root@ server ~]# pwd /home/mysql5 [root@ server ~]# ls bin ibdata1 ib_logfile0 ib_logfile1 include info jobs1.localhelpwanted.net.err lib libexec man mysql mysql-test share sql-bench test [root@ server ~]# ls bin/ libexec/ bin/: comp_err myisampack mysqlbug mysqld_safe mysql_fix_privilege_tables mysqlshow mysql_upgrade resolveip innochecksum my_print_defaults mysqlcheck mysqldump mysqlhotcopy mysql_tableinfo mysql_upgrade_shell resolve_stack_dump msql2mysql mysql mysql_client_test mysqldumpslow mysqlimport mysqltest mysql_waitpid myisamchk mysqlaccess mysql_config mysql_explain_log mysql_install_db mysqltestmanagerc mysql_zap myisam_ftdump mysqladmin mysql_convert_table_format mysql_find_rows mysql_secure_installation mysqltestmanager-pwgen perror myisamlog mysqlbinlog mysqld_multi mysql_fix_extensions mysql_setpermission mysql_tzinfo_to_sql replace libexec/: mysqld mysqlmanager [root@ server ~]# Next I installed database directory [root@ server ~]# /home/mysql5/bin/mysql_install_db --defaults-file=/etc/my5.cnf --user=mysql5 Whenever I try to start mysql5 on port 3307, it fails ( there is no firewall issue in this case ) : [root@ server ~]# /home/mysql5/bin/mysqld_safe --user=mysql5 --defaults-file=/etc/my5.cnf --datadir=/home/mysql5 --pid-file=/home/mysql5/mysql5.pid --port=3307 --ledir=/home/mysql5/libexec & [1] 10676 [root@ server ~]# Starting mysqld daemon with databases from /home/mysql5 STOPPING server from pid file /home/mysql5/mysql5.pid 080715 07:39:40 mysqld ended [1]+ Done /home/mysql5/bin/mysqld_safe --user=mysql5 --defaults-file=/etc/my5.cnf --datadir=/home/mysql5 --pid-file=/home/mysql5/mysql5.pid --port=3307 --ledir=/home/mysql5/libexec [root@ server ~]# /home/mysql5/bin/mysqld_safe --user=mysql5 --defaults-file=/etc/my5.cnf --datadir=/home/mysql5 --pid-file=/home/mysql5/mysql5.pid --port=3307 --ledir=/home/mysql5/libexec --skip-grant-tables & [1] 10723 [root@ server ~]# Starting mysqld daemon with databases from /home/mysql5 STOPPING server from pid file /home/mysql5/mysql5.pid 080715 07:40:03 mysqld ended [1]+ Done /home/mysql5/bin/mysqld_safe --user=mysql5 --defaults-file=/etc/my5.cnf --datadir=/home/mysql5 --pid-file=/home/mysql5/mysql5.pid --port=3307 --ledir=/home/mysql5/libexec --skip-grant-tables [root@ server ~]# Please advise. Thanks
