Laravel 5 database config with unix_socket for MAMP
database.php
| <?php |
| return [ |
| /* |
| |-------------------------------------------------------------------------- |
| | PDO Fetch Style |
| |-------------------------------------------------------------------------- |
| | |
| | By default, database results will be returned as instances of the PHP |
| | stdClass object; however, you may desire to retrieve records in an |
| | array format for simplicity. Here you can tweak the fetch style. |
| | |
| */ |
| 'fetch' => PDO::FETCH_CLASS, |
| /* |
| |-------------------------------------------------------------------------- |
| | Default Database Connection Name |
| |-------------------------------------------------------------------------- |
| | |
| | Here you may specify which of the database connections below you wish |
| | to use as your default connection for all database work. Of course |
| | you may use many connections at once using the Database library. |
| | |
| */ |
| 'default' => env('DB_CONNECTION', 'mysql'), |
| /* |
| |-------------------------------------------------------------------------- |
| | Database Connections |
| |-------------------------------------------------------------------------- |
| | |
| | Here are each of the database connections setup for your application. |
| | Of course, examples of configuring each database platform that is |
| | supported by Laravel is shown below to make development simple. |
| | |
| | |
| | All database work in Laravel is done through the PHP PDO facilities |
| | so make sure you have the driver for your particular database of |
| | choice installed on your machine before you begin development. |
| | |
| */ |
| 'connections' => [ |
| 'sqlite' => [ |
| 'driver' => 'sqlite', |
| 'database' => database_path('database.sqlite'), |
| 'prefix' => ', |
| ], |
| 'mysql' => [ |
| 'driver' => 'mysql', |
| 'host' => env('DB_HOST', 'localhost'), |
| 'database' => env('DB_DATABASE', 'forge'), |
| 'username' => env('DB_USERNAME', 'forge'), |
| 'password' => env('DB_PASSWORD', '), |
| 'charset' => 'utf8', |
| 'collation' => 'utf8_unicode_ci', |
| 'prefix' => ', |
| 'strict' => false, |
| 'unix_socket' => '/Applications/MAMP/tmp/mysql/mysql.sock', |
| ], |
| 'pgsql' => [ |
| 'driver' => 'pgsql', |
| 'host' => env('DB_HOST', 'localhost'), |
| 'database' => env('DB_DATABASE', 'forge'), |
| 'username' => env('DB_USERNAME', 'forge'), |
| 'password' => env('DB_PASSWORD', '), |
| 'charset' => 'utf8', |
| 'prefix' => ', |
| 'schema' => 'public', |
| ], |
| 'sqlsrv' => [ |
| 'driver' => 'sqlsrv', |
| 'host' => env('DB_HOST', 'localhost'), |
| 'database' => env('DB_DATABASE', 'forge'), |
| 'username' => env('DB_USERNAME', 'forge'), |
| 'password' => env('DB_PASSWORD', '), |
| 'charset' => 'utf8', |
| 'prefix' => ', |
| ], |
| ], |
| /* |
| |-------------------------------------------------------------------------- |
| | Migration Repository Table |
| |-------------------------------------------------------------------------- |
| | |
| | This table keeps track of all the migrations that have already run for |
| | your application. Using this information, we can determine which of |
| | the migrations on disk haven't actually been run in the database. |
| | |
| */ |
| 'migrations' => 'migrations', |
| /* |
| |-------------------------------------------------------------------------- |
| | Redis Databases |
| |-------------------------------------------------------------------------- |
| | |
| | Redis is an open source, fast, and advanced key-value store that also |
| | provides a richer set of commands than a typical key-value systems |
| | such as APC or Memcached. Laravel makes it easy to dig right in. |
| | |
| */ |
| 'redis' => [ |
| 'cluster' => false, |
| 'default' => [ |
| 'host' => '127.0.0.1', |
| 'port' => 6379, |
| 'database' => 0, |
| ], |
| ], |
| ]; |
Pidfile / Applications / MAMP / redis / redis.pid # Accept connections on the specified port, default is 6379. # If port 0 is specified Redis will not listen on a TCP socket. MAMP is a free, local server environment that can be installed under macOS and Windows with just a few clicks. MAMP provides them with all the tools they need to run WordPress on their desktop PC for testing or development purposes, for example. You can even easily test your projects on mobile devices.
Sign up for freeto join this conversation on GitHub. Already have an account? Sign in to comment
Map Registration
- Your MAMP PRO MySQL database data is located in /Library/Application Support/appsolute/MAMP PRO/db/mysql57. MAMP PRO MySQL Data. Include MySQL server in GroupStart Activate this checkbox if you want the MySQL database server to start and stop automatically when the Start/Stop button in the toolbar is clicked.
- MAMP (Mac OS, Apache, MySQL, PHP) WISA (Windows, IIS, SQL, ASP.NET) BAMP (BSD, Apache, MySQL, PHP) XAMPP (distribution that contains MariaDB, PHP, and Perl) SAMP (Solaris, Apache, MySQL, PHP) RoR (Ruby on Rails) Ruby on Rails is a web framework written over Ruby – a dynamic programming language with an elegant syntax. With Ruby on Rails, you.
- The next things was to install Redis locally. Here is how I installed Redis locally + MAMP On the server, my hosting provider activated Redis and just gave me the redis.server/port and password. Once you have installed Redis, the website will fly like never before.