s5my5

Testing a Symfony 5.4 mySql 5.7 setup

config/packages/doctrine.yaml

doctrine:
    dbal:
        charset: utf8mb4
        default_table_options:
            charset:    utf8mb4
            collate:    utf8mb4_unicode_ci
            engine:     InnoDB

my.cnf

collation-server     = utf8mb4_unicode_ci # Replaces utf8_unicode_ci
character-set-server = utf8mb4            # Replaces utf8

Requirements

• PHP 7.4 or higher;
• PDO-MySql-5.7;
• and the usual Symfony application requirements.

Resources

• Symfony Documentations.
• Symfony Best Practices.
• SymfonyCasts.

Useful

composer install

database

php bin/console doctrine:database:drop --force
php bin/console doctrine:database:create

migrations

php bin/console doctrine:migrations:status
php bin/console doctrine:migrations:list

php bin/console doctrine:migrations:version --delete --all

php bin/console make:migration
php bin/console doctrine:migrations:migrate

fixtures

php bin/console doctrine:fixtures:load