Oh, wait. mysql_install_db is located at /usr/share/mysql/scripts/mysql_install_db - on to the next step.
Hmm, having found where mysql_install_db is, now digiKam doesn’t want to put the database where I asked it to. In fact it gave a complaint, I forget the verbiage, and then promptly lost track of where mysql_install_db is located. So I officially give up. Sigh.
OK, trying again, the error message when I hit the “Migrate” button is “Error while opening the target database” - well, this makes sense as there currently isn’t any mariadb database.
Am I supposed to create the mariadb database in the first place? If so, how do I do this? I assumed digiKam would find the current sqlite database which is in /home/elle/Pictures, make a new mariadb database, and migrate the data from the sqlite database to the mariadb database.
Here’s the relevant digiKam terminal output:
digikam.general: All Binaries Found : true
digikam.dbengine: ConnectOptions "UNIX_SOCKET=/home/elle/.local/share/digikam/db_misc/mysql.socket"
digikam.dbengine: Error while opening the database. Error was QSqlError("2002", "QMYSQL: Unable to connect", "Can't connect to local MySQL server through socket '/home/elle/.local/share/digikam/db_misc/mysql.socket' (2 \"No such file or directory\")")
QXcbConnection: XCB error: 3 (BadWindow), sequence: 4930, resource id: 15293461, major code: 40 (TranslateCoords), minor code: 0
digikam.dbengine: ConnectOptions "UNIX_SOCKET=/home/elle/.local/share/digikam/db_misc/mysql.socket"
QSqlDatabasePrivate::addDatabase: duplicate connection name 'MigrationToDatabase81660432', old connection removed.
digikam.dbengine: Error while opening the database. Error was QSqlError("2002", "QMYSQL: Unable to connect", "Can't connect to local MySQL server through socket '/home/elle/.local/share/digikam/db_misc/mysql.socket' (2 \"No such file or directory\")")
Based on the terminal output, I’m guessing the only way forward is to start mysql outside of digiKam, change the default password, and make a new database, and change “localhost”, as per the information on this page: MySQL/Startup Guide - Gentoo Wiki
I was hoping that digiKam would do all this stuff automagically . . .