MySQLとLaravelを接続する方法を実例で解説｜データベース(DB)にテーブルを作成する手順（パスワードの変更・ログイン・再起動）

$ mysql --version

$ mysql --version
bash: mysql: command not found

$ brew info mysql

$ brew info mysql
mysql: stable 8.0.23 (bottled)
Open source relational database management system

MySQL :: MySQL 8.0 Reference Manual
dev.mysql.com
Conflicts with:
  mariadb (because mysql, mariadb, and percona install the same binaries)
  percona-server (because mysql, mariadb, and percona install the same binaries)
Not installed
From: https://github.com/Homebrew/homebrew-core/blob/HEAD/Formula/mysql.rb
License: GPL-2.0-only
==> Dependencies
Build: cmake ✘
Required: openssl@1.1 ✔, protobuf ✘
==> Caveats
We've installed your MySQL database without a root password. To secure it run:
    mysql_secure_installation

MySQL is configured to only allow connections from localhost by default

To connect run:
    mysql -uroot

To have launchd start mysql now and restart at login:
  brew services start mysql
Or, if you don't want/need a background service you can just run:
  mysql.server start
==> Analytics
install: 79,163 (30 days), 231,779 (90 days), 835,371 (365 days)
install-on-request: 77,990 (30 days), 228,357 (90 days), 813,893 (365 days)
build-error: 0 (30 days)

$ mysql --version
bash: mysql: command not found

$ brew install mysql

$ brew install mysql
Updating Homebrew...
==> Auto-updated Homebrew!
Updated 1 tap (homebrew/core).
==> New Formulae
curlie                   dasel                    ht-rust
==> Updated Formulae
Updated 904 formulae.

==> Downloading https://homebrew.bintray.com/bottles/protobuf-3.14.0.catali
==> Downloading from https://d29vzk4ow07wi7.cloudfront.net/8d53111626404e2b
==> Downloading https://homebrew.bintray.com/bottles/mysql-8.0.23.catalina.
==> Downloading from https://d29vzk4ow07wi7.cloudfront.net/308601d9802846e2
==> Installing dependencies for mysql: protobuf
==> Installing mysql dependency: protobuf
==> Pouring protobuf-3.14.0.catalina.bottle.1.tar.gz
==> Caveats
Emacs Lisp files have been installed to:
  /usr/local/share/emacs/site-lisp/protobuf
==> Summary
🍺  /usr/local/Cellar/protobuf/3.14.0: 211 files, 17.8MB
==> Installing mysql
==> Pouring mysql-8.0.23.catalina.bottle.tar.gz
==> /usr/local/Cellar/mysql/8.0.23/bin/mysqld --initialize-insecure --user=
==> Caveats
We've installed your MySQL database without a root password. To secure it run:
    mysql_secure_installation

MySQL is configured to only allow connections from localhost by default

To connect run:
    mysql -uroot

To have launchd start mysql now and restart at login:
  brew services start mysql
Or, if you don't want/need a background service you can just run:
  mysql.server start

$ mysql --version
mysql  Ver 8.0.23 for osx10.15 on x86_64 (Homebrew)

$ mysql.server start

$ mysql.server start

Starting MySQL
.. SUCCESS! 

$ mysql -uroot

$ mysql -uroot
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 8.0.23 Homebrew

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> 

mysql> show databases;

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
4 rows in set (0.01 sec)

create database DB名

mysql> create database SampleApp;
Query OK, 1 row affected (0.00 sec)

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| SampleApp          |
| sys                |
+--------------------+
5 rows in set (0.00 sec)

ALTER USER <user> IDENTIFIED BY <auth_string>

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'secret';
Query OK, 0 rows affected (0.00 sec)

exit;

$ mysql.server restart

mysql> exit;
Bye

$ mysql.server restart
Shutting down MySQL
. SUCCESS! 
Starting MySQL
. SUCCESS! 

$ mysql -uroot -p

$ mysql -uroot -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 8.0.23 Homebrew

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> 

SELECT user, host, plugin FROM mysql.user;

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'secret';

mysql> SELECT user, host, plugin FROM mysql.user;
+------------------+-----------+-----------------------+
| user             | host      | plugin                |
+------------------+-----------+-----------------------+
| mysql.infoschema | localhost | caching_sha2_password |
| mysql.session    | localhost | caching_sha2_password |
| mysql.sys        | localhost | caching_sha2_password |
| root             | localhost | caching_sha2_password |
+------------------+-----------+-----------------------+
4 rows in set (0.00 sec)

mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'secret';
Query OK, 0 rows affected (0.00 sec)

mysql> SELECT user, host, plugin FROM mysql.user;
+------------------+-----------+-----------------------+
| user             | host      | plugin                |
+------------------+-----------+-----------------------+
| mysql.infoschema | localhost | caching_sha2_password |
| mysql.session    | localhost | caching_sha2_password |
| mysql.sys        | localhost | caching_sha2_password |
| root             | localhost | mysql_native_password |
+------------------+-----------+-----------------------+
4 rows in set (0.00 sec)

$ php artisan --version
Laravel Framework 8.23.1

$ php --version
PHP 7.3.11 (cli) (built: Jun  5 2020 23:50:40) ( NTS )

DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=SampleApp #DB名にする
DB_USERNAME=root
DB_PASSWORD=secret   #設定したパスワードにする

$ php artisan cache:clear

$ php artisan cache:clear
Application cache cleared!

$ php artisan migrate

$ php artisan migrate

Migration table created successfully.
Migrating: 2014_10_12_000000_create_users_table
Migrated:  2014_10_12_000000_create_users_table (14.31ms)
Migrating: 2014_10_12_100000_create_password_resets_table
Migrated:  2014_10_12_100000_create_password_resets_table (10.49ms)
Migrating: 2019_08_19_000000_create_failed_jobs_table
Migrated:  2019_08_19_000000_create_failed_jobs_table (11.03ms)

use <データベース名>

show tables;

mysql> use SampleApp
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> show tables;
+---------------------+
| Tables_in_sampleapp |
+---------------------+
| failed_jobs         |
| migrations          |
| password_resets     |
| users               |
+---------------------+

$ mysql.server stop

$ mysql.server stop

Shutting down MySQL
. SUCCESS!