On 02/16/2013 06:44 PM, Heinrich Stoellinger wrote:
On Sat, 16 Feb 2013 23:44:09 +0100, Dan Lewis
<[email protected]> 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: [email protected]
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
