質問編集履歴

3

編集ミス 削除

2019/08/11 06:35

投稿

Ms.yy
Ms.yy

スコア83

test CHANGED
File without changes
test CHANGED
@@ -52,55 +52,7 @@
52
52
 
53
53
 
54
54
 
55
- ### php artisan db:seed --class=OwnersTableSeeder実行時のエラー
56
55
 
57
- ```ここに言語を入力
58
-
59
- Illuminate\Database\QueryException : SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: NO) (SQL: insert into `owners` (`login_id`, `password`) values (owner01, $2y$10$5LTYbs97bHW3SO56d3ui8uQfyzFXWGD.2Gp6PSjgPb4sL8lpRWXEm))
60
-
61
-
62
-
63
- at /home/vagrant/code/laravel-bbs/vendor/laravel/framework/src/Illuminate/Database/Connection.php:664
64
-
65
- 660| // If an exception occurs when attempting to run a query, we'll format the error
66
-
67
- 661| // message to include the bindings with SQL, which will make this exception a
68
-
69
- 662| // lot more helpful to the developer instead of just the database's errors.
70
-
71
- 663| catch (Exception $e) {
72
-
73
- > 664| throw new QueryException(
74
-
75
- 665| $query, $this->prepareBindings($bindings), $e
76
-
77
- 666| );
78
-
79
- 667| }
80
-
81
- 668|
82
-
83
-
84
-
85
- Exception trace:
86
-
87
-
88
-
89
- 1 PDOException::("SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: NO)")
90
-
91
- /home/vagrant/code/laravel-bbs/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php:70
92
-
93
-
94
-
95
- 2 PDO::__construct("mysql:host=127.0.0.1;port=3306;dbname=laravel", "root", "", [])
96
-
97
- /home/vagrant/code/laravel-bbs/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php:70
98
-
99
-
100
-
101
- Please use the argument -v to see more details.
102
-
103
- ```
104
56
 
105
57
 
106
58
 

2

php artisan db:seed実行時のエラーの記載(Access denied for user ‘root’@’localhost’の部分)

2019/08/11 06:35

投稿

Ms.yy
Ms.yy

スコア83

test CHANGED
File without changes
test CHANGED
@@ -52,7 +52,55 @@
52
52
 
53
53
 
54
54
 
55
- ### 試したこと
55
+ ### php artisan db:seed --class=OwnersTableSeeder実行時のエラー
56
+
57
+ ```ここに言語を入力
58
+
59
+ Illuminate\Database\QueryException : SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: NO) (SQL: insert into `owners` (`login_id`, `password`) values (owner01, $2y$10$5LTYbs97bHW3SO56d3ui8uQfyzFXWGD.2Gp6PSjgPb4sL8lpRWXEm))
60
+
61
+
62
+
63
+ at /home/vagrant/code/laravel-bbs/vendor/laravel/framework/src/Illuminate/Database/Connection.php:664
64
+
65
+ 660| // If an exception occurs when attempting to run a query, we'll format the error
66
+
67
+ 661| // message to include the bindings with SQL, which will make this exception a
68
+
69
+ 662| // lot more helpful to the developer instead of just the database's errors.
70
+
71
+ 663| catch (Exception $e) {
72
+
73
+ > 664| throw new QueryException(
74
+
75
+ 665| $query, $this->prepareBindings($bindings), $e
76
+
77
+ 666| );
78
+
79
+ 667| }
80
+
81
+ 668|
82
+
83
+
84
+
85
+ Exception trace:
86
+
87
+
88
+
89
+ 1 PDOException::("SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: NO)")
90
+
91
+ /home/vagrant/code/laravel-bbs/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php:70
92
+
93
+
94
+
95
+ 2 PDO::__construct("mysql:host=127.0.0.1;port=3306;dbname=laravel", "root", "", [])
96
+
97
+ /home/vagrant/code/laravel-bbs/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php:70
98
+
99
+
100
+
101
+ Please use the argument -v to see more details.
102
+
103
+ ```
56
104
 
57
105
 
58
106
 

1

追記 vagrannt

2019/08/11 06:33

投稿

Ms.yy
Ms.yy

スコア83

test CHANGED
File without changes
test CHANGED
@@ -56,7 +56,25 @@
56
56
 
57
57
 
58
58
 
59
-  
59
+ passwordをvagrantで実行後、認証完了したが新たなエラー
60
+
61
+  ```ここに言語を入力
62
+
63
+ ==== AUTHENTICATING FOR org.freedesktop.systemd1.manage-units ===
64
+
65
+ Authentication is required to stop 'mysqld.service'.
66
+
67
+ Authenticating as: vagrant,,, (vagrant)
68
+
69
+ Password:
70
+
71
+ ==== AUTHENTICATION COMPLETE ===
72
+
73
+ Failed to stop mysqld.service: Unit mysqld.service not loaded.
74
+
75
+ vagrant@homestead:~/code/laravel-bbs$
76
+
77
+ ```
60
78
 
61
79
 
62
80