User Issue

[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 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
 

[saravanan-5]

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@...> wrote:

> From: Mark-E <meramo@...>
> Subject: User Issue
> To: mysql@...
> 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-tp16926263p16926263.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=suzuki_babu@...

      ____________________________________________________________________________________
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile.  Try it now.  http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=lists@...

[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 <[e-mail]> wrote:

> From: Mark-E <[e-mail]>
> Subject: User Issue
> To: [e-mail]
> 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-tp16926263p16926263.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=[e-mail]


      ____________________________________________________________________________________
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile.  Try it now.  http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=[e-mail]