teratail header banner
teratail header banner
質問するログイン新規登録

質問編集履歴

2

追加

2018/05/02 00:53

投稿

freezaa
freezaa

スコア12

title CHANGED
File without changes
body CHANGED
@@ -7,6 +7,60 @@
7
7
 
8
8
  #1045 - Access denied for user 'root'@'localhost' (using password: YES)
9
9
 
10
+ phpmyadmin/config.inc.phpの中身は以下のようになっています。
11
+
12
+ /* Configure according to dbconfig-common if enabled */
13
+ if (!empty($dbname)) {
14
+ /* Authentication type */
15
+ $cfg['Servers'][$i]['auth_type'] = 'cookie';
16
+ /* Server parameters */
17
+ if (empty($dbserver)) $dbserver = 'localhost';
18
+ $cfg['Servers'][$i]['host'] = $dbserver;
19
+
20
+ if (!empty($dbport) || $dbserver != 'localhost') {
21
+ $cfg['Servers'][$i]['connect_type'] = 'tcp';
22
+ $cfg['Servers'][$i]['port'] = $dbport;
23
+ }
24
+ //$cfg['Servers'][$i]['compress'] = false;
25
+ /* Select mysqli if your server has it */
26
+ $cfg['Servers'][$i]['extension'] = 'mysqli';
27
+ /* Optional: User for advanced features */
28
+ $cfg['Servers'][$i]['controluser'] = $dbuser;
29
+ $cfg['Servers'][$i]['controlpass'] = $dbpass;
30
+ //$cfg['Servers'][$i]['compress'] = false;
31
+ /* Select mysqli if your server has it */
32
+ $cfg['Servers'][$i]['extension'] = 'mysqli';
33
+ /* Optional: User for advanced features */
34
+ $cfg['Servers'][$i]['controluser'] = $dbuser;
35
+ $cfg['Servers'][$i]['controlpass'] = $dbpass;
36
+ /* Optional: Advanced phpMyAdmin features */
37
+ $cfg['Servers'][$i]['pmadb'] = $dbname;
38
+ $cfg['Servers'][$i]['bookmarktable'] = 'pma__bookmark';
39
+ $cfg['Servers'][$i]['relation'] = 'pma__relation';
40
+ $cfg['Servers'][$i]['table_info'] = 'pma__table_info';
41
+ $cfg['Servers'][$i]['table_coords'] = 'pma__table_coords';
42
+ $cfg['Servers'][$i]['pdf_pages'] = 'pma__pdf_pages';
43
+ $cfg['Servers'][$i]['column_info'] = 'pma__column_info';
44
+ $cfg['Servers'][$i]['history'] = 'pma__history';
45
+ $cfg['Servers'][$i]['table_uiprefs'] = 'pma__table_uiprefs';
46
+ $cfg['Servers'][$i]['tracking'] = 'pma__tracking';
47
+ $cfg['Servers'][$i]['userconfig'] = 'pma__userconfig';
48
+ $cfg['Servers'][$i]['recent'] = 'pma__recent';
49
+ $cfg['Servers'][$i]['favorite'] = 'pma__favorite';
50
+ $cfg['Servers'][$i]['users'] = 'pma__users';
51
+ $cfg['Servers'][$i]['usergroups'] = 'pma__usergroups';
52
+ $cfg['Servers'][$i]['navigationhiding'] = 'pma__navigationhiding';
53
+ $cfg['Servers'][$i]['savedsearches'] = 'pma__savedsearches';
54
+ $cfg['Servers'][$i]['central_columns'] = 'pma__central_columns';
55
+ $cfg['Servers'][$i]['designer_settings'] = 'pma__designer_settings';
56
+ $cfg['Servers'][$i]['export_templates'] = 'pma__export_templates';
57
+ /* Optional: Advanced phpMyAdmin features */
58
+ $cfg['Servers'][$i]['pmadb'] = $dbname;
59
+ $cfg['Servers'][$i]['bookmarktable'] = 'pma__bookmark';
60
+ $cfg['Servers'][$i]['relation'] = 'pma__relation';
61
+ $cfg['Servers'][$i]['table_info'] = 'pma__table_info';
62
+
63
+
10
64
  パスワードも以前コマンドでログインできていたのですがログインできなくなりました。
11
65
  ずっと考えて色々検索してみましたが対処方法が分かりませんでした。
12
66
  お手数お掛けしますがご教示いただければ幸いです。

1

書式の改善

2018/05/02 00:53

投稿

freezaa
freezaa

スコア12

title CHANGED
File without changes
body CHANGED
@@ -1,3 +1,5 @@
1
+ VPSサーバーを使用しています。
2
+
1
3
  下記の記事を参考にUbuntu 16.04にphpmyadminをインストールしました。
2
4
  https://www.server-world.info/query?os=Ubuntu_16.04&p=mariadb&f=2
3
5