Latest LQ Deal: Complete CCNA, CCNP & Red Hat Certification Training Bundle
Go Back > Forums > Linux Forums > Linux - Newbie
User Name
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!


  Search this Thread
Old 09-06-2007, 02:28 AM   #1
Registered: Aug 2007
Posts: 48

Rep: Reputation: 15
Question MySQL Interface

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


Old 09-06-2007, 02:40 AM   #2
LQ Guru
Registered: Aug 2004
Location: Sydney
Distribution: Centos 6.9, Centos 7.3
Posts: 17,417

Rep: Reputation: 2397Reputation: 2397Reputation: 2397Reputation: 2397Reputation: 2397Reputation: 2397Reputation: 2397Reputation: 2397Reputation: 2397Reputation: 2397Reputation: 2397
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.
Old 09-06-2007, 03:05 AM   #3
Registered: Aug 2007
Posts: 48

Original Poster
Rep: Reputation: 15
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,


Old 09-06-2007, 06:27 AM   #4
Registered: Oct 2006
Location: Bacolod, Philippines
Distribution: Slackware 12
Posts: 62

Rep: Reputation: 15
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.
Old 09-06-2007, 03:31 PM   #5
Senior Member
Registered: Jun 2003
Location: California
Distribution: Slackware
Posts: 1,181

Rep: Reputation: 49
If you look at the phpMyAdmin page you will see that it is exactly as you describe, and as Chris suggested.
Old 09-06-2007, 03:33 PM   #6
Registered: Apr 2005
Location: Ohio
Distribution: Slackware && freeBSD
Posts: 676

Rep: Reputation: 30
I prefer mysql administrator from of course :]
Old 09-07-2007, 06:49 AM   #7
Registered: Aug 2007
Posts: 48

Original Poster
Rep: Reputation: 15
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,


Old 09-07-2007, 07:13 AM   #8
Registered: Jan 2005
Distribution: FC (Planet CCRMA Kernel)
Posts: 81

Rep: Reputation: 15
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):


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:

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!



Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
mysql error Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. SpellChainz Linux - Newbie 1 06-23-2007 04:35 PM
LXer: Create a Web-based interface for MySQL databases in a flash with phpMyEdit LXer Syndicated Linux News 0 03-09-2007 09:16 AM
WPA support through 'ndiswrapper' interface is deprecated; use 'wext' interface lavie Linux - Wireless Networking 1 12-04-2006 12:13 PM
mysql error Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. Dannux Linux - Software 3 03-24-2006 09:44 AM > Forums > Linux Forums > Linux - Newbie

All times are GMT -5. The time now is 01:22 PM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration