CODEWITHSUNDEEP
phpmysqllaravelmampmamp-pro
user3732216
user3732216

Reputation: 1589

MAMP with Laravel Unix Socket

I'm working with MAMP on my local development server on my laravel application and I'm trying to figure out how I can safely setup my server so I don't have to use the following into the database connections mysql array because that should only be used when I'm on my development server. It works when I add the line into the mysql array however that isn't used if I was on a production server. Any ideas?

'unix_socket'   => '/Applications/MAMP/tmp/mysql/mysql.sock',

.env.development.php

<?php

return [
    'DB_HOST' => '127.0.0.1',
    'DB_USERNAME' => 'root',
    'DB_PASSWORD' => '1234',
    'DB_NAME' => 'mytable'
];

app/config/database.php

'connections' => array(

        'mysql' => array(
            'driver'    => 'mysql',
            'host'      => getenv('DB_HOST'),
            'database'  => getenv('DB_NAME'),
            'username'  => getenv('DB_USERNAME'),
            'password'  => getenv('DB_PASSWORD'),
            'charset'   => 'utf8',
            'collation' => 'utf8_unicode_ci',
            'prefix'    => '',
        ),

Upvotes: 9

Views: 20755

Answers (5)

Friendly Code
Friendly Code

Reputation: 1655

If none of the above solutions worked for you,

Try actually starting your webserver as this was the fix for me

Upvotes: 0

JackWalsh
JackWalsh

Reputation: 43

Make sure MAMP preference is set to Apache port: 80, Nginx Port: 80, MySQL Port: 3306

Here's what worked for me with Laravel 5.7:

go to config/database.php and find the line 54 below:

before: 'unix_socket' => env('DB_SOCKET', ''),

After: 'unix_socket' => env('DB_SOCKET', '/Applications/MAMP/tmp/mysql/mysql.sock'),

Save the file.

Then in terminal run: php artisan config:cache php artisan migrate

Upvotes: 1

S. M. Ibrahim Lavlu
S. M. Ibrahim Lavlu

Reputation: 387

There is even simple solution. add this to ur .env file

DB_HOST=localhost;unix_socket=/Applications/MAMP/tmp/mysql/mysql.sock

Upvotes: 16

Fausto Braz
Fausto Braz

Reputation: 184

On config/database.php:

'mysql' => [
            'driver' => 'mysql',
            'host' => env('DB_HOST'),
            'unix_socket' => env('UNIX_SOCKET'),
            'port' => env('DB_PORT'),
            'database' => env('DB_DATABASE'),
            'username' => env('DB_USERNAME'),
            'password' => env('DB_PASSWORD'),
            'charset' => 'utf8',
            'collation' => 'utf8_unicode_ci',
            'prefix' => '',
            'strict' => false,
            'engine' => null,
        ],

On .env:

DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=mytable
DB_USERNAME=root
DB_PASSWORD=1234
UNIX_SOCKET=/Applications/MAMP/tmp/mysql/mysql.sock

Upvotes: 6

Hkan
Hkan

Reputation: 3383

Check the environment detection part in the bootstrap/start.php. You should add your machine's name to the array that has local key. (If you don't know your machine's name, run hostname in terminal. If it's something stupid, Google how to change it. It's pretty simple.) Then copy and paste your database configurations to app/config/local/database.php. Create the file if it doesn't exists.

Upvotes: 5

Related Questions