Nick, starting the site in Local, opening a browser without logging in, logging in as Admin (and getting the “not allowed access” message); none of that generates a log entry where Local tries to log into MariaDB as ‘root’. I thought it might be Adminer access, as that may require root access, but that works fine too. These are all of lines generated in the Local log (from startup of the site):
{"thread":"main","class":"Process","process":"mariadb","level":"warn","message":"2023-03-02 7:56:50 0 [Note] %%resourcesPath%%\\lightning-services\\mariadb-10.4.10+4\\bin\\win32\\bin\\mysqld.exe (mysqld 10.4.10-MariaDB) starting as process 6216 ...","timestamp":"2023-03-02T12:56:50.965Z"}
{"thread":"main","class":"Process","process":"mariadb","level":"warn","message":"InnoDB: using atomic writes.","timestamp":"2023-03-02T12:56:50.978Z"}
{"thread":"main","class":"Process","process":"mariadb","level":"warn","message":"2023-03-02 7:56:50 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions","timestamp":"2023-03-02T12:56:50.979Z"}
{"thread":"main","class":"Process","process":"mariadb","level":"warn","message":"2023-03-02 7:56:50 0 [Note] InnoDB: Uses event mutexes","timestamp":"2023-03-02T12:56:50.980Z"}
{"thread":"main","class":"Process","process":"mariadb","level":"warn","message":"2023-03-02 7:56:50 0 [Note] InnoDB: Compressed tables use zlib 1.2.11","timestamp":"2023-03-02T12:56:50.980Z"}
{"thread":"main","class":"Process","process":"mariadb","level":"warn","message":"2023-03-02 7:56:50 0 [Note] InnoDB: Number of pools: 1","timestamp":"2023-03-02T12:56:50.980Z"}
{"thread":"main","class":"Process","process":"mariadb","level":"warn","message":"2023-03-02 7:56:50 0 [Note] InnoDB: Using SSE2 crc32 instructions","timestamp":"2023-03-02T12:56:50.980Z"}
{"thread":"main","class":"Process","process":"mariadb","level":"warn","message":"2023-03-02 7:56:50 0 [Note] InnoDB: Initializing buffer pool, total size = 32M, instances = 1, chunk size = 32M","timestamp":"2023-03-02T12:56:50.981Z"}
{"thread":"main","class":"Process","process":"mariadb","level":"warn","message":"2023-03-02 7:56:50 0 [Note] InnoDB: Completed initialization of buffer pool","timestamp":"2023-03-02T12:56:50.982Z"}
{"thread":"main","class":"Process","process":"mariadb","level":"warn","message":"2023-03-02 7:56:50 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=667921723","timestamp":"2023-03-02T12:56:50.994Z"}
{"thread":"main","class":"Process","process":"mariadb","level":"warn","message":"2023-03-02 7:56:51 0 [Note] InnoDB: 128 out of 128 rollback segments are active.","timestamp":"2023-03-02T12:56:51.169Z"}
{"thread":"main","class":"Process","process":"mariadb","level":"warn","message":"2023-03-02 7:56:51 0 [Note] InnoDB: Removed temporary tablespace data file: \"ibtmp1\"","timestamp":"2023-03-02T12:56:51.170Z"}
{"thread":"main","class":"Process","process":"mariadb","level":"warn","message":"2023-03-02 7:56:51 0 [Note] InnoDB: Creating shared tablespace for temporary tables","timestamp":"2023-03-02T12:56:51.170Z"}
{"thread":"main","class":"Process","process":"mariadb","level":"warn","message":"2023-03-02 7:56:51 0 [Note] InnoDB: Setting file '.\\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...","timestamp":"2023-03-02T12:56:51.170Z"}
{"thread":"main","class":"Process","process":"mariadb","level":"warn","message":"2023-03-02 7:56:51 0 [Note] InnoDB: File '.\\ibtmp1' size is now 12 MB.","timestamp":"2023-03-02T12:56:51.170Z"}
{"thread":"main","class":"Process","process":"mariadb","level":"warn","message":"2023-03-02 7:56:51 0 [Note] InnoDB: 10.4.10 started; log sequence number 667921732; transaction id 68443","timestamp":"2023-03-02T12:56:51.171Z"}
{"thread":"main","class":"Process","process":"mariadb","level":"warn","message":"2023-03-02 7:56:51 0 [Note] InnoDB: Loading buffer pool(s) from %%userDataPath%%\\run\\GlrSXudap\\mariadb\\data\\ib_buffer_pool","timestamp":"2023-03-02T12:56:51.172Z"}
{"thread":"main","class":"Process","process":"mariadb","level":"warn","message":"2023-03-02 7:56:51 0 [Note] Plugin 'FEEDBACK' is disabled.","timestamp":"2023-03-02T12:56:51.172Z"}
{"thread":"main","class":"Process","process":"mariadb","level":"warn","message":"2023-03-02 7:56:51 0 [Note] Server socket created on IP: '127.0.0.1'.","timestamp":"2023-03-02T12:56:51.177Z"}
{"thread":"main","class":"Process","process":"mariadb","level":"warn","message":"2023-03-02 7:56:51 0 [Note] InnoDB: Buffer pool(s) load completed at 230302 7:56:51","timestamp":"2023-03-02T12:56:51.185Z"}
{"thread":"main","class":"Process","process":"mariadb","level":"warn","message":"2023-03-02 7:56:51 0 [Note] Reading of all Master_info entries succeeded","timestamp":"2023-03-02T12:56:51.200Z"}
{"thread":"main","class":"Process","process":"mariadb","level":"warn","message":"2023-03-02 7:56:51 0 [Note] Added new Master_info '' to hash table","timestamp":"2023-03-02T12:56:51.200Z"}
{"thread":"main","class":"Process","process":"mariadb","level":"warn","message":"2023-03-02 7:56:51 0 [Note] %%resourcesPath%%\\lightning-services\\mariadb-10.4.10+4\\bin\\win32\\bin\\mysqld.exe: ready for connections.","timestamp":"2023-03-02T12:56:51.201Z"}
{"thread":"main","class":"Process","process":"mariadb","level":"warn","message":"Version: '10.4.10-MariaDB' socket: '' port: 10005 mariadb.org binary distribution","timestamp":"2023-03-02T12:56:51.201Z"}
Not a whole lot there, and all looking good.
Continuing the search…
-Rob-