1. We have moved from vBulletin to XenForo and you are viewing the site in the middle of the move. Though the functional aspect of everything is working fine, we are still working on other changes including the new design on Xenforo.
    Dismiss Notice

Need a little support.

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

  1. nabachi

    nabachi New Member

    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

    MySQL Query Browser is there for windows but I am not sure if it has any version for *nix.
     
  3. pradeep

    pradeep Team Leader

    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

    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

  6. shabbir

    shabbir Administrator Staff Member

    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

    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