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 <[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 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/[EMAIL PROTECTED] ____________________________________________________________________________________ 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/[EMAIL PROTECTED]