回答編集履歴

2

追記

2017/05/28 08:59

投稿

tkmtmkt
tkmtmkt

スコア1800

test CHANGED
@@ -52,6 +52,26 @@
52
52
 
53
53
  1 row in set (0.00 sec)
54
54
 
55
+
56
+
57
+ MariaDB [(none)]> SELECT `Host`,`Db`,`User` FROM mysql.db;
58
+
59
+ +-----------+---------+---------+
60
+
61
+ | Host | Db | User |
62
+
63
+ +-----------+---------+---------+
64
+
65
+ | % | test | |
66
+
67
+ | % | test\_% | |
68
+
69
+ | localhost | redmine | redmine |
70
+
71
+ +-----------+---------+---------+
72
+
73
+ 3 rows in set (0.02 sec)
74
+
55
75
  ```
56
76
 
57
77
 

1

追記

2017/05/28 08:59

投稿

tkmtmkt
tkmtmkt

スコア1800

test CHANGED
@@ -7,3 +7,51 @@
7
7
 
8
8
 
9
9
  ログイン時のコマンドを見直してみてはどうでしょう。
10
+
11
+
12
+
13
+ **【補足】**
14
+
15
+
16
+
17
+ 念のため確認したところ、以下のようになりました。
18
+
19
+
20
+
21
+ ```
22
+
23
+ $ mysql -u hoge
24
+
25
+ Welcome to the MariaDB monitor. Commands end with ; or \g.
26
+
27
+ Your MariaDB connection id is 129
28
+
29
+ Server version: 5.5.52-MariaDB MariaDB Server
30
+
31
+
32
+
33
+ Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.
34
+
35
+
36
+
37
+ Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
38
+
39
+
40
+
41
+ MariaDB [(none)]> show grants;
42
+
43
+ +---------------------------------------------------+
44
+
45
+ | Grants for hoge@localhost |
46
+
47
+ +---------------------------------------------------+
48
+
49
+ | GRANT ALL PRIVILEGES ON *.* TO 'hoge'@'localhost' |
50
+
51
+ +---------------------------------------------------+
52
+
53
+ 1 row in set (0.00 sec)
54
+
55
+ ```
56
+
57
+