How can i use symfony 3 with mariadb and doctrine?

Question

How can i use symfony 3 with mariadb?

But i want to use doctrine also but i did not see any useful information on http://docs.doctrine-project.org/projects/doctrine-dbal/en/latest/reference/configuration.html#sqlanywhere

So please guide or provide proper article link thanks.

Answer 1

The mysql-client package also works with MariaDB server. You can see the Version Details here. https://mariadb.com/kb/en/the-mariadb-library/mariadb-vs-mysql-compatibility/

Answer 2

In my case it was the port change, 3307, check the port in MariaDB:

parameters:
    database_host: 127.0.0.1
    database_port: 3307
    database_name: test # your database name
    database_user: root # mysql username
    database_password: test123 # mysql password

Answer 3

If you get doctrine:schema:update to show the same migrations again and again, consider adding this to your config:

doctrine:
    dbal:
        server_version: 'mariadb-X.X.X'

Replacing X.X.X with the real version of mariadb installed on the executing machine.

Answer 4

HI its similar to mysql configuration

parameters.yml

parameters:
    database_host: 127.0.0.1
    database_port: null
    database_name: test # your database name
    database_user: root # mysql username
    database_password: test123 # mysql password

In your config.yml

doctrine:
    dbal:
        driver: pdo_mysql
        host: '%database_host%'
        port: '%database_port%'
        dbname: '%database_name%'
        user: '%database_user%'
        password: '%database_password%'
        charset: UTF8