Re: [libreoffice-users] Re: Re-Connecting LO Base to an SQL DB

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: 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