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 [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]
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-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]
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 [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]
Re: CentOS 4.3 - MySQL - NIS user issue
On 8/31/06, Tom Brown [EMAIL PROTECTED] wrote: Hi I have what i think is a strange issue - snip now when a NIS user tries to use the db [EMAIL PROTECTED] su - bugzilla [EMAIL PROTECTED] mysql -u bugs -p bugs ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13) any ideas why this is or what i can do to make it work? Do your NIS users mount only their HOME directories from the NIS/MySQL server? If so, obviously the /var partition on the MySQL server wouldn't be available to them, right? To confirm: 1. Log in as a NIS user 2. su to root 3. Check out ls -l /var/lib/mysql/ snip -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
CentOS 4.3 - MySQL - NIS user issue
Hi I have what i think is a strange issue - All my users are NIS users and they can access this box fine. I have a MySQL server running on this box that is running fine. The OS 'root' user can authenticate and use MySQL fine as this is not a NIS user e.g. [EMAIL PROTECTED] mysql -u bugs -p bugs Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 5 to server version: 3.23.58 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql Yes i know thats an ancient MySQL version but this is an app requirement, dont get me started! now when a NIS user tries to use the db [EMAIL PROTECTED] su - bugzilla [EMAIL PROTECTED] mysql -u bugs -p bugs ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13) any ideas why this is or what i can do to make it work? thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: CentOS 4.3 - MySQL - NIS user issue
In the last episode (Aug 31), Tom Brown said: All my users are NIS users and they can access this box fine. I have a MySQL server running on this box that is running fine. The OS 'root' user can authenticate and use MySQL fine as this is not a NIS user e.g. [EMAIL PROTECTED] mysql -u bugs -p bugs Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A [...] now when a NIS user tries to use the db [EMAIL PROTECTED] su - bugzilla [EMAIL PROTECTED] mysql -u bugs -p bugs ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13) any ideas why this is or what i can do to make it work? $ perror 13 OS error code 13: Permission denied Make sure that /var/lib/mysql/mysql.sock is world-readable. I doubt this has anything to do with NIS. -- Dan Nelson [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]