Re: [libreoffice-users] MySQL on a network

On 02/16/2013 06:44 PM, Heinrich Stoellinger wrote:
> On Sat, 16 Feb 2013 23:44:09 +0100, Dan Lewis 
> <elderdanlewis@gmail.com> wrote:
>
> >        I can connect to the MySQL server (5.5) on the same computer
> > using localhost. But how do I connect to a MySQL server on another
> > computer on the same network? I can not find it in the MySQL manual, or
> > I don't know where to look in it.
> >       I use MySQL Workbench for administrative purposes.
> >
> > --Dan
> Hi Dan,
> When you define your MySQL-database under LO-Base, specify the 
> hostname (or the
> IP-address) of the server as well as the port (usually 3306) instead 
> of "localhost".
> I am actually using a MySQL-server over the internet. It works o.k....
> Regards H
     More information: My laptop is 192.168.2.101 and the MySQL server 
is on 192.168.2.100. The database I want to access is Budget.
     I entered Budget as the database name, Server as 192.168.2.100, 
port is 3306. I then test the connection, enter the user name and 
password. The error message I get is "Host '192.168.2.101' is not 
allowed to connect to this MySQL server".
     I am using the MySQL JDBC  driver, and when I click the  "Test 
Class" button, I get the message "The JDBC Driver was loaded successfully."
     Any suggestions as to what I might be doing wrong?

--Dan

--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted