Cannot connect to database with docker and pdo_mysql in laravel

Module 'pdo_mysql' already loaded in Unknown on line 0 - that error comes for docker container just informing you that pdo is already loaded before uncomented pdo in php.ini though that should not hinder your ability to connect

Can you use some GUI client to connect to Mysql (i.e. HeidiSQL on Win) fire it up and try to connect to loclhost:3306 or127.0.0.1:3306 and see if you are successful ?

Hi hajrovica Yes, of course i can connect with Seque Pro, mysql docker container is working properly. Also accesing it from the command line works.

ok ... then there should not be an issue when connecting with app though if i understood correctly you are getting error: SQLSTATE[HY000] [2002] Connection refused

cross reference your login data from sequelpro and .env file ?

Already checked..., many times. Something to point out, i have full access to the database from outside the container, i can migrate, create users from the tinker, the problem is from inside the container. Dus the problem is how the docker system is built (i guess).

yes can you check mysql users or even better create new user with full privileges and try that one ? maybe mysql users got messed - bcs there is no logic that with root you have full access outside of container but not inside,

and also in docker case i think this (using sequel pro to connect) does not count as outside connection

I don't know if i unsertand you correctly, but this is what is happening outside and inside:

Outside:

➜  backoffice git:(master) ✗ php artisan tinker
Psy Shell v0.9.9 (PHP 7.2.15 — cli) by Justin Hileman
>>> $ur = app(MDiPaolo\Repositories\UserRepository::class)
=> App\Infrastructure\Repositories\Doctrine\UserDoctrineRepository {#3159}
>>> $u = new MDiPaolo\Entities\User
=> MDiPaolo\Entities\User {#3295}
>>> $u->setEmail('[email protected]')
=> MDiPaolo\Entities\User {#3295}
>>> $u->setPassword(password_hash('1234', PASSWORD_BCRYPT))
=> null
>>> $ur->save($u)
=> null
>>>

Inside:

➜  backoffice git:(master) ✗ docker exec -it backoffice_web_1 bash
root@042969f0229c:/var/www/html# php artisan tinker
Psy Shell v0.9.9 (PHP 7.2.17 — cli) by Justin Hileman
>>> $ur = app(MDiPaolo\Repositories\UserRepository::class)
Doctrine/DBAL/Exception/ConnectionException with message 'An exception occurred in driver: SQLSTATE[HY000] [2002] Connection refused'

OMG! that did it!!! Thanks a lot!, but ofc now i cannot access from the outside, is there a way of being able to access the DB from both environments?

Edit: found it! adding

127.0.0.1   mysql

to hosts file!!, thanks a lot!!

hmm not directly - there is a way to go around by making custom command in your site

containing something like

COMPOSE="docker-compose -f docker-compose.$COMPOSE_FILE.yml"

if [ $# -gt 0 ];then

    if [ "" == "art" ];then
      shift 1
      $COMPOSE run --rm $TTY \
        -w /var/www/html \
        app \
        php artisan "$@"

this is extensively explained in shipping docker course but a gist is that you do docker compose run command by calling ./develop art route:list command will see that first arg is art then strip it and run php artisan with rroute:list (though in my example i am using image called app for you it would be web) I hope this kinda rushed info makes sense ?

@MARCOSDIPAOLO - i thought you are asking for running artisan commands from terminal :)

@hajrovica not necessarily, but your input was crutial, thanks a lot.