Hi Gavin and Heinz,
On 21/02/13 21:16, Girvin R. Herr wrote:
Which version of MySQL are you using? *MySQL 5.1.55 PCLOS 2011*
Heinz asked about 'SHOW GRANTS'
Well I'm in a real hole here!!!
This morning I decided to go back to basics and re-installed all the
MySQL packages (in case)
I now have the situation that I can not CREATE USER so am unable to set
When I try I get the error message "ERROR 1396 (HY000): Operation CREATE
USER failed for 'ianw'@'localhost'"
BUT, MORE SERIOUS - I think I have fallen in a really big hole!! What I
did before I re-installed my OpSys was to back-up 'home' completely to
an external drive. Then when I re-installed I set it NOT to over-write
or use the 'home' partition and thus I maintained all my data on the
drive. (or so I thought!!)
BUT - Now digging around on Google I see that (I think) MySQL does not
keep its data in 'home' but rather in '/ver/lib'. There is such a folder
on my system but I can not get into it even as SU.
So is this correct?? Have I now lost my Database?? As I did not back-up
the root at all!!!!
If this is so I think it is very poor practice to store data outside the
Meanwhile phpMyAdmin will not work for me at all even after a re-install
- so as I said I'm in a real hole!!
IF I have lost the Database is there a way to make it save it in the
'home' directory in future??
Thanks for the help
For unsubscribe instructions e-mail to: email@example.com
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
- Re: [libreoffice-users] Re-Connecting LO Base to an SQL DB (continued)
Impressum (Legal Info)
: 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