Can't Connect to BD after upgrading MAMP server from 4 to 5

Can you connect with a client like Sequel Pro, or whatever client you use. See also https://stackoverflow.com/questions/29395452/php-connection-failed-sqlstatehy000-2002-connection-refused

Since you are using a Mac I suggest you remove Mamp and use Valet instead.

https://laravel.com/docs/7.x/valet#introduction

That would be a good option but I was trying to fix current problem as my priority

You might want to verify your setup.

See what's running and its location:

ps -ef | grep mysqld

See what port it's on:

sudo lsof -Pnl +M -i | grep mysqld

@bryank thank you for your help, this command ps -ef | grep mysqld returned

501  8076     1   0  5:54PM ??         0:00.02 /bin/sh /Applications/MAMP/Library/bin/mysqld_safe --port=8889 --socket=/Applications/MAMP/tmp/mysql/mysql.sock --pid-file=/Applications/MAMP/tmp/mysql/mysql.pid --log-error=/Applications/MAMP/logs/mysql_error_log
  501  8188  8076   0  5:54PM ??         0:01.51 /Applications/MAMP/Library/bin/mysqld --basedir=/Applications/MAMP/Library --datadir=/Applications/MAMP/db/mysql57 --plugin-dir=/Applications/MAMP/Library/lib/plugin --log-error=/Applications/MAMP/logs/mysql_error_log.err --pid-file=/Applications/MAMP/tmp/mysql/mysql.pid --socket=/Applications/MAMP/tmp/mysql/mysql.sock --port=8889
  501  9709  9703   0 10:16PM ttys002    0:00.00 grep mysqld

and this sudo lsof -Pnl +M -i | grep mysqld returned

mysqld    8188      501   32u  IPv6 0xa441e6cdfc52abd1      0t0  TCP *:8889 (LISTEN)

dos these help ????

Did you look at the S.O. post, it talks about ports changed.

@jlrdw what do you mean by s.o. post ????

stackoverflow

I tried to change the port but still not getting connected

I had trouble once with a wamp setup, I ended up having to uninstall then reinstall. I've been pretty lucky ever since.

@nhayder

Change your port in the .env to 8889. For whatever reason, your config is not on the default port.

DB_PORT=8889

Yah tried that and still not connecting

DB_CONNECTION=mysql
DB_HOST=localhost
DB_PORT=8889
DB_DATABASE=mydb
DB_USERNAME=root
DB_PASSWORD=root

ok i found the fix for the problem but to tell you the truth its not a good way to solve this issue so im wondering if anybody can help me out in getting better solution for this issue.

according to this post https://stackoverflow.com/questions/46407490/laravel-no-such-file-or-directory-sql-create-table-migrations

i was able to fix the issue by adding this line of code to App/config/database.php

        'mysql' => [
            'driver' => 'mysql',
            'host' => env('DB_HOST', '127.0.0.1'),
            'port' => env('DB_PORT', '3306'),
            'database' => env('DB_DATABASE', 'forge'),
            'username' => env('DB_USERNAME', 'forge'),
            'password' => env('DB_PASSWORD', ''),
            // 'unix_socket' => env('DB_SOCKET', ''),
            'unix_socket' => env('DB_SOCKET', '/Applications/MAMP/tmp/mysql/mysql.sock'), <----- this is the line
            'charset' => 'utf8mb4',
            'collation' => 'utf8mb4_unicode_ci',
            'prefix' => '',
            'strict' => true,
            'engine' => null,
        ],

then i was able to connect to DB normally using these settings

DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=mydb
DB_USERNAME=root
DB_PASSWORD=root

can somebody explain how does that fix the problem and if there is a better fix

any ideas

Maybe read over the docs: https://documentation.mamp.info/en/MAMP-Mac/Preferences/Ports/

I'm thinking a port was still some how in use when up upgraded.

@jlrdw Yah nailed it this time thanks to you, I just changed the port on MAMP from 8889 to 3306 and this came back to normal.

Thanks man