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 archive was generated by hypermail 2.1.3 : Fri Aug 01 2014 - 16:14:55 EDT