Laravel\u304b\u3089mysql\u306b\u30a2\u30af\u30bb\u30b9\u3067\u304d\u308b\u3068\u3053\u308d\u307e\u3067\u3084\u308a\u307e\u3057\u305f\u3002<\/p>\n\n\n\n
$ sudo apt-get install mysql-server<\/pre>\n\n\n\nmysql\u306e\u521d\u671f\u8a2d\u5b9a<\/h2>\n\n\n\n
$ sudo mysql_secure_installation<\/pre>\n\n\n\n\u57fa\u672c\u7684\u306by\u3092\u9078\u629e\u3059\u308c\u3070\u826f\u3044\u3002<\/p>\n\n\n\n
root\u3067\u30ed\u30b0\u30a4\u30f3<\/h2>\n\n\n\n
$ sudo mysql -u root -p<\/pre>\n\n\n\n\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u4f5c\u6210<\/h2>\n\n\n\n
mysql> create database <\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u540d>;<\/pre>\n\n\n\n\u30e6\u30fc\u30b6\u30fc\u306e\u8ffd\u52a0<\/h2>\n\n\n\n
mysql> create user <\u30e6\u30fc\u30b6\u30fc\u540d> identified by '<\u30d1\u30b9\u30ef\u30fc\u30c9>';<\/pre>\n\n\n\n\u30e6\u30fc\u30b6\u30fc\u306b\u6a29\u9650\u3092\u4ed8\u4e0e<\/h2>\n\n\n\n
mysql> grant all on .<\/em> to <\u30e6\u30fc\u30b6\u30fc\u540d>;<\/pre>\n\n\n\nLaravel\u306b\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u8a2d\u5b9a\u3092\u8a18\u5165<\/h2>\n\n\n\n
database.php\u306e\u8a2d\u5b9a\u3092\u5909\u66f4\u3002<\/p>\n\n\n\n
'mysql' => [\n 'driver' => 'mysql',\n 'host' => env('DB_HOST', '127.0.0.1'),\n 'port' => env('DB_PORT', '3306'),\n 'database' => env('DB_DATABASE', '<\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u540d>'),\n 'username' => env('DB_USERNAME', '<\u30e6\u30fc\u30b6\u30fc\u540d>'),\n 'password' => env('DB_PASSWORD', '<\u30d1\u30b9\u30ef\u30fc\u30c9>'),\n 'unix_socket' => env('DB_SOCKET', ''),\n 'charset' => 'utf8mb4',\n 'collation' => 'utf8mb4_unicode_ci',\n 'prefix' => '',\n 'strict' => true,\n 'engine' => null,\n ],<\/pre>\n\n\n\nmigrate\u306e\u5b9f\u884c<\/h2>\n\n\n\n
$ php artisan migrate<\/pre>\n\n\n\n\u30a8\u30e9\u30fc\u304c\u51fa\u305f\u3002<\/strong><\/p>\n\n\n\n
could not find driver<\/pre>\n\n\n\nPHP\u306b\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u30a2\u30af\u30bb\u30b9\u3059\u308bPDO\u304c\u306a\u3044\u3001\u3068\u3044\u3046\u3053\u3068\u306a\u306e\u3067\u3001mysql\u306b\u30a2\u30af\u30bb\u30b9\u3059\u308b\u30e2\u30b8\u30e5\u30fc\u30eb\u3092\u8ffd\u52a0\u3002<\/p>\n\n\n\n
$ sudo apt-get install php7.2-mysql<\/pre>\n\n\n\n\u3053\u308c\u3067migrate\u304c\u6210\u529f\u3059\u308c\u3070OK\u3002<\/p>\n\n\n\n
\u9069\u5f53\u306a\u30c6\u30fc\u30d6\u30eb\u3092\u8ffd\u52a0\u3059\u308b<\/h2>\n\n\n\n
$ php artisan make:migration create_test_table<\/pre>\n\n\n\nCreateTestTable\u30af\u30e9\u30b9\u304c\u51fa\u6765\u4e0a\u304c\u308b\u306e\u3067\u3001\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u66f8\u304d\u63db\u3048\u308b\u3002<\/p>\n\n\n\n
public function up()\n {\n Schema::create('test', function (Blueprint $table) {\n $table->increments('id');\n $table->text('text');\n $table->timestamps();\n });\n }<\/pre>\n\n\n\n$ php artisan migrate<\/pre>\n\n\n\nLaravel\u304b\u3089\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u30a2\u30af\u30bb\u30b9<\/h2>\n\n\n\n
$ php artisan tinker<\/pre>\n\n\n\n>>> DB::table('test')->get();\nDB::table('test')->insert(['test' => 'insert'])\nDB::table('test')->get();<\/pre>\n\n\n\n\u30c7\u30fc\u30bf\u304c\u8868\u793a\u3055\u308c\u308c\u308c\u3070OK\u3002<\/p>\n\n\n\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
Laravel\u304b\u3089mysql\u306b\u30a2\u30af\u30bb\u30b9\u3067\u304d\u308b\u3068\u3053\u308d\u307e\u3067\u3084\u308a\u307e\u3057\u305f\u3002 mysql\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb $ sudo apt-get install mysql-server mysql\u306e\u521d\u671f\u8a2d\u5b9a $ sudo mysql_sec … \u7d9a\u304d\u3092\u8aad\u3080 \u3010Linux\u3011\u3010Laravel\u3011Laravel\u304b\u3089\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u30a2\u30af\u30bb\u30b9\u3059\u308b\u3002<\/span>