LinuxQuestions.org
Review your favorite Linux distribution.
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 11-07-2005, 10:57 AM   #1
crispyleif
Member
 
Registered: Mar 2005
Location: Norway, by the coast
Distribution: Debian and the likes
Posts: 190

Rep: Reputation: 31
Very basic newbie question regarding MySQL


Hi

Straight on : I've been using MS access in the past, and now I need a similar tool in linux.
I understand MySQL is the solution ? According to what I've heard it's supposed to be quite better...

Anyway, MySQL is installed but I can't find out how to use it ! Must I make some sort of server and connect to it ?

Please ppl, I know that this seems utterly newbie, but I would really appreciate some info on this..

Not often google can't help me out
 
Old 11-07-2005, 11:26 AM   #2
stickman
Senior Member
 
Registered: Sep 2002
Location: Nashville, TN
Posts: 1,552

Rep: Reputation: 53
Yes, you must configure and start mysqld. You can use the CLI mysql client or a myriad of GUI client to connect.
 
Old 11-07-2005, 11:36 AM   #3
crispyleif
Member
 
Registered: Mar 2005
Location: Norway, by the coast
Distribution: Debian and the likes
Posts: 190

Original Poster
Rep: Reputation: 31
Thanks man !

I installed mysql-client navigator and that seems like a god tool so far.

But what I would love is something that gave me the same interface to making databases that access uses ? I'm not against learning new things, it's just that making databases from the command line seems a bit "old-fashioned" ...

Any idea how to do that ?
 
Old 11-07-2005, 12:12 PM   #4
pnellesen
Member
 
Registered: Oct 2004
Location: Missouri, USA
Distribution: Slackware 12.2, Xubuntu 9.10
Posts: 371

Rep: Reputation: 31
You might want to look at "mysql-query-browser" and "mysql-administrator" (both are GUI-type apps, and both are available at the MySQL website.) While not exactly like Access, they do provide most of the same functionality - I found them to be a pretty good replacement myself; I was looking for more or less the same thing you are when I switched to MySQL.
 
Old 11-07-2005, 12:16 PM   #5
crispyleif
Member
 
Registered: Mar 2005
Location: Norway, by the coast
Distribution: Debian and the likes
Posts: 190

Original Poster
Rep: Reputation: 31
Man, now I feel stupid here

I have installed MySQL administrator... I start it and it wants me to login to a mysql server.

That's my problem, I'm used to start MS access and start editing tables...

If I must create/start a server first, how do I do that ?

- I feel like I'm closing in on it here, thanks for the help !
 
Old 11-07-2005, 03:18 PM   #6
pnellesen
Member
 
Registered: Oct 2004
Location: Missouri, USA
Distribution: Slackware 12.2, Xubuntu 9.10
Posts: 371

Rep: Reputation: 31
Ah, yeah, getting MySQL up and running. That's the FUN part

About all I can say to that is check out the installation/setup documentation on the MySQL site - it's pretty thorough, but you will need to get really friendly with the command line... At least, I had to, but there may be other tools out there that make it easier...

Good Luck! There's TONS of MySQL threads on this site - I was able to get my MySQL install up and running mostly by searching through them for questions I couldn't answer via the MySQL documentation.
 
Old 11-07-2005, 03:43 PM   #7
Hangdog42
LQ Veteran
 
Registered: Feb 2003
Location: Maryland
Distribution: Slackware
Posts: 7,791
Blog Entries: 1

Rep: Reputation: 414Reputation: 414Reputation: 414Reputation: 414Reputation: 414
I don't know if this helps, but the Open Office suite has a dbase program that is supposedly similar in concept to MS Access. It can either work as a stand-alone program or it can connect to a database server like MySQL.
 
Old 11-07-2005, 08:13 PM   #8
crispyleif
Member
 
Registered: Mar 2005
Location: Norway, by the coast
Distribution: Debian and the likes
Posts: 190

Original Poster
Rep: Reputation: 31
Finally got it ! Somehow I had not seen the tutorial at the mysql site... once the basic was running, I could connect via mysql administrator.

Thanks for all the help & suggestions !
 
Old 11-07-2005, 10:59 PM   #9
oz_ollie
LQ Newbie
 
Registered: Jul 2005
Distribution: Red Hat 5.2 - 9, SUSE LINUX 9.0 - 10, Mandrake, Knoppix, Morphix, Ubuntu, Kubuntu, Debian,
Posts: 7

Rep: Reputation: 1
There are a number of interfaces that can use MySQL as the backend but provide an Access-like way of designing and managing databases. Look at:

Knoda - http://www.knoda.org/
Mergeant - http://www.gnome-db.org/
Rekall - http://www.rekallrevealed.org/kbExec.py

If your databases are on web servers there is also phpMyAdmin designed to manage MySQL databases over the network (can be used locally). Just be aware of security issues.

Hope these help.
 
Old 11-08-2005, 12:13 AM   #10
crispyleif
Member
 
Registered: Mar 2005
Location: Norway, by the coast
Distribution: Debian and the likes
Posts: 190

Original Poster
Rep: Reputation: 31
Tested Knode and found it (so far) even better than mysql administrator !

Thank you for the tip
 
  


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
A very basic newbie question on Java lmellen Programming 5 07-19-2004 04:59 PM
Basic mysql configuration noahzenzen Linux - Newbie 6 07-08-2004 12:05 PM
basic newbie question about fluxbox lmellen Linux - Newbie 4 06-24-2004 12:55 AM
Your basic newbie question... rcarr Linux - Newbie 1 09-27-2003 03:46 PM
Basic newbie networking question KellyH Linux - Networking 2 06-13-2003 07:21 AM


All times are GMT -5. The time now is 05:37 PM.

Main Menu
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
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration