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
