On Tue, Jul 15, 2008 at 7:05 PM, Madan Thapa <[EMAIL PROTECTED]> wrote:
> 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 > It seems to me though, using mysql as the user instead of mysql5 would get it working. However any advise is appreciated. Thanks
