NextCloud 10 Stable...Failed To Connect To Database

[Jstear]

What does Show Grants; show?

[Alex Sage]

Any firewall?

[Jstear]

Also, did you ever run "flush privileges;" ?

[alex.olynyk]

@Jstear
But...when I run
create user 'nextclouduser'@'localhost' identified by 'nextcloudpassword';
grant all on nextcloud_db.* to 'nextclouduser'@'localhost';
flush privileges;
quit
I get Query OK for all commands run. I reboot and SHOW GRANTS; and I get the same output

[alex.olynyk]

@aaronstuder

[Jstear]

Alright, so your nextclouduser doesn't have permissions to write to the database.

[Jstear]

Login using mysql -u nxtuser -p and run show grants;

[Jstear]

Try changing this:

grant all on nextcloud_db.* to 'nextclouduser'@'localhost';

To:

GRANT ALL PRIVILEGES ON nextcloud_db.* TO 'nxtuser@'localhost' IDENTIFIED BY 'nextcloudpassword' WITH GRANT OPTION;

[alex.olynyk]

@Jstear That worked when I added WITH GRANT OPTION. Thank you. Ill add this to my notes.

[Jstear]

Awesome, glad I could help!