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

Hi All

Latest situation ... (it's getting worse)

On Alex's recommendation about a possible 'bug' in my "latest" 
Libre-Office (PCLOS version), I downloaded 4.0.1 to my test machine 
directly from the LO Website and gave it a test yesterday.

All seemed well and it runs fine and I was able to connect to MySQL 
through MyAdmin.
(I didn't test any further).

Today I repeated the exercise on my WorkStation (same OpSys). But I can 
not now get MyAdmin to start-up at all, I get the error "Firefox is 
unable to connect". And if I try to connect through LO Base it fails at 
loading the JDBC Driver.

These are the steps I have done ...

Re-loaded*MyAdmin*- Database Manager. (*'**phpMyAdmin**'*through Synaptic).*
*(Not sure about MySQL Connector.-***'**mysql-connector-java-5.1.22'.* 
How do I check for this?If I look for it it tells me that it is in Java 
Archive)*
*Re-loaded*//mysqli Extension *via Synaptic

**Checked*my.cnf*file in /etc and comment out the line “skip networking” 
by putting a # at the front of it.
**STOPPED the MySQL Server in PCC and reset the MySQL root password.

1.

   Start the mysqld configuration *as SU*.

   mysqld --skip-grant-tables &

2.

   Login to MySQL as root.

   mysql -u root mysql

3.

   Replace YOURNEWPASSWORD with your new password!

   UPDATE user SET Password=PASSWORD('YOURNEWPASSWORD') WHERE User='root'; FLUSH PRIVILEGES; exit;

Re-started *MyAdmin* in the PCC.

**Started*MyAdmin* as 'root' with new password.

That's when I get the "failed to connect" error.

Any thoughts please.

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