No tables in database

OS is Ubuntu 19-04
mysql Ver 8.0.17
Nginx 1.15.9
php7.2-fpm

I have just installed Nextcloud mostly following the directions here
I can see no tables in the nextcloud database.
I had this problem with Wordpress. It turned out that PHP when using mysqlnd is incompatible with MySQL 8 unless you have

default_authentication_plugin = mysql_native_password

in your my.cnf file which I have also put in my mysql.cnf file for good measure but to no avail.

The contents of /var/www/nextcloud/config/config.php is

<?php
$CONFIG = array (
  'instanceid' => 'ocqpxfbvdofy',
);

If anyone has any clues or troubleshooting tips that would be much appreciated.

what happened in step 8? https://www.howtoforge.com/tutorial/ubuntu-nginx-nextcloud/#step-nextcloud-postinstallation

i guess you got a database connection error.

it should be save to remove the config.php and repeat step 8. or use the silent install method via occ.

if my playbook fails during dev&test i just remove config.php, the database and the nextcloud data folder and rerun it. :wink: