Basic answers under each of your questions below
-----Original Message----- From: F.A.I.Z.A.L <sac.fai...@gmail.com> Sent: Wednesday, September 30, 2009 11:11 AM To: John Daisley <j...@butterflysystems.co.uk> Cc: mysql@lists.mysql.com Subject: Re: iam new bee to mysql Hi 1. can you please explain me about mysql 5 architecture and background process.. You need to read the manual for this. Start here http://dev.mysql.com/doc/refman/5.1/en/features.html 2. how to create a schema in mysql Create schema schema_name; Create database schema_name; 3. is there anything like tablespace in oracle.. Yes and no! Read the manual sections relating to storage engines especially innodb. http://dev.mysql.com/doc/refman/5.1/en/storage-engines.html 4. if yes, how to create tablespace. Create tablespace ..... See the ref manual for the full syntax but make sure you understand how and when mysql uses tablespace. http://dev.mysql.com/doc/refman/5.1/en/create-tablespace.html 5. how is storage system in mysql. in oracle, tablespace->segment->extend->block, is there anything like that in mysql Read the manual section on storage engines as it varies by engine http://dev.mysql.com/doc/refman/5.1/en/storage-engines.html 6. how to create user, grant privilege to them Grant priv on schema.table to u...@host identified by 'password'; Read the manual section on grant http://dev.mysql.com/doc/refman/5.1/en/grant.html thanks in advance.. Best Regards Faizal S GSM : 9840118673 Blog: http://oradbapro.blogspot.com On Wed, Sep 30, 2009 at 1:51 PM, John Daisley <j...@butterflysystems.co.uk>wrote: [The entire original message is not included] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
