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


Ian,
You give the versions for LO and MySQL-connector-java, but I don't see which version of MySQL itself you are using. MySQL made some configurations changes in the name of security between 5.1 and 5.5, especially with how localhost is handled. I participated in such a thread a while back. The mysql configuration file changes differ between the versions. Make sure you are using the proper configuration for localhost based on the MySQL version.
Hope this helps.
Girvin Herr


Ian Whitfield wrote:
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

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.