List:General Discussion« Previous MessageNext Message »
From:F.A.I.Z.A.L Date:September 30 2009 10:54am
Subject:Re: iam new bee to mysql
View as plain text  
hi Daisley

thanks for your answers

Best Regards
Faizal S
GSM : 9840118673
Blog: http://oradbapro.blogspot.com


On Wed, Sep 30, 2009 at 4:20 PM, John Daisley
<john@stripped>wrote:

> 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