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