[Koha] (no subject)

[Hector Gonzalez]

> On Jun 5, 2019, at 11:02 PM, Charles Kelley <cmkelleymls at gmail.com> wrote:
> 
> $ sudo koha-remove mylibrary
> 
>    The report was
> 
> ERROR 1133 (28000) at line 1: Can’t find any matching row in the user table
> 
>    Any other suggestions?
> 
I recently had to do this again for an upgrade, and found this exact error.  It means the mysql user koha_mylibrary exists, but does not have a password assigned, so it can´t be found and erased properly.

you can add a password (it doesn´t matter which you use, it will be removed with koha-remove mylibrary), from mysql, with: 

grant all on koha_mylibrary.* to koha_mylibrary at localhost identified with 'thispasswordwillberemovedbykoha-remove';

then koha-remove should be able to work.


>    Hope all are well and all is well.
> 
>    — Charles.
> 
>    Charles Kelley
>    PSC 704 Box 1029
>    APO AP 96338
> 
>    011-81-80-4714-5490 [JPN cell]
> 
>    mnogojazyk at aol.com <mailto:mnogojazyk at aol.com>
>    cmkelleymls at gmail.com <mailto:cmkelleymls at gmail.com>
> 
>    www.linkedin.com/in/cmkelleymls <http://www.linkedin.com/in/cmkelleymls>
>    Meeting Your Information Needs. Virtually.

--
Héctor González
cacho at genac.org