On 11/01/2012 08:42 AM, Ian Whitfield wrote:
I see you created a user name 'lanw' in My Admin. That is a good
start. You also have to use My Admin to define what schema 'lanw' can
access. Then you need to define what privileges 'lanw' should have for
the databases in those schema.
I can not be very specific because I no longer use MySQL 5.1. When
I updated my Ubuntu OS, it installed MySQL 5.6. But I do know from
personal experience that you can not access a database using a user name
until you have entered what Schema it can access and what privileges it
has for specific databases within the schema for which it has access.
Well I even went off this morning looking at 'other' solutions for
this and it seems to be - Use Base or go and learn PHP or Ruby or
something like that!!
So I got into Base again and found an interesting fact - Base had
_NOT_ stored the link in it's Driver Class!! After a couple of
re-tries it now seems to have done that and I can now get past the
'Test Class' stage OK!!!
The next screen is 'Authentication' - I enter the User Name and select
"Test Connection" and I get
Communication Link Failure
The last packet sent successfully to the Server was 0 milliseconds
The driver has not received any packets from the Server.
OK - Now I'm stuck again...... My Database (Schema) was called
'federals_Members.sql' when I first created it but last week I had to
re-install my OpSys and to get it back into MyAdmin I had to import it
and it's now there called 'Test'!! Neither of the above two file names
make any difference to the error message.
Next the User Name - In My Admin it is 'root', when I set-up the
Database I used 'Ianw' and my System login is 'Ianw' also. Again
neither of these changes the error message.
To check I started MyAdmin and it connects fine with the Database and
displays the table structure just fine.
So why wont Base connect to it???
For unsubscribe instructions e-mail to: firstname.lastname@example.org
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] Connecting LO Base to an SQL DB · Dan Lewis
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy