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