LinuxQuestions.org
Help answer threads with 0 replies.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
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!

Notices


Reply
  Search this Thread
Old 09-06-2007, 02:28 AM   #1
rn5a
Member
 
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?

Thanks,

Ron
 
Old 09-06-2007, 02:40 AM   #2
chrism01
LQ Guru
 
Registered: Aug 2004
Location: Sydney
Distribution: Centos 6.8, Centos 5.10
Posts: 17,247

Rep: Reputation: 2328Reputation: 2328Reputation: 2328Reputation: 2328Reputation: 2328Reputation: 2328Reputation: 2328Reputation: 2328Reputation: 2328Reputation: 2328Reputation: 2328
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
rn5a
Member
 
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,

Regards,

Ron
 
Old 09-06-2007, 06:27 AM   #4
dark_angel
Member
 
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
Poetics
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
lord-fu
Member
 
Registered: Apr 2005
Location: Ohio
Distribution: Slackware && freeBSD
Posts: 676

Rep: Reputation: 30
I prefer mysql administrator from mysql.com of course :]
http://www.mysql.com/products/tools/administrator/
 
Old 09-07-2007, 06:49 AM   #7
rn5a
Member
 
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,

Regards,

Ron
 
Old 09-07-2007, 07:13 AM   #8
SpiderIRE
Member
 
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):

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
 
  


Reply


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


All times are GMT -5. The time now is 09:43 PM.

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