LinuxQuestions.org
Visit Jeremy's Blog.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 07-24-2003, 10:48 PM   #1
noshellswill
LQ Newbie
 
Registered: Jul 2003
Posts: 13

Rep: Reputation: 0
Angry mysqlcc tutorial


Gents:

My first post: running RH_8 / P4@2.6 / P4S333 - Single Usr Unsupported Desktop (SUUD).

Couple weeks ago I DLoaded & installed the database MySQL. I've followed the manual tutorial on < webdevelopersnotes.com > and discovered the database and text-control-language is plenty friendly & a likely upgrade from ACCESS for my small home business.
'Course in practice, ya can't really enter 60-90 data_lines a day manually without oodles of errors. Optimistic, I went looking for a GUI front_end. Following various NG comments, couple days ago I DLoaded & installed locally ( /home/me/blablabla) "mysqlcc" as a likely GUI front end.
It was UGLY! While I can "punch-it-up", I can't make the first piece-of-sence or get any function out of that proggie. Totally hostile, non-obvious cluttered screens. And stump-dumb for not auto-locating and configuring itself to the installed ( & running ) MySQL . Tons of stuff must have to be assigned manually. Guess mysqlcc is still a beta or maybe the company wants to be paid for supporting a GUI. Whatever .....
SOOO - is there a detailed step-by-step tutorial available for configuring & using mysqlcc as there is for the database itself ?? Or is there a "smarter" , better documented MySQL GUI for *nix?
 
Old 07-24-2003, 11:37 PM   #2
luap
Member
 
Registered: Feb 2003
Location: atlanta ga usa
Distribution: suse 8.2
Posts: 78

Rep: Reputation: 15
hello, i'm looking for the same thing. i'm trying to use staroffice/openoffice data source tools, and not succeeding,
but that could be due to my lack of knowledge about mysql and
staroffice-openoffice. so maybe you could try openoffice, unixobdc driver and mysql. you can find an openoffice how -to
on the openoffice website, ditto for staroffice at sun's site.
i think you can get the unixobdc from mysql's site(i got mine from gentoo's ebuild collection).i'm connecting from both open and star to mysql, but cant add(insert?) data to my existing tables yet.
 
Old 07-31-2003, 12:19 AM   #3
noshellswill
LQ Newbie
 
Registered: Jul 2003
Posts: 13

Original Poster
Rep: Reputation: 0
Angry data entry

Luap:

I'm doing the MySQL (practice) data-entry by hand . Actually, I feel maybe a bit more secure learning the database this way --- but for serious work that foolishness HAS to stop.
You would think ( even *nix ) folks charging for software will focus on "usability". Good luck ! A 90-wpm awk/grep/sed admin type may care less, but then he WON'T PAY for a smooth, transparant GUI !!!
 
Old 07-31-2003, 08:47 PM   #4
luap
Member
 
Registered: Feb 2003
Location: atlanta ga usa
Distribution: suse 8.2
Posts: 78

Rep: Reputation: 15
hi,
i dont mind creating dbs and tables from mysql's monitor
(cli) or with mysqlcc. but my project involves cataloging my music cd collection, then using the cd collection to practice query etc. with over 200 cds to catalogue by artist, title,
track names, times, etc. yada yada, thats a lot of stuff to type. thus my quest for the fastest way. still no luck with being able to enter data thru a form thru star-openoffice.
puzzling- record entry functions appear to be there but wont function. so i'm cheating a bit by using sqlyog on windows.
far less clunky than mysqlcc. but no linux version.
 
Old 08-01-2003, 12:38 PM   #5
luap
Member
 
Registered: Feb 2003
Location: atlanta ga usa
Distribution: suse 8.2
Posts: 78

Rep: Reputation: 15
hi,
i got star office working, can now data entry thru table entry or thru an access like form design. this is still on windows. the issue
was grant privileges for the specific user/tables. however i feel pretty confident that i will be able to use star/open office once
i get the mysql running properly on my gentoo.
on windows, i am using "root" user, passworded, (all other users
deleted), root given global privileges. at this point i fired up both
mysqlcc and sqlyog, created db, tables, and did my data entry,
no problem. but star/open office wasnt allowing data entry.
i found a thread about this, and essentially i needed to simply
go back and grant privileges to "root" to use the specific db/tables. i believe this step is pretty well documented in mysql,
but in my newbness i blithely ignored it, since the windows based
apps didnt care. star/open office seem to adhere to mysql's
security set up, and require what mysql documents.
try using star/open office as your interface.
 
Old 09-09-2003, 10:35 AM   #6
buttersoft
Member
 
Registered: Aug 2003
Distribution: Slackware
Posts: 178

Rep: Reputation: 30
Have you tried mysqlManager from http://www.ems-hitech.com,
it is an excellent GUI interface to mysql........

With it you can import from virtually anything that creates .csv files, so there is no problem anymore with big file imports. It cost some money of course, but it is a fabulous bit of neat programming.

I rely on it.

Also you can use knoda, also for input, that is also a neat piece of programming.

Last edited by buttersoft; 09-09-2003 at 10:38 AM.
 
  


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
[ubuntu] Mysqlcc Flippje Linux - Newbie 1 11-20-2005 07:39 PM
Mysqlcc connection denied BlackHatRob Linux - Software 1 09-15-2005 10:34 PM
MySQLCC segmentation fault Swift&Smart Linux - Software 11 11-03-2003 09:51 AM
mysqlcc on windows error thack111 Linux - Newbie 4 10-23-2003 08:23 AM
MySQLCC rivang Linux - Software 2 06-07-2003 11:11 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 11:44 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
Open Source Consulting | Domain Registration