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,375
    Likes Received:
    388
    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,645
    Likes Received:
    87
    Trophy Points:
    0
    Occupation:
    Programmer
    Location:
    Kolkata, India
    Home Page:
    http://blog.pradeep.net.in
    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,645
    Likes Received:
    87
    Trophy Points:
    0
    Occupation:
    Programmer
    Location:
    Kolkata, India
    Home Page:
    http://blog.pradeep.net.in
  6. shabbir

    shabbir Administrator Staff Member

    Joined:
    Jul 12, 2004
    Messages:
    15,375
    Likes Received:
    388
    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

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice