Date: prev next · Thread: first prev next last
2013 Archives by date, by thread · List index

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

Pretoria RSA

For unsubscribe instructions e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: 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.