Re: User Issue

2008-04-28 Thread Mark-E
Hi Saravanan, Thanks, once I added this to the my.cnf in the mysqld section it worked! Regards, Mark saravanan-5 wrote: Use my.cnf to point the data directory and the user details. [mysqld] user=mysql50 datadir=/home/mysql50 Saravanan --- On Mon, 4/28/08, Mark-E

Re: Starting a 2nd MySQL instance on UNIX

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

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

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

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