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


Hi :)  
My quick, probably inaccurate guess is the connector.  Is the system 32 or 64bit?  Clearly a 
Gnu&Linux.  Is the MySql on the same computer or on a separate server?  
Regards from 
Tom :)  







________________________________
From: Ian Whitfield <whitfield@telkomsa.net>
To: users@global.libreoffice.org 
Sent: Tuesday, 12 March 2013, 13:35
Subject: [libreoffice-users] Problem with MySQL after upgrading OpSys

Hi All

Been busy for a few days with my monthly Journal so had to put this problem on the 'Back-Burner'.

I have been using Base for a few years now and finally got fed up with all the crashes and lost 
data. So late last year - with a LOT of very appreciated help from the Forum - I managed to get 
MySQL working 100% with Base as the front end.

At the beginning of March I upgraded my OpSys to the latest version (PClinuxOS 2013.02) and my 
LibreOffice to 4.0.0.3. I tried this first on a "Test Computer" I have here and all worked well, 
including MySQL!! So I upgraded my main machine.

I have everything working fine _EXCEPT_ for MySQL on this machine!! (Rather strange that one 
computer works and the other does not!! Both have Intel Motherboards and CPUs).

I seem to be at the stage that I can not get phpMyAdmin to run because of httpd, which I am unable 
to set to run at boot.

When I try to log in to phpMyAdmin I get the error "#1045 Cannot log in to the MySQL server"

I really need to "crack" this one urgently and I'm hoping Alex, Gervin, Dan, Heinz or some of our 
other MySQL/Base "Boffins" will be able to help me. As I said previously I posted this problem on 
the PCLOS Forum and one guy - "YouCanToo" - came back to me a few times but we were not able to 
crack it and he has no "disappeared"!!

This is what I did in setting up the system ...

_*INSTALL THE FOLLOWING*_-

*

   *MySQL*– Database. /(//now //Installs automatically)/

*

   *MyAdmin*- Database Manager. (*'**phpMyAdmin**'*through Synaptic)

*

   *MySQL **C**onnector.*- Download
   *'**mysql-connector-java-5.1.2**3.tar.gz**' *from the MySQL Download
   page,**un-tar it, then inLO go to Options -> Advanced. There you
   specify the directory into which you put the .jar-file of the
   connector in the 'Class Path' under 'Add Archives'.

*

   *mysqli Extension *download*'php-mysqli' *via Synaptic.

*_SET-UP STEPS_ ...*

*A **.*Check*my.cnf*file in /etc and comment out the line “skip networking” by putting a # at the 
front of it. Thisenables network (localhost) access.

*B. *Start*MyAdmin **- **(**For **F**irst-**T**ime **U**se**)*- STOP the MySQL Server in PCC and 
reset the MySQL root password. Enter the following lines in your terminal.

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-start MyAdmin in the PCC.

*
C. *Start*MyAdmin* as 'root' with your new password. ** *[_THIS IS WHEN I GET THE ERROR_**]*

Someone mentioned that there are other options to MyAdmin but do not know about these.

What are your suggestions for me to crack this one please.

Regards

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




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