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
Yes, MySQL Query Browser has a *nix version too! If you have trouble installing it, phpMyAdmin is the best solution!
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
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
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.