[doveman2]

I understand now the IDENTIFIED BY in the CREATE USER command is what sets the password, so I have xbmc/xbmc but I can still only access the database if I use root/Mediaportal. In fact, the video database stopped working after trying xbmc/xbmc, even after changing it back to root/Mediaportal but it's working again now thankfully.

I needed to start again anyway as I'd originally done it using local paths E:\Media\Movies which mean nothing on the RPi and so it told me all my movies were no longer available, so now I'm scraping using my NFS path NFS://192.168.1.64/Media/Movies.