{"id":1652,"date":"2019-11-14T10:06:27","date_gmt":"2019-11-14T01:06:27","guid":{"rendered":"http:\/\/taki-lab.site\/bocci\/?p=1652"},"modified":"2019-11-14T10:06:29","modified_gmt":"2019-11-14T01:06:29","slug":"%e3%80%90linux%e3%80%91%e3%80%90laravel%e3%80%91laravel%e3%81%8b%e3%82%89%e3%83%87%e3%83%bc%e3%82%bf%e3%83%99%e3%83%bc%e3%82%b9%e3%81%ab%e3%82%a2%e3%82%af%e3%82%bb%e3%82%b9%e3%81%99%e3%82%8b%e3%80%82","status":"publish","type":"post","link":"https:\/\/taki-lab.site\/bocci\/?p=1652","title":{"rendered":"\u3010Linux\u3011\u3010Laravel\u3011Laravel\u304b\u3089\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u30a2\u30af\u30bb\u30b9\u3059\u308b\u3002"},"content":{"rendered":"\n

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

mysql\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb<\/h2>\n\n\n\n
$ sudo apt-get install mysql-server<\/pre>\n\n\n\n
mysql\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\n
Laravel\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\n
migrate\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\n
PHP\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\n
CreateTestTable\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\n
Laravel\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> →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"\u3010Linux\u3011\u3010Laravel\u3011Laravel\u304b\u3089\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u30a2\u30af\u30bb\u30b9\u3059\u308b\u3002\n#TechCommit\n","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[8,6,3],"tags":[138,79,139],"class_list":["post-1652","post","type-post","status-publish","format-standard","hentry","category-linux","category-web","category-3","tag-laravel","tag-linux","tag-mysql"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t