MySQL Interface
 

I installed MySQL using its RPM package but how do I view the MySQL database interface/GUI?

Thanks,

Ron

I suspect you mean phpMyAdmin, which is a totally separate tool, iirc it's not even written by the MySQL guys.
You'll need to install it via your pkg mgr.

Thanks, Chris, for the prompt response.

Actually what I want is the GUI using which one can carry out various database-related tasks like creating databases, tables, stored procedures etc. I am working on Mandriva 2007 Spring which has a in-built database (under the Office category). Using the GUI of this database, one can add databases, tables, forms, reports etc. That´s what I am on the lookout for as far as MySQL is concerned. I hope I am made things clearer.

So do I need to install phpMyAdmin as you have suggested?

The Windows version of MySQL does have a GUI to do different database tasks (somewhat like Microsoft SQL Server).

Thanks once again,

Regards,

Ron

phpMyAdmin is a great tool. it has everything that you are looking for (creating, removing, modifying, and updating databases, tables, uesrs, etc). if you already have php, then phpMyAdmin is for you. also it's very easy to configure.

If you look at the phpMyAdmin page you will see that it is exactly as you describe, and as Chris suggested.

I prefer mysql administrator from mysql.com of course :]
http://www.mysql.com/products/tools/administrator/

Thanks, friends, for your suggestions. I finally downloaded & installed phpMyAdmin (using the Software Media Manager) but when I start it from KMenu, nothing happens.

When I had a look at the Command it has been assigned in the KMenu Editor, it says

"/usr/bin/www-browser http://localhost/phpmyadmin/"

Why isn´t phpMyAdmin starting? Do I have to configure it? If yes, then how do I configure it? Note that I have Apache web server installed & it was running when I tried to open phpMyAdmin.

Thanks once again,

Regards,

Ron

Open whatever browser you use (hope it's firefox!), and in the address bar type (make sure you have Apache and MySQL running when you do this):

http://localhost/phpmyadmin/

and you should be good to go from there! If you do want to configure it (which you should), navigate to the installation directory, and edit this file:

config.inc.php

There's also a GUI that you can use for the more recent version of phpmyadmin, but just edit the config file by hand-it's much handier!

-David