Date: prev next · Thread: first prev next last
2012 Archives by date, by thread · List index


On 11/01/2012 08:42 AM, Ian Whitfield wrote:
Thanks Heinz

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 ago.
   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???

Thanks

IanW


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.

--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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: 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.