LinuxQuestions.org
Download your favorite Linux distribution at LQ ISO.
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 04-07-2004, 02:03 AM   #1
hct224
Member
 
Registered: Jun 2003
Distribution: Redhat
Posts: 87

Rep: Reputation: 15
MySQL GUI


Does anyone know of a good GUI for managing a MySQL database from my remote pc?
I want some softz work like MS-Access
Thanks
 
Old 04-07-2004, 02:14 AM   #2
biniar
Member
 
Registered: Jan 2004
Location: Michigan
Distribution: OpenBSD -current
Posts: 50

Rep: Reputation: 15
This probably isn't what you'd like exactly but it's sure worth a try, if you have all the required information to set it up correctly that is. PHPMyAdmin you can easily find it by going to <a href="http://www.sourceforge.net">Source Forge</a>.
 
Old 04-07-2004, 02:15 AM   #3
biniar
Member
 
Registered: Jan 2004
Location: Michigan
Distribution: OpenBSD -current
Posts: 50

Rep: Reputation: 15
http://www.sourceforge.net I didn't know there was'nt support for HTML, duh! I'm rather tired as it's early in the mourning here where I live.
 
Old 04-07-2004, 04:18 AM   #4
scott_R
Member
 
Registered: Jul 2003
Location: Brighton, Michigan, USA
Distribution: Lots of distros in the past, now Linux Mint
Posts: 746

Rep: Reputation: 31
The closest (IMO) thing to Access that works with MySQL is OpenOffice's DBA stuff. Personally, I prefer to set up and maintain the DB structure by hand (tends to take less time once you're used to it) through simple text files, use OO to make a cute little Access-like frontend (if you don't want a web-based frontend, or custom coded interface), which has the added benefit that once you get MySQL and OpenOffice interoperating (simple, but perhaps confusing to a Linux/MySQL/OO newbie), then you're set up to use the DB in writer, calc, impress, etc.

If you're proficient with Access, then OO's form creater will feel just about right. (Once you get used to the various quirks you have whenever you change software.) If you're not a big fan of Access (I'll spare you my rant) OO's interface will drive you just as batty.

For the record, I used to wonder why Linux didn't have any good Access-like interfaces. Play with databases enough, and you'll realize how inefficient they are. You spend more time moving around hitting the correct icon/buttons than you do actually thinking about how things are being set up. Plus, there's a layer of abstraction that MS loves to insert, that keeps you from really understanding how a DB works. For rapid prototyping, or testing out an idea, it's quick and dirty. For actual implementation and maintenance, it's a headache waiting to happen, IMHO.

Not that it's bad, but if you plan on doing this for work, it would behoove you to examine alternate approaches to DB creation. Nothing like the simplicity of typing:

mysql -u myname -p < textfilewithsql

Hmmm, guess I ranted anyway. Sorry.
 
  


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
GUI for mySQL John_Emad Programming 9 11-14-2006 04:30 AM
orientated GUI for MySQL FSalem Linux - Software 3 03-30-2005 10:20 AM
Any GUI for using mysql on Linux? ramdak5000 Linux - Software 3 02-08-2005 10:53 AM
mysql gui mayank Linux - Software 3 08-23-2003 07:39 AM
Does RH 8 have a GUI for mySQL? kidwired Linux - Distributions 6 02-20-2003 12:17 AM


All times are GMT -5. The time now is 03:37 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