List:General Discussion« Previous MessageNext Message »
From:Mark-E Date:April 28 2008 3:54pm
Subject:Re: Starting a 2nd MySQL instance on UNIX
View as plain text  
Hi Ian,
   Thanks for the reply. I was specifying the new port of 3307. I actually
got it working over the weekend. Turns out I had to add a few entries in the
mysqld section of the my.cnf file and I was able to connect. 

Regards,
  Mark



Ian Simpson wrote:
> 
> Mark,
> 
> When you try to log-in to the new instance, are you specifying the new 
> port number to the client? If you don't give it the new port number, 
> then it will connect to the default port, which is presumably your 
> 4.0.20 instance.
> 
> Mark-E wrote:
>> I have a Solaris box where MySQL 4.0.20 instance is running (to support
>> Bugzilla 2.22). I have loaded mysql5.0 on the same box (for Bugzilla
>> 3.0.3)
>> and created a new mysql50 user that I want to use to run this instance
>> with.
>> I tried to start the instance on another port by running the following
>> command...
>>
>> ./bin/mysqld_safe --defaults-file=/usr/local/mysql-5.0/my.cnf
>> --socket=/tmp/mysql50/mysql.sock --port=3307
>> --basedir=/usr/local/mysql-5.0
>> --datadir=/usr/local/mysql-5.0/data
>> --pid-file=/usr/local/mysql-5.0/mysql50.pid --user=mysql50
>>
>> The instance appears to start but the message "Starting the instance"
>> comes
>> up and I never get back to the system prompt. it just sits there. If I
>> open
>> another terminal window and do a ps -ef | grep mysql, I can see the new
>> processes running. There is nothing in the error log. 
>>
>> I ran the mysql_install_db.sh script to create the mysql database
>> however, I
>> cannot log in. I thought that it creates a root user with no password. I
>> tired logging in as root with no password bu no luck. If i use the mysql
>> 4.0.20 root user password, I get into the 4.0.20 instance even though the
>> mysql50 user does not have mysql 4.0.20 in it's path. when I run mysql at
>> the prompt, how would I differentiate between the 2 instances?
>>
>> So at this point I am stuck. If anyone out can help guide me on what I
>> need
>> to do to ge tthe instance up and running properly, I would appreciate it.
>> I
>> am rather new to MySQL and I have read through the docs but things are
>> still
>> not very clear.
>>
>>
>> Thanks! 
>>
>> Mark
>>   
> 
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
> 
> 
> 

-- 
View this message in context:
http://www.nabble.com/Starting-a-2nd-MySQL-instance-on-UNIX-tp16834758p16941984.html
Sent from the MySQL - General mailing list archive at Nabble.com.

Thread
Starting a 2nd MySQL instance on UNIXMark-E23 Apr
  • Re: Starting a 2nd MySQL instance on UNIXIan Simpson24 Apr
    • Re: Starting a 2nd MySQL instance on UNIXMark-E28 Apr
      • Re: Starting a 2nd MySQL instance on UNIXArthur Fuller29 Apr
        • RE: Starting a 2nd MySQL instance on UNIXMark Eramo29 Apr
          • R: Starting a 2nd MySQL instance on UNIXNanni Claudio29 Apr