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 <[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] > > > -- View this message in context: http://www.nabble.com/User-Issue-tp16926263p16941891.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]
