Configuring FLOW3 alpha7 to use MySQL
Looking around the internet, I could find no real documentation on switching FLOW3 to use mysql except for one mailing list thread asking for help with a faulty config for alpha6. So, for those of you who are wondering, these are the steps you'll need to follow to configure FLOW3 to use MySQL instead of SQLite, at least in alpha7. Note, as this is an alpha release, it can of course change.
- Create a database in mysql.
- Run all the create statements inside of
/Packages/Framework/FLOW3/Resources/Private/Persistence/SQL/DDL.sql
. You'll probably have to add back tick marks (`) to SQL keywords to avoid syntax errors. - Configure FLOW3 to use MySQL by editing the
/Configuration/Settings.yaml
file. These settings will override the default settings specified in/Packages/Framework/FLOW3/Configuration/Settings.yaml
. Note that you may need to create this file yourself:
FLOW3: persistence: # Options for the default PDO backend backendOptions: dataSourceName: 'mysql:host=localhost;dbname=yourdbname' username: root password: yoursqlpassword
And voila, FLOW3 now uses MySQL! Swappable persistence layers FTW.