Re: [libreoffice-users] Problem with MySQL after upgrading OpSys

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