sorry, I had not finished reading the thread.
I had read up to here:
robert@roberts-work-laptop:~$ mysql
ERROR 1045 (28000): Access denied for user ‘robert’@‘localhost’ (using password: NO)
Openemr does not yet work with Mysql 8. You can ready my threads from the few recent weeks. Let me find them for you If you want to trouble shoot the problem and get it to work:
If you look toward the more recent exchanges you will see some instructions. You need to use mysql_native_password instead of caching_sha2_password plugin for the server.
Secondly, when installing mysql8, the root password is automatically created using the latter. You would need to make a new root user and grant privileges separately using the former.
But there are other problems. I just went back and installed the mysql 5.7 server