Re: MYSQL question - Urgent
Hi. Sorry, but I beg to differ. I think it is not a good idea to recommend to others to run the MySQL server as root. The manual explicitly recommends otherwise. On Mon, Apr 29, 2002 at 10:15:31PM -0600, [EMAIL PROTECTED] wrote: > > Questions: > - Do I use root account to install the software? > Yes to compile the source or do an RPM as seen below. > See http://www.mysql.com/doc/L/i/Linux-RPM.html The usual approch is to create an UNIX user "mysql" and give all files to him (of course, you need the root account to do so). If you use a reasonable distribution and can use the packaged MySQL, the package manager will do this for you (e.g. Debian, Mandrake,... don't know of others). Then you either start MySQL as "mysql". Or as root and tell MySQL (via command line option) to run as "mysql". This is surely described somewhere in the installation sections. Read it! It seems big but if you pick the parts relevant to your system, it's only some pages. And you will save a lot of hassle you would get later. > - What account do I use to create Innodb? > Same - I am guessing here but I do all installs as root then give > the needed permissions to others. Maybe I am not up to date here, but usually you only need a database login to create a database and that has nothing at all to do with the UNIX root. > - Who owns the data files? root or mysql > Root - See http://www.mysql.com/doc/P/r/Privilege_system.html The user the MySQL daemon runs as. I can only second the rest of the advices. [...] Bye, Benjamin. -- [EMAIL PROTECTED] - 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: MYSQL question - Urgent
Hi Lucia.. 1- The answers might/will be depent on what type of installation you are planning to do. Will you compile source code, or install binaries, or , since you said you would be installing on Linux, will you install from RPMs? 2 - Yes , you need to do the installation as root . 3 - There is no special account to create InnoDB tables, but you need to make sure that your MySQL server supports InnoDB tables.. Once the server supports it, anyone who has privileges to create tables, can create InnoDB tables. To ensure that you will have InnoDB support right after installation, make sure to download mysql-version*MAX* files. The files with the "MAX" word in it come with InnoDB support if InnoDB is available for that platform, and in your case, for Linux, yes it is. 4 - Data files (the database/table files) are owned by mysql . 5 - If you download and install *MAX* binaries for Linux, you'll already have InnoDB support . 6 - Those are the really databases. Those are same as what you define as the database name after '@' in oracle. The most recommended book on MySQL is MySQL by Paul Dubois, see its web page: http://www.kitebird.com/mysql-book/ . As for the user group, don't restrict yourself to the area you are living in, this list is a global user list of MySQL :) Make sure to visit the following pages: http://www.mysql.com/doc/L/i/Linux-RPM.html http://www.mysql.com/doc/I/n/Installing_binary.html http://www.mysql.com/doc/P/o/Post-installation.html Gurhan Ozen MCI WorldCom Quality Assurance Team [EMAIL PROTECTED] ph: 703-449-4754 Vnet: 228-4754 1-800-PAGE-MCI pin: 1927052 AIM: Greywolf1923 -Original Message- From: Lucia DeMeester [mailto:[EMAIL PROTECTED]] Sent: Monday, April 29, 2002 11:19 PM To: [EMAIL PROTECTED] Subject: MYSQL question - Urgent Importance: High I am an Oracle DBA and need to create a MYSQL database on Thursday. Can you answer my questions? (I have not had chance to read the manual yet. Just a quick search, I can not find my answer.) I plan to use InnoDB and I find it is quite similar to Oracle. However, in Oracle we install the software and create the instance and database as oracle but I can not find any place describe what user I should use to create mysql database. We use Linux. Questions: - Do I use root account to install the software? - What account do I use to create Innodb? - Who owns the data files? root or mysql - Any suggestion of the owner and group for the mysql files? - I think the process is to load the mysql software, then configure the Innodb. Once the Innodb is configured, when you mean startup or shutdown mysql server is this the same as shutdown the Innodb? - When I query show databases, it give me mysql, test1, test2. Are they really databases or they are like schema owners in Oracle and Innodb is like instance in Oracle. P.S. What is a good book to buy for the MYSQL database and any user group in the United States I can belong. Thanks very much. Lucia DeMeester New Media Merchants 858-882-8500 ext. 2314 - 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: MYSQL question - Urgent
Questions: - Do I use root account to install the software? Yes to compile the source or do an RPM as seen below. See http://www.mysql.com/doc/L/i/Linux-RPM.html - What account do I use to create Innodb? Same - I am guessing here but I do all installs as root then give the needed permissions to others. - Who owns the data files? root or mysql Root - See http://www.mysql.com/doc/P/r/Privilege_system.html - Any suggestion of the owner and group for the mysql files? See http://www.mysql.com/doc/P/r/Privilege_system.html - I think the process is to load the mysql software, then configure the Innodb. Once the Innodb is configured, when you mean startup or shutdown mysql server is this the same as shutdown the Innodb? see http://www.mysql.com/doc/I/n/InnoDB_overview.html for some help on this - When I query show databases, it give me mysql, test1, test2. Are they really databases or they are like schema owners in Oracle and Innodb is like instance in Oracle. Yes they are real. The MySQL one holds your user permissions See http://www.mysql.com/doc/P/r/Privilege_system.html P.S. What is a good book to buy for the MYSQL database and any user group in the United States I can belong. Number one is Paul DuBois - Search Amazon or Ask Paul here Your in the Best Mysql Newsgroup There are some heavy users here and they can help out but Please try and read the manual http://www.mysql.com/doc/index.html Also for commercial use you should take a look at http://www.mysql.com/doc/B/u/Business_Services_Commercial_licenses.html These are only my opinions but they work here 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
