Re: [libreoffice-users] MySQL on a network
On Sun, 17 Feb 2013 03:31:22 +0100, Girvin R. Herr girvin.h...@sbcglobal.net
wrote:
Dan Lewis wrote:
On 02/16/2013 06:44 PM, Heinrich Stoellinger wrote:
On Sat, 16 Feb 2013 23:44:09 +0100, Dan Lewis
elderdanle...@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
Sounds like the server is not configured to allow you access. Since the
IP addresses for the server and your computer are on the same LAN, I can
assume the MySQL server is on another computer on the same LAN. You
don't say if you did this in mysql:
GRANT ALL PRIVILEGES ON *.* TO username@hostname IDENTIFIED BY
`password` WITH GRANT OPTION;
Note that the hostname should be the IP address of your laptop, or
192.168.2.101 . Note that the IP address may need around it due to
the periods and numbers.
If not, the server will not allow you access. The laptop is not
registered as a trusted computer. You must have done this for your
other computer, but you need to do it for all computers you need access
for. Or, if you are brave, you can use % for any host:
username@%. Or, better yet, you can limit access to your LAN:
username@192.168.2.%
For further information, this can be found in the MySQL reference manual
under Access Control, Stage 1: Connection Verification.
Hope this helps.
Girvin Herr
Hello again,
The IP-address has to be that of the SERVER, and - of course as Girvin says -
access has to be granted to you on the server as mentioned. By the way -
I tend to use single apostrophies (') instead of , if necessary on the
GRANT statements.
Regards and good luck
--
Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/
--
For unsubscribe instructions e-mail to: users+h...@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
Re: [libreoffice-users] MySQL on a network
Heinrich , fine, in the past there where some issues about remote connections, but how do you manage the security of your connection greetz Fernand On Sat, 16 Feb 2013 23:44:09 +0100, Dan Lewis elderdanle...@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 -- For unsubscribe instructions e-mail to: users+h...@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
Re: [libreoffice-users] MySQL on a network
On Sat, 16 Feb 2013 23:44:09 +0100, Dan Lewis elderdanle...@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 -- Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/ -- For unsubscribe instructions e-mail to: users+h...@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
Re: [libreoffice-users] MySQL on a network
Dan Lewis wrote: On 02/16/2013 06:44 PM, Heinrich Stoellinger wrote: On Sat, 16 Feb 2013 23:44:09 +0100, Dan Lewis elderdanle...@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 Sounds like the server is not configured to allow you access. Since the IP addresses for the server and your computer are on the same LAN, I can assume the MySQL server is on another computer on the same LAN. You don't say if you did this in mysql: GRANT ALL PRIVILEGES ON *.* TO username@hostname IDENTIFIED BY `password` WITH GRANT OPTION; Note that the hostname should be the IP address of your laptop, or 192.168.2.101 . Note that the IP address may need around it due to the periods and numbers. If not, the server will not allow you access. The laptop is not registered as a trusted computer. You must have done this for your other computer, but you need to do it for all computers you need access for. Or, if you are brave, you can use % for any host: username@%. Or, better yet, you can limit access to your LAN: username@192.168.2.% For further information, this can be found in the MySQL reference manual under Access Control, Stage 1: Connection Verification. Hope this helps. Girvin Herr -- For unsubscribe instructions e-mail to: users+h...@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
