List:General Discussion« Previous MessageNext Message »
From:John Daisley Date:September 30 2009 10:50am
Subject:RE: iam new bee to mysql
View as plain text  
Basic answers under each of your questions below


-----Original Message-----
From: F.A.I.Z.A.L <sac.faizal@stripped>
Sent: Wednesday, September 30, 2009 11:11 AM
To: John Daisley <john@stripped>
Cc: mysql@stripped
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 user@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
<john@stripped>wrote:



[The entire original message is not included]
Thread
iam new bee to mysqlF.A.I.Z.A.L30 Sep
RE: iam new bee to mysqlJohn Daisley30 Sep
  • Re: iam new bee to mysqlF.A.I.Z.A.L30 Sep
  • Re: iam new bee to mysqlMartijn Tonies30 Sep
    • Re: iam new bee to mysqlF.A.I.Z.A.L30 Sep
  • Re: iam new bee to mysqlMartijn Tonies30 Sep
    • Re: iam new bee to mysqlF.A.I.Z.A.L30 Sep
RE: iam new bee to mysqlJohn Daisley30 Sep
  • Re: iam new bee to mysqlF.A.I.Z.A.L30 Sep