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: [email protected]
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