Re: Mysqld running as root.
Thankx, That did the trick! So simple yet so. well... simple! - Original Message - From: Gerald Clark [EMAIL PROTECTED] To: Sean Strycker [EMAIL PROTECTED] Cc: MySQL [EMAIL PROTECTED] Sent: Friday, April 20, 2001 6:27 AM Subject: Re: Mysqld running as root. add user=mysql to the [mysqld] section of /etc/my.cnf EX: [mysqld] user=mysql Sean Strycker wrote: Hello, I'm a newbe to Linux and MySQL, but I'm finding it very interesting. I'll cut right to the chase - I've followed the directions in the manual for the binary install on Linux. but every time I start up the mysql daemon and do a pstree -laup, it's running as root. This is on a development / play machine so it's not that big a deal, but my system admin says that I have to run it as user=mysql. I've tried changing the mysql.server script, the my.cnf file, etc. I cant figure it out - how to make it start up and run as user=mysql!?! Anywho - any help would be appreciated. Thanks, Sean. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Is any limit on how many tables one database can have?
Hello, I would recomend getting a good book that covers "Database Normalization," this has to do with database design theories, etc. Or just look for a good book on "Database Design". - Original Message - From: SED [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, April 20, 2001 10:56 AM Subject: Is any limit on how many tables one database can have? Hi, I'm designing a database and I was wandering which one is better: A) 1000 tables (e.g. 10,000 rows each) in one database or B) One table with (e.g. 10,000,000 rows) and each group with special ID (in one extra column) And if I need to have many tables in one database, is any limit on how many tables one database can have? Regards, Sumarlidi Einar Dadason SED - Graphic Design -- Phone: (+354) 4615501 Mobile: (+354) 8960376 Fax: (+354) 4615503 E-mail: [EMAIL PROTECTED] Homepage:www.sed.is - New Homepage! -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL newbie questions.
Does anyone know exactly where to put the mysql.server file? is it in /etc? When I run it I get these ./mysql.server: @HOSTNAME@: command not found ./mysql.server: my_print_defaults: command not found Which leads me to believe I'm doing somthing wrong.
Mysqld running as root.
Hello, I'm a newbe to Linux and MySQL, but I'm finding it very interesting. I'll cut right to the chase - I've followed the directions in the manual for the binary install on Linux. but every time I start up the mysql daemon and do a pstree -laup, it's running as root. This is on a development / play machine so it's not that big a deal, but my system admin says that I have to run it as user=mysql. I've tried changing the mysql.server script, the my.cnf file, etc. I cant figure it out - how to make it start up and run as user=mysql!?! Anywho - any help would be appreciated. Thanks, Sean.