prefectures テーブル SQL

INSERT INTO `prefectures` VALUES
(1,'北海道', NULL, NULL);
(2,'青森県', NULL, NULL),
(3,'岩手県', NULL, NULL),
(4,'宮城県', NULL, NULL),
(5,'秋田県', NULL, NULL),
(6,'山形県', NULL, NULL),
(7,'福島県', NULL, NULL),
(8,'茨城県', NULL, NULL),
(9,'栃木県', NULL, NULL),
(10,'群馬県', NULL, NULL),
(11,'埼玉県', NULL, NULL),
(12,'千葉県', NULL, NULL),
(13,'東京都', NULL, NULL),
(14,'神奈川県', NULL, NULL),
(15,'新潟県', NULL, NULL),
(16,'富山県', NULL, NULL),
(17,'石川県', NULL, NULL),
(18,'福井県', NULL, NULL),
(19,'山梨県', NULL, NULL),
(20,'長野県', NULL, NULL),
(21,'岐阜県', NULL, NULL),
(22,'静岡県', NULL, NULL),
(23,'愛知県', NULL, NULL),
(24,'三重県', NULL, NULL),
(25,'滋賀県', NULL, NULL),
(26,'京都府', NULL, NULL),
(27,'大阪府', NULL, NULL),
(28,'兵庫県', NULL, NULL),
(29,'奈良県', NULL, NULL),
(30,'和歌山県', NULL, NULL),
(31,'鳥取県', NULL, NULL),
(32,'島根県', NULL, NULL),
(33,'岡山県', NULL, NULL),
(34,'広島県', NULL, NULL),
(35,'山口県', NULL, NULL),
(36,'徳島県', NULL, NULL),
(37,'香川県', NULL, NULL),
(38,'愛媛県', NULL, NULL),
(39,'高知県', NULL, NULL),
(40,'福岡県', NULL, NULL),
(41,'佐賀県', NULL, NULL),
(42,'長崎県', NULL, NULL),
(43,'熊本県', NULL, NULL),
(44,'大分県', NULL, NULL),
(45,'宮崎県', NULL, NULL),
(46,'鹿児島県', NULL, NULL),
(47,'沖縄県', NULL, NULL),
(48,'オンライン', NULL, NULL);

 

地方・都道府県マスタ - Qiita

EC2 立ち上げ mysql

nginx, php-fpm はいけた

 

mysql が入らない

Amazon Linux2でmysqlを入れようとしたらエラーが出た - Qiita

mariadb を消して、mysqldを入れる

Amazon Linux 2 で MySQL を使用する – Amazon Web Service(AWS)導入開発支援

 

#自動起動設定
$ sudo systemctl start mysqld.service
$ sudo systemctl enable mysqld.service
$ systemctl status mysqld.service

 

mysql 初期設定

cat /var/log/mysqld.log | grep password

mysql_secure_installation

AWSのEC2で行うAmazon Linux2(MySQL5.7)環境構築 - Qiita

 

 

 

新規docker コンテナ作成 コマンド一覧

docker run -i -t -d -v /Users/mirei_hayase/git/:/home/git --name コンテナ名 -p 8082:80 -p 3306:3306 --privileged 22bb35c58310 /sbin/init

 

vim /etc/nginx/conf.d/default.conf

root /home/git/qa_test/public;

 

yum install -y mysql-server

これがなぜか入ってなくて、mysql につながらなかった

 

```
1 cd /home/suzuki/git/hivelocity/c_r/renewal-api/
2 ls -la storage/
3 chmod 777 storage/resume/
4 ls -la
5 ls -la storage/resume/
6 /etc/init.d/
7 ls -la /etc/init.d/
8 cat /etc/redhat-release
9 php -v
10 yum install nginx
11 yum install epel-release
12 yum install nginx
13 rpm -Uvh http://rpms.famillecollet.com/enterprise/remi-release-6.rpm
14 yum install php-fpm php-cli php-pdo php-mysql php-mbstring php-mcrypt php-devel --enablerepo=remi-php70
15 php -v
16 vim /etc/nginx/nginx.conf
17 yum install vim
18 vim /etc/nginx/nginx.conf
19 vim /etc/nginx/conf.d/virtual.conf
20 vim /etc/nginx/conf.d/default.conf
21 vim /etc/nginx/conf.d/default.conf
22 /etc/init.d/php-fpm start
23 /etc/init.d/nginx start
24 vim /etc/nginx/conf.d/default.conf
25 /etc/init.d/nginx start
26 chkconfig on nginx
27 chkconfig nginx on
28 chkconfig php-fpm on
29 php -v
30 vim /etc/nginx/conf.d/default.conf
31 /etc/init.d/nginx restart
32 vim /etc/nginx/conf.d/default.conf
33 /etc/init.d/nginx restart
34 vim /etc/nginx/conf.d/default.conf
35 /etc/init.d/nginx restart
36 /etc/init.d/nginx restart
37 /etc/init.d/nginx restart
38 vim /etc/nginx/conf.d/default.conf
39 /etc/init.d/nginx restart
40 vim /etc/nginx/conf.d/default.conf
41 /etc/init.d/nginx restart
42 vim /etc/nginx/conf.d/default.conf
43 /etc/init.d/nginx restart
45 cat /etc/redhat-release
47 php -v
50 nginx -v
51 vim /etc/nginx/nginx.conf
52 vim /etc/nginx/conf.d/virtual.conf
53 vim /etc/nginx/conf.d/default.conf
54 vim /etc/nginx/conf.d/virtual.conf
55 cd /home/suzuki/git/hivelocity/c_r/admin/
56 composer global require "laravel/installer"
57 curl -sS https://getcomposer.org/installer | php
58 mv composer.phar /usr/local/bin/composer
59 composer global require "laravel/installer"
60 yum install git
61 composer create-project --prefer-dist laravel/laravel blog
62 /etc/init.d/nginx restart
63 vim /etc/nginx/conf.d/virtual.conf
64 /etc/init.d/nginx status
65 /etc/init.d/nginx restart
66 /etc/init.d/php-fpm status
67 /etc/init.d/php-fpm restart
68 vim /etc/nginx/nginx.conf
69 vim /etc/nginx/conf.d/virtual.conf
70 /etc/init.d/nginx restart
72 tail -f storage/logs/laravel.log
73 ll storage/logs/
74 date
80 chmod 777 storage/ -R
81 tail -f storage/logs/laravel.log
89 mysql -u root

```