質問編集履歴
2
db.sqlの追加
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -50,8 +50,104 @@
|
|
|
50
50
|
|
|
51
51
|
|
|
52
52
|
|
|
53
|
+
追記
|
|
54
|
+
|
|
55
|
+
---
|
|
56
|
+
|
|
53
57
|
・データベース名：local
|
|
54
58
|
|
|
55
59
|
・ユーザー名：root
|
|
56
60
|
|
|
57
61
|
・ホスト名：localhost
|
|
62
|
+
|
|
63
|
+
上記はlocal by flywheelの管理画面上で確認できるものです。
|
|
64
|
+
|
|
65
|
+
|
|
66
|
+
|
|
67
|
+
データベースにログインしてdb.sqlをエクスポートしたものを下記に示します。
|
|
68
|
+
|
|
69
|
+
```ここに言語を入力
|
|
70
|
+
|
|
71
|
+
-- Adminer 4.7.3 MySQL dump
|
|
72
|
+
|
|
73
|
+
|
|
74
|
+
|
|
75
|
+
SET NAMES utf8;
|
|
76
|
+
|
|
77
|
+
SET time_zone = '+00:00';
|
|
78
|
+
|
|
79
|
+
SET foreign_key_checks = 0;
|
|
80
|
+
|
|
81
|
+
SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
|
|
82
|
+
|
|
83
|
+
|
|
84
|
+
|
|
85
|
+
DROP TABLE IF EXISTS `db`;
|
|
86
|
+
|
|
87
|
+
CREATE TABLE `db` (
|
|
88
|
+
|
|
89
|
+
`Host` char(60) COLLATE utf8_bin NOT NULL DEFAULT '',
|
|
90
|
+
|
|
91
|
+
`Db` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',
|
|
92
|
+
|
|
93
|
+
`User` char(32) COLLATE utf8_bin NOT NULL DEFAULT '',
|
|
94
|
+
|
|
95
|
+
`Select_priv` enum('N','Y') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'N',
|
|
96
|
+
|
|
97
|
+
`Insert_priv` enum('N','Y') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'N',
|
|
98
|
+
|
|
99
|
+
`Update_priv` enum('N','Y') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'N',
|
|
100
|
+
|
|
101
|
+
`Delete_priv` enum('N','Y') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'N',
|
|
102
|
+
|
|
103
|
+
`Create_priv` enum('N','Y') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'N',
|
|
104
|
+
|
|
105
|
+
`Drop_priv` enum('N','Y') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'N',
|
|
106
|
+
|
|
107
|
+
`Grant_priv` enum('N','Y') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'N',
|
|
108
|
+
|
|
109
|
+
`References_priv` enum('N','Y') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'N',
|
|
110
|
+
|
|
111
|
+
`Index_priv` enum('N','Y') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'N',
|
|
112
|
+
|
|
113
|
+
`Alter_priv` enum('N','Y') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'N',
|
|
114
|
+
|
|
115
|
+
`Create_tmp_table_priv` enum('N','Y') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'N',
|
|
116
|
+
|
|
117
|
+
`Lock_tables_priv` enum('N','Y') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'N',
|
|
118
|
+
|
|
119
|
+
`Create_view_priv` enum('N','Y') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'N',
|
|
120
|
+
|
|
121
|
+
`Show_view_priv` enum('N','Y') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'N',
|
|
122
|
+
|
|
123
|
+
`Create_routine_priv` enum('N','Y') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'N',
|
|
124
|
+
|
|
125
|
+
`Alter_routine_priv` enum('N','Y') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'N',
|
|
126
|
+
|
|
127
|
+
`Execute_priv` enum('N','Y') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'N',
|
|
128
|
+
|
|
129
|
+
`Event_priv` enum('N','Y') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'N',
|
|
130
|
+
|
|
131
|
+
`Trigger_priv` enum('N','Y') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'N',
|
|
132
|
+
|
|
133
|
+
PRIMARY KEY (`Host`,`Db`,`User`),
|
|
134
|
+
|
|
135
|
+
KEY `User` (`User`)
|
|
136
|
+
|
|
137
|
+
) /*!50100 TABLESPACE `mysql` */ ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin STATS_PERSISTENT=0 COMMENT='Database privileges';
|
|
138
|
+
|
|
139
|
+
|
|
140
|
+
|
|
141
|
+
INSERT INTO `db` (`Host`, `Db`, `User`, `Select_priv`, `Insert_priv`, `Update_priv`, `Delete_priv`, `Create_priv`, `Drop_priv`, `Grant_priv`, `References_priv`, `Index_priv`, `Alter_priv`, `Create_tmp_table_priv`, `Lock_tables_priv`, `Create_view_priv`, `Show_view_priv`, `Create_routine_priv`, `Alter_routine_priv`, `Execute_priv`, `Event_priv`, `Trigger_priv`) VALUES
|
|
142
|
+
|
|
143
|
+
('localhost', 'performance_schema', 'mysql.session', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N'),
|
|
144
|
+
|
|
145
|
+
('localhost', 'sys', 'mysql.sys', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'Y');
|
|
146
|
+
|
|
147
|
+
|
|
148
|
+
|
|
149
|
+
-- 2020-05-01 07:53:07
|
|
150
|
+
|
|
151
|
+
|
|
152
|
+
|
|
153
|
+
```
|
1
データベース名等追加しました
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -47,3 +47,11 @@
|
|
|
47
47
|
どなたかわかる方いらっしゃいましたら教えていただきたいです。
|
|
48
48
|
|
|
49
49
|
よろしくお願いいたします。
|
|
50
|
+
|
|
51
|
+
|
|
52
|
+
|
|
53
|
+
・データベース名：local
|
|
54
|
+
|
|
55
|
+
・ユーザー名：root
|
|
56
|
+
|
|
57
|
+
・ホスト名：localhost
|