[nabachi]

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

[shabbir]

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

[pradeep]

Yes, MySQL Query Browser has a *nix version too! If you have trouble installing it, phpMyAdmin is the best solution!

[nabachi]

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

[pradeep]

Check this out http://www.go4expert.com/showthread.php?t=567

[shabbir]

CREATE [TEMPORARY] TABLE [IF NOT EXISTS] tbl_name
    (create_definition,...)
    [table_option ...]

For complete details refer - Create Tables

CREATE {DATABASE | SCHEMA} [IF NOT EXISTS] db_name
    [create_specification [create_specification] ...]

For complete details refer - Create Databases

[nabachi]

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.