Starting a 2nd MySQL instance on UNIX

2008-04-23 Thread Mark-E
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 co

User Issue

2008-04-27 Thread Mark-E
I have setup a mysql50 instance on a system where mysql4.0.20 already exists. So that I can run both instances together, I setup a new user called mysql50. The mysql50 files are owned by this mysql50 user and mysql50 is in the path. I setup a link, /usr/local/mysql-5.0 which points to the mysql50

Re: User Issue

2008-04-28 Thread Mark-E
> > > --- On Mon, 4/28/08, Mark-E <[EMAIL PROTECTED]> wrote: > >> From: Mark-E <[EMAIL PROTECTED]> >> Subject: User Issue >> To: mysql@lists.mysql.com >> Date: Monday, April 28, 2008, 12:05 AM >> I have setup a mysql50 instance on a system whe

Re: Starting a 2nd MySQL instance on UNIX

2008-04-28 Thread Mark-E
u 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 wher

mysql_install_db

2008-04-28 Thread Mark-E
I have a question on this script. When you run this, does this create the mysql and information_schema databases? I ran this in MySQL 5.0 on a Solaris box and it only created the information_schema database. I see a data/mysql folder and it put files under that but somehow it must not have creat