Re: [libreoffice-users] Re-Connecting LO Base to an SQL DB

Hi All

(In particular I hope *Heinz* picks this up as he was so helpful last 
time!!)

I have just upgraded my PClinuxOS system with the latest 2013.02 
version. To do this I used an ISO disk and ran the upgrade without 
overwriting or formatting 'home' to preserve my data etc. It installed 
perfectly and almost all my stuff is available and working.

The two areas I have problems with are -
1) I have no sound (but will work on that later).
2) More importantly I can not access my MySQL Database!!

MySQL is part of the new installation and I have set it to 'Start on Boot'.
I re-installed MyAdmin via Synaptic
I should have the Connector in the installation.
I edited out the "skip networking" line in /etc/my.cnf

Now if I try to run MyAdmin I get the error ...

/"//The mysqli extension is missing. Please check your PHP 
configuration. <a href="Documentation.html#faqmysql" 
target="documentation"><img src="themes/dot.gif" title="Documentation" 
alt="Documentation" class="icon ic_b_help" /></a>"/

So I installed mysqli via Synaptic, did a re-boot and tried again but 
still get the same error!!

I decided to move on anyway and started Base, selected Connect to 
existing database, using JDBC, entered DB Name, localhost, port 3306 and 
tested the connection. It gives me "JDBC Driver loaded OK"

I accepted the Driver Class and tested and I get the error ...

/"Error code: 1045//
//Access denied for user 'ianw'@'localhost' (using password: YES)"/

Where have I gone wrong or can you see any errors on my part??

This MySQL Database was working perfectly before I upgraded the OpSys!!

Very many thanks as always!!

IanW
Pretoria RSA






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