I'm trying to connect with my DB (mysql) which is running on a server (docker). I'm programming on Windows.
In my symfony project I have done the following: parameters.yml
-> filled in the correct parameters
config.yml
doctrine:
dbal:
driver: pdo_mysql
host: '%database_host%'
port: '%database_port%'
dbname: '%database_name%'
user: '%database_user%'
password: '%database_password%'
php.ini
extension=php_mysqli.dll
extension=php_pdo_mysql.dll
extension=php_pdo_sqlite.dll
After all of this I get the following error: An exception occured in driver: could not find driver
Anyone who can help since I have tried some solutions that were provided but none worked or were for linux systems.
You must install mysql :
sudo apt install php-mysql
Ok, I made a very stupid mistake. I was editing the php.ini file, but I didn't renamed it to php.ini (it was php.ini-prod). Afterwards I just had to put the correct path in extension_dir and it's working.
Hopefully this helps others.
comment this line in your .env file. yourproject/.env
#DATABASE_URL="postgresql://db_user:db_password@127.0.0.1:5432/db_name?serverVersion=13&charset=utf8"file
and delete # in first of your mysql config code
set your username and password in this part
DATABASE_URL="mysql://usename:password@127.0.0.1:3306/test?serverVersion=5.7"