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 <meramo@hbs.edu> wrote:
>
>> From: Mark-E <meramo@hbs.edu>
>> 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 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
>> directory. I modifed the mysql.server and I put it in the
>> mysql-5.0
>> directory. Inside the file is a user parameter called user.
>> I set the user
>> to mysql50.
>>
>> When I run mysql.server -start, It exists with an error.
>> The error log sayd
>> that I do not have permissions to the ibdata files.
>> However, the error.log
>> gets created by the mysql user and NOT the mysql50 user.
>>
>> So I think this script is trying to access the ibdata files
>> in the
>> mysql-4.0.20 folders and it cannot get to them since they
>> are owned by mysql
>> and not mysql-5.0.
>>
>> So I am kind of stuck at this point. My guess is somehwere
>> else, both the
>> user of mysql and the directory of mysql is set and since I
>> am using
>> different variables, it is not working.
>>
>> Anyway, if anyone has any suggestions, it would be
>> appreciated.
>>
>> Thanks,
>> Mark
>>
>> --
>> View this message in context:
>> http://www.nabble.com/User-Issue-tp1...p16926263.html
>> Sent from the MySQL - General mailing list archive at
>> Nabble.com.
>>
>>
>> --
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe:
>> http://lists.mysql.com/mysql?unsub=s...babu@yahoo.com
>
>
>
> __________________________________________________ __________________________________
> Be a better friend, newshound, and
> know-it-all with Yahoo! Mobile. Try it now.
> http://mobile.yahoo.com/;_ylt=Ahu06i...Dypao8Wcj9tAcJ
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=lists@nabble.com
>
>
>

--
View this message in context: http://www.nabble.com/User-Issue-tp1...p16941891.html
Sent from the MySQL - General mailing list archive at Nabble.com.