Hi Gavin and Heinz,
On 21/02/13 21:16, Girvin R. Herr wrote:
Ian,
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
any GRANTS!!
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
'home' partition!!!!
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
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
