Need a little support.

nabachi's Avatar
Newbie 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
0
shabbir's Avatar, Join Date: Jul 2004
Go4Expert Founder
MySQL Query Browser is there for windows but I am not sure if it has any version for *nix.
0
pradeep's Avatar, Join Date: Apr 2005
Team Leader
Yes, MySQL Query Browser has a *nix version too! If you have trouble installing it, phpMyAdmin is the best solution!
0
nabachi's Avatar
Newbie 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
0
pradeep's Avatar, Join Date: Apr 2005
Team Leader
Check this out http://www.go4expert.com/showthread.php?t=567
0
shabbir's Avatar, Join Date: Jul 2004
Go4Expert Founder
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
0
nabachi's Avatar
Newbie 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.