The LOT software uses data from the TLDD database. The TLDD database must be accessible either locally or remotely in a MySQL database. Set the correct values for the MySQL user password and address at the top of the function tldd_connect() in the file lot/root/lib/tkl-header/handler.php
The admin interface to TLDD uses a separate username/password for MySQL access. Unlike the LOT portal, which treats TLDD as read-only, it must be able to modify the database. Edit the top of lot/admin/includes/tslac_db_connect.php and set db_username, db_password and db_name.
If you are hosting a local TLDD database rather than using a remote one, then dedicated read-only and read-write MySQL accounts can be created for the TLDD database as follows:
$ mysql -p --user=root mysql Enter password: ******** Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 17 to server version: 3.23.54 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> grant select on TLDD.* to lotuser@localhost identified by 'pass1'; Query OK, 0 rows affected (0.07 sec) mysql> grant all on TLDD.* to lotadmin@localhost identified by 'pass2'; Query OK, 0 rows affected (0.00 sec) mysql>