1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Need a little support.

Discussion in 'Database' started by nabachi, Aug 8, 2007.

  1. nabachi

    nabachi New Member

    Joined:
    Aug 8, 2007
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    0
    Hi,

    Im new to this forum and to mysql. Im using Fedora core 7, and i have installed mysql. I tried to create a database in the terminal, but its very confusing.

    Is there any GUI application to creat databases in mysql? and i would appriciate if someone gives me some hints and tips.

    thanks in advance :)
     
  2. shabbir

    shabbir Administrator Staff Member

    Joined:
    Jul 12, 2004
    Messages:
    15,292
    Likes Received:
    365
    Trophy Points:
    83
    MySQL Query Browser is there for windows but I am not sure if it has any version for *nix.
     
  3. pradeep

    pradeep Team Leader

    Joined:
    Apr 4, 2005
    Messages:
    1,646
    Likes Received:
    86
    Trophy Points:
    0
    Occupation:
    Programmer
    Location:
    Kolkata, India
    Home Page:
    Yes, MySQL Query Browser has a *nix version too! If you have trouble installing it, phpMyAdmin is the best solution!
     
  4. nabachi

    nabachi New Member

    Joined:
    Aug 8, 2007
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    0
    HI..
    thanks for your help........I really appreciate it.
    but it seems that i need to create the database first, because both of them requires to connect to it first......can anyone give me an easy way to create the database and tables tables...or a link to a nice tutorial ??

    and one more thing, do you know where the tables are located in linux?

    cheers :)
     
  5. pradeep

    pradeep Team Leader

    Joined:
    Apr 4, 2005
    Messages:
    1,646
    Likes Received:
    86
    Trophy Points:
    0
    Occupation:
    Programmer
    Location:
    Kolkata, India
    Home Page:
  6. shabbir

    shabbir Administrator Staff Member

    Joined:
    Jul 12, 2004
    Messages:
    15,292
    Likes Received:
    365
    Trophy Points:
    83
    Code:
    CREATE [TEMPORARY] TABLE [IF NOT EXISTS] tbl_name
        (create_definition,...)
        [table_option ...]
    For complete details refer - Create Tables

    Code:
    CREATE {DATABASE | SCHEMA} [IF NOT EXISTS] db_name
        [create_specification [create_specification] ...]
    For complete details refer - Create Databases
     
  7. nabachi

    nabachi New Member

    Joined:
    Aug 8, 2007
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    0
    Hi all...
    Thanks agian. Your replies gave me an incredible amount of knowledge for me about this. Thanks a lot. and by the way, i have installed webmin which seems a nice web interface tool. Is this a good tool for server administration? forgive me if this is out of my topic. I just wanted your opinion.

    Thanks to all that helped me. I will try these tutorials and let you know.

    nabachi.
     

Share This Page