I did an install onto a Windows 10 machine.
I created the default user in MySQL, but it defaulted to a "SHA256" auth type, rather than a simple/standard user type. This, I think stopped the creation of the proper tables in MySQL.
So, i deleted the entire Tomcat installation, changed the user auth type in MySQL to Standard (user/pw), and reinstalled OpenKM. I expected the tables to be created, but that didn't happen.
I did try connecting to the MySQL db using the user/pw i created for OpenKM, and i was able to connect and create tables etc. with no problems.
I created the default user in MySQL, but it defaulted to a "SHA256" auth type, rather than a simple/standard user type. This, I think stopped the creation of the proper tables in MySQL.
So, i deleted the entire Tomcat installation, changed the user auth type in MySQL to Standard (user/pw), and reinstalled OpenKM. I expected the tables to be created, but that didn't happen.
I did try connecting to the MySQL db using the user/pw i created for OpenKM, and i was able to connect and create tables etc. with no problems.
- Any ideas out there on what I'm doing wrong?
- Can i run the table creation and data loading scripts seperately from the command line?