3.12. MySQL Configuration

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>