SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-29-2008, 08:27 PM
| ||||
| ||||
 User Issue 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.      |
|
04-29-2008, 08:27 PM
| |||
| |||
| Re: User Issue 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 |
|
04-29-2008, 08:27 PM
| ||||
| ||||
| Re: User Issue 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. |
Linear Mode
