Re: [SLUG] MySQL DB Connection

From: SOTL (sotl155360@earthlink.net)
Date: Fri Mar 18 2005 - 09:53:23 EST


Hi All

Thanks for the response.
Judging from what I accomplished of failed to accomplish this morning I am
believe that before I will be able to sort the MySQL issues out I will have
to sort out some router issues out first.

More on this latter as I must be off to the old salt mine.

Frank

Oh and thanks for the help.

On Thursday 17 March 2005 19:11, Larry Brown wrote:
> The machine running mysql must be able to resolve the remote machine's
> name and have rights set up for your user to connect from the remote
> machine. By default, the only access possible is from localhost on the
> server machine. You can put your remote computer's name in /etc/hosts
> on the mysql server machine and then add the appropriate entries in the
> user table of the "mysql" database. If you are going to be doing a lot
> of work with MySQL, I'd recommend the book called MySQL by John DuBois.
> It is as thorough as you are going to get.
>
> Hope that helps...
>
> On Thu, 2005-03-17 at 17:57, SOTL wrote:
> > Hi All
> >
> > I am trying to connect to a MySQL data base using OpenOffice with the
> > files located in a second computer networked to the first by a router.
> > NFS is not installed nor is somba.
> >
> > The address of the second computer is 192.168.1.251.
> > The second computer hass the database located at:
> > /mnt/System_Data/My_DataBase/OpenOffice
> >
> > When I attempt to do a setup I get the following appearing in the URL
> > window: sdbc:MSQL:jdbc
> > <host><3306>/<DBNAME>
> >
> > I am assuming that <host> is 192.168.1.251
> > and I assume that
> > <DBNAME> is /mnt/System_Data/My_DataBase/OpenOffice
> > but
> > What does <3306> mean?
> >
> > Thanks
> >
> > Frank
> >
> >
> >
> >
> >
> > -----------------------------------------------------------------------
> > This list is provided as an unmoderated internet service by Networked
> > Knowledge Systems (NKS). Views and opinions expressed in messages
> > posted are those of the author and do not necessarily reflect the
> > official policy or position of NKS or any of its employees.
>
> -----------------------------------------------------------------------
> This list is provided as an unmoderated internet service by Networked
> Knowledge Systems (NKS). Views and opinions expressed in messages
> posted are those of the author and do not necessarily reflect the
> official policy or position of NKS or any of its employees.
-----------------------------------------------------------------------
This list is provided as an unmoderated internet service by Networked
Knowledge Systems (NKS). Views and opinions expressed in messages
posted are those of the author and do not necessarily reflect the
official policy or position of NKS or any of its employees.



This archive was generated by hypermail 2.1.3 : Fri Aug 01 2014 - 16:15:00 EDT