Error: failed to initialize Greyhole database

[PeterBlanchard1966]

I'm trying to use webclient to setup Greyhole but I'm getting -

Error: failed to initialize Greyhole database: SQLSTATE[28000]: Invalid authorization specification: 1133 Can't find any matching row in the user table; Query: GRANT ALL ON greyhole.* TO :username@:client_host

MariaDB set up not to use password for root.

I'm very new to using Linux. I could have easily screwed something up.

[gboudreau]

Did you just retry?
That error is about the user not existing, which is weird, since it was created 2 lines before executing this query...

If retrying doesn't work, try to connect to MariaDB manually, and run:

flush privileges;
use greyhole;
SELECT * FROM mysql.user WHERE USER = 'greyhole_user';
SELECT `Host` FROM mysql.user WHERE USER = 'greyhole_user';
-- Replace host_here below with the host obtained in the previous query
GRANT ALL ON greyhole.* TO greyhole_user@'host_here';

[PeterBlanchard1966]

No records returned.

I tried creating users in MariaDB and it gave errors. I think there is something wrong with it. I am not going to try to fix it directly.

I installed OpenMediaVault and decided I don't like or need it. There is no data on the NAS yet. I am going to wipe it, do fresh install of Ubuntu server.