LinuxQuestions.org
Welcome to the most active Linux Forum on the web.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Distributions > Fedora
User Name
Password
Fedora This forum is for the discussion of the Fedora Project.

Notices

Reply
 
Search this Thread
Old 05-05-2006, 06:55 AM   #1
dessonville50
LQ Newbie
 
Registered: May 2006
Location: Soutwestern Minnesota
Distribution: Fedora Core(s) 4 & 5
Posts: 1

Rep: Reputation: 0
connecting to mySQL server running on FC5


I am running Fedora Core 5 on my machine, the mySQL daemon is running active, however, either through documentation or my own meddling, I cannot figure out how to connect to this database through either OpenOffice or various Java IDE's. If someone has a reference link for this or just some tips. Please let me know. I'm also somewhat new to the world of Linux usage, so the more detailed description, the better.

Here are a few details on my system:
OS: Fedora Core 5
Ram: 256MB
CPU: Intel Celeron D 1.3GHz
40GB HDD

^ Yes, I know its weak, but I teach computer repair (A+ Certification) for a non-IT company, and there apparently is no money for upgrades.
 
Old 05-07-2006, 08:47 AM   #2
GL1800
Member
 
Registered: Jun 2005
Location: Lilburn, Ga
Distribution: FC5
Posts: 175

Rep: Reputation: 30
Man, me too, be interested in what you learn, if anything. OO "used to" have a wizard, with which I could open and massage around my MySQL datavase, find the tables, use them for mail merge, on and on. However, lately, all that has gone away from the releases. I MISS it!
 
Old 05-09-2006, 05:34 AM   #3
MRMadhav
Member
 
Registered: Nov 2005
Location: Mauritius
Distribution: PCQLinux, SUSE Linux,Fedora Core 5, Fedora Core 6, Knoppix Live, Kubuntu Edgy, PCLinuxOS
Posts: 167

Rep: Reputation: 30
I don't personally know how to use OO for connecting to mysql but i know some other useful apps. Firstly, you should be able to log in your mysql server via the konsole by typing mysql (works first time only, you should give a root password). When you have given the root password you will be able to access the mysql database only via a certain user name and password. For java i would suggest that you download the mysql-connector, the one that i use is "mysql-connector-java-3.1.11" you will get that from sun java's official web page(Sorry i no longer have the exact link to it) or you can get it on the MySQL-AB site itself.

Then for a graphical MySQL browser i would suggest SQuirreL SQL Client which is written in java(name is squirrel-sql-2.2final-install.jar) install by using the following command in konsole: "java -jar squirrel-sql-2.2final-install.jar"

You will see an icon for the app on you desktop. Launch it by double clicking it. You will see from the list of connectors the mysql connector, if not then you will have to add it manually by selecting Drivers -> new Driver and add the classpath in extra classpath. note that you should also know the connection string for the driver

in Class Name put : com.mysql.jdbc.Driver

give a name to the new driver and in the example url field put the connection string, e.g jdbc:mysql://localhost:3306/

click ok.


Then create a new alias;
Give a name, select a driver, correct the connection string(if necessary) and enter a user name and password. Click ok.
Then all you have to do is to use the alias to connect and you will see all the database in you mysql server.

Last edited by MRMadhav; 05-09-2006 at 05:36 AM.
 
Old 05-09-2006, 05:47 AM   #4
GL1800
Member
 
Registered: Jun 2005
Location: Lilburn, Ga
Distribution: FC5
Posts: 175

Rep: Reputation: 30
Well, I've made some progress here. Be SURE you HAVE oobase. Actually, I didn't. Start oobase, and there are some pretty easy to understand selections. I have tried a lot of that, connecting to existing databases is straightforward. By default, he already "knows about" your Evo contacts data, and will make that available. After you have made connections to these MySQL databases and tables, voila! just hit the F4 in oowriter, and there they are, just as we are accustomed to. He saves all this in .odb files and in my case, they go in ~/Documents. Good luck!
Ray
 
Old 05-09-2006, 06:00 AM   #5
GL1800
Member
 
Registered: Jun 2005
Location: Lilburn, Ga
Distribution: FC5
Posts: 175

Rep: Reputation: 30
Another Voila! It's simple to connect to my spreadsheets, (critical for me) and once connection is set up, an F4 opens them at the top, ready to reference, or paste into the document in oowriter. As an extra added attraction, in earlier OO's I was never able to get forms designer to do much, or report generator, etc., however all that works great now.
 
  


Reply

Tags
fedora, mysql


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
connecting PHP to MySQL in a LAMP server rickyglucas_143 Linux - Newbie 2 02-06-2006 04:02 AM
LXer: Running A MySQL-Based DNS Server: MyDNS LXer Syndicated Linux News 0 01-23-2006 09:31 AM
probs running MYSQL-SERVER on debian bennethos Debian 4 10-30-2004 08:10 AM
connecting to remote MySQL server acos7 Linux - Software 2 01-30-2004 11:37 PM
Connecting Mysql Database on remote server akamol Programming 4 10-16-2003 11:46 AM


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