1
ThumbsPlus v10 Questions / Re: Thumbs 10 Pro - MySQL
« on: 2019-05-23 12:08:32 »
Thank you Daan! That helped get it working, using the sql script on the TP website:
http://www.thumbsplus.com/binaries/database/new/Thumbs9_mysql.sql
The one from the zip file you posted didn't work. ThumbsPlus gave an error about it not being a ThumbsPlus database.
This is what I did.
Log into MariaDB terminal
Set the mode
Load the script
Grant permission to a user to use the database
Then set up an ODBC connection to the ip address of the machine using the above user/pass.
Seems to be working! Thanks for taking the time to post.
http://www.thumbsplus.com/binaries/database/new/Thumbs9_mysql.sql
The one from the zip file you posted didn't work. ThumbsPlus gave an error about it not being a ThumbsPlus database.
This is what I did.
Log into MariaDB terminal
Code: [Select]
$ mysql -u root -p
Set the mode
Code: [Select]
MariaDB [(none)]> SET sql_mode='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION,ANSI_QUOTES';
Load the script
Code: [Select]
MariaDB [(none)]> source /path/to/Thumbs9_mysql.sql
Grant permission to a user to use the database
Code: [Select]
MariaDB [(none)]> grant all privileges on ThumbsPlus.* to user@'%' identified by 'password';
Then set up an ODBC connection to the ip address of the machine using the above user/pass.
Seems to be working! Thanks for taking the time to post.