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.
Ian Simpson wrote:
> 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
>> and created a new mysql50 user that I want to use to run this instance
>> I tried to start the instance on another port by running the following
>> ./bin/mysqld_safe --defaults-file=/usr/local/mysql-5.0/my.cnf
>> --socket=/tmp/mysql50/mysql.sock --port=3307
>> --pid-file=/usr/local/mysql-5.0/mysql50.pid --user=mysql50
>> The instance appears to start but the message "Starting the instance"
>> up and I never get back to the system prompt. it just sits there. If I
>> 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
>> to do to ge tthe instance up and running properly, I would appreciate it.
>> am rather new to MySQL and I have read through the docs but things are
>> not very clear.
> 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:
Sent from the MySQL - General mailing list archive at Nabble.com.