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]
Re: Starting a 2nd MySQL instance on UNIX
Hi Ian, Thanks for the reply. I was specifying the new port of 3307. I actually got it working over the weekend. Turns out I had to add a few entries in the mysqld section of the my.cnf file and I was able to connect. Regards, Mark Ian Simpson wrote: Mark, When you try to log-in to the new instance, are you specifying the new port number to the client? If you don't give it the new port number, then it will connect to the default port, which is presumably your 4.0.20 instance. Mark-E wrote: I have a Solaris box where MySQL 4.0.20 instance is running (to support Bugzilla 2.22). I have loaded mysql5.0 on the same box (for Bugzilla 3.0.3) and created a new mysql50 user that I want to use to run this instance with. I tried to start the instance on another port by running the following command... ./bin/mysqld_safe --defaults-file=/usr/local/mysql-5.0/my.cnf --socket=/tmp/mysql50/mysql.sock --port=3307 --basedir=/usr/local/mysql-5.0 --datadir=/usr/local/mysql-5.0/data --pid-file=/usr/local/mysql-5.0/mysql50.pid --user=mysql50 The instance appears to start but the message Starting the instance comes up and I never get back to the system prompt. it just sits there. If I open another terminal window and do a ps -ef | grep mysql, I can see the new processes running. There is nothing in the error log. I ran the mysql_install_db.sh script to create the mysql database however, I cannot log in. I thought that it creates a root user with no password. I tired logging in as root with no password bu no luck. If i use the mysql 4.0.20 root user password, I get into the 4.0.20 instance even though the mysql50 user does not have mysql 4.0.20 in it's path. when I run mysql at the prompt, how would I differentiate between the 2 instances? So at this point I am stuck. If anyone out can help guide me on what I need to do to ge tthe instance up and running properly, I would appreciate it. I am rather new to MySQL and I have read through the docs but things are still not very clear. Thanks! Mark -- 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/Starting-a-2nd-MySQL-instance-on-UNIX-tp16834758p16941984.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]
mysql_install_db
I have a question on this script. When you run this, does this create the mysql and information_schema databases? I ran this in MySQL 5.0 on a Solaris box and it only created the information_schema database. I see a data/mysql folder and it put files under that but somehow it must not have created the mysql database properly. I set the basedir and datadir in the script however when I ran it I had some issues with the my.cnf at that time so maybe it did not work properly becasue of that. I see it on my windows installation but that was after I imported my dump from Bugzilla so not sure if that created the mysql database or not (don't think so). Anyway if someone could let me know what this script creates, that would help me a lot. Thanks!! Mark -- View this message in context: http://www.nabble.com/mysql_install_db-tp16945907p16945907.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]
Starting a 2nd MySQL instance on UNIX
I have a Solaris box where MySQL 4.0.20 instance is running (to support Bugzilla 2.22). I have loaded mysql5.0 on the same box (for Bugzilla 3.0.3) and created a new mysql50 user that I want to use to run this instance with. I tried to start the instance on another port by running the following command... ./bin/mysqld_safe --defaults-file=/usr/local/mysql-5.0/my.cnf --socket=/tmp/mysql50/mysql.sock --port=3307 --basedir=/usr/local/mysql-5.0 --datadir=/usr/local/mysql-5.0/data --pid-file=/usr/local/mysql-5.0/mysql50.pid --user=mysql50 The instance appears to start but the message Starting the instance comes up and I never get back to the system prompt. it just sits there. If I open another terminal window and do a ps -ef | grep mysql, I can see the new processes running. There is nothing in the error log. I ran the mysql_install_db.sh script to create the mysql database however, I cannot log in. I thought that it creates a root user with no password. I tired logging in as root with no password bu no luck. If i use the mysql 4.0.20 root user password, I get into the 4.0.20 instance even though the mysql50 user does not have mysql 4.0.20 in it's path. when I run mysql at the prompt, how would I differentiate between the 2 instances? So at this point I am stuck. If anyone out can help guide me on what I need to do to ge tthe instance up and running properly, I would appreciate it. I am rather new to MySQL and I have read through the docs but things are still not very clear. Thanks! Mark -- View this message in context: http://www.nabble.com/Starting-a-2nd-MySQL-instance-on-UNIX-tp16834758p16834758.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]