Installation on Ubuntu x64 with MySQL

[n4zroth]

Hi,
I had Alfresco-5.0.d installed and running with its own PostgreSQL installation but I'd rather have (kinda need) to run it on MySQL. I tried changing the configuration and migrating the data from PostgreSQL to MySQL (meh) but that didn't work out correctly. As the system had nearly no data in it, I decided to simply reinstall it.
After about two hours I still don't have it working with MySQL:
I enter the correct values in the advanced installation wizard (do I have to put "com.mysql.jdbc.Driver" or "org.gjt.mm.mysql.Driver" {they both don't work for me]), but the database I created never gets populated with any data or even table structure. I've tried putting the MySQL connector in /usr/share/java, /usr/share/tomcat8/lib and /usr/lib/jvm/java-8-oracle/lib, nothing seems to work.
What am I doing wrong?
Thanks.

[mrogers]

Here are the settings from alfresco global properties.

db.driver=org.gjt.mm.mysql.Driver
db.url=jdbc:mysql://${db.host}:${db.port}/${db.name}
hibernate.dialect=org.hibernate.dialect.MySQLInnoDBDialect

Also remember to create an empty db for alfresco to use.
create database alfresco DEFAULT CHARACTER SET utf8;
grant all on alfresco.* to 'alfresco'@'localhost' identified by 'alfresco' with grant option;
grant all on alfresco.* to 'alfresco'@'localhost.localdomain' identified by 'alfresco' with grant option;

[mrogers]

Also put your driver in the tomcat lib folder.


And please if that still does not work then give error details from your alfresco.log file.