差分

このページの2つのバージョン間の差分を表示します。

--- mysql:phpmyadmin_ex [2014/02/26 08:13] – mysql:phpmyadminの拡張機能 renamed to mysql:phpmyadmin_ex clownclown
+++ mysql:phpmyadmin_ex [2025/02/16 13:53] (現在) – 外部編集 127.0.0.1
@@ 行 1: / 行 1: @@
 ===== phpmyadminの拡張機能 =====
-===== 設定ファイル変更  =====
+===== 管理用テーブル作成  =====
-以下のコメントアウトをはずす
+./scripts/create_tables.sql を実行
-変更前
 <code>
-/* Advanced phpMyAdmin features */
+# mysql -uroot -p
-// $cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
+インポート
-// $cfg['Servers'][$i]['bookmarktable'] = 'pma_bookmark';
+mysql> source /var/www/phpMyAdmin/examples/create_tables.sql
-// $cfg['Servers'][$i]['relation'] = 'pma_relation';
+インポートの確認
-// $cfg['Servers'][$i]['table_info'] = 'pma_table_info';
+mysql> show databases;
-// $cfg['Servers'][$i]['table_coords'] = 'pma_table_coords';
+mysql> use phpmyadmin;
-// $cfg['Servers'][$i]['pdf_pages'] = 'pma_pdf_pages';
+mysql> show tables;
-// $cfg['Servers'][$i]['column_info'] = 'pma_column_info';
-// $cfg['Servers'][$i]['history'] = 'pma_history';
-// $cfg['Servers'][$i]['tracking'] = 'pma_tracking';
-// $cfg['Servers'][$i]['designer_coords'] = 'pma_designer_coords';
 </code>
-変更後
+===== 作成したテーブル（phpmyadmin）にアクセスできるユーザ pma を作成  =====
 <code>
-/* Advanced phpMyAdmin features */
+GRANT ALL ON phpmyadmin.* TO pma@localhost IDENTIFIED BY “pmapass”;
-$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
-$cfg['Servers'][$i]['bookmarktable'] = 'pma_bookmark';
-$cfg['Servers'][$i]['relation'] = 'pma_relation';
-$cfg['Servers'][$i]['table_info'] = 'pma_table_info';
-$cfg['Servers'][$i]['table_coords'] = 'pma_table_coords';
-$cfg['Servers'][$i]['pdf_pages'] = 'pma_pdf_pages';
-$cfg['Servers'][$i]['column_info'] = 'pma_column_info';
-$cfg['Servers'][$i]['history'] = 'pma_history';
-$cfg['Servers'][$i]['tracking'] = 'pma_tracking';
-$cfg['Servers'][$i]['designer_coords'] = 'pma_designer_coords';
 </code>
-===== 管理用テーブル作成  =====
-./scripts/create_tables.sql を実行
+===== 設定ファイル変更  =====
+設定ファイル (config.inc.php) で高度な機能を有効にします。
+※接続先の定義が複数ある場合は、それぞれに記述が必要。
 <code>
--- --------------------------------------------------------
+$cfg['Servers'][$i]['controlhost'] = ”;
--- SQL Commands to set up the pmadb as described in Documentation.html.
+$cfg['Servers'][$i]['controluser'] = ‘pma’;
---
+$cfg['Servers'][$i]['controlpass'] = ‘pmapass’;
--- This file is meant for use with MySQL 5 and above!
+$cfg['Servers'][$i]['pmadb'] = ‘phpmyadmin’;
---
+$cfg['Servers'][$i]['bookmarktable'] = ‘pma_bookmark’;
--- This script expects the user pma to already be existing. If we would put a
+$cfg['Servers'][$i]['relation'] = ‘pma_relation’;
--- line here to create him too many users might just use this script and end
+$cfg['Servers'][$i]['table_info'] = ‘pma_table_info’;
--- up with having the same password for the controluser.
+$cfg['Servers'][$i]['table_coords'] = ‘pma_table_coords’;
---
+$cfg['Servers'][$i]['pdf_pages'] = ‘pma_pdf_pages’;
--- This user "pma" must be defined in config.inc.php (controluser/controlpass)
+$cfg['Servers'][$i]['column_info'] = ‘pma_column_info’;
---
+$cfg['Servers'][$i]['history'] = ‘pma_history’;
--- Please don't forget to set up the tablenames in config.inc.php
+$cfg['Servers'][$i]['table_uiprefs'] = ‘pma_table_uiprefs’;
---
+$cfg['Servers'][$i]['tracking'] = ‘pma_tracking’;
--- $Id$
+$cfg['Servers'][$i]['designer_coords'] = ‘pma_designer_coords’;
+$cfg['Servers'][$i]['userconfig'] = ‘pma_userconfig’;
+$cfg['Servers'][$i]['recent'] = ‘pma_recent’;
+$cfg['Servers'][$i]['table_uiprefs'] = ‘pma_table_uiprefs’;
+$cfg['Servers'][$i]['auth_swekey_config'] = ‘/etc/swekey-pma.conf’;
+</code>
--- --------------------------------------------------------
---
--- Database : `phpmyadmin`
---
-CREATE DATABASE IF NOT EXISTS `phpmyadmin`
-  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
-USE phpmyadmin;
--- --------------------------------------------------------
---
--- Privileges
---
--- (activate this statement if necessary)
--- GRANT SELECT, INSERT, DELETE, UPDATE ON `phpmyadmin`.* TO
---    'pma'@localhost;
--- --------------------------------------------------------
---
--- Table structure for table `pma_bookmark`
---
-CREATE TABLE IF NOT EXISTS `pma_bookmark` (
-  `id` int(11) NOT NULL auto_increment,
-  `dbase` varchar(255) NOT NULL default '',
-  `user` varchar(255) NOT NULL default '',
-  `label` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL default '',
-  `query` text NOT NULL,
-  PRIMARY KEY  (`id`)
-)
-  ENGINE=MyISAM COMMENT='Bookmarks'
-  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
--- --------------------------------------------------------
---
--- Table structure for table `pma_column_info`
---
-CREATE TABLE IF NOT EXISTS `pma_column_info` (
-  `id` int(5) unsigned NOT NULL auto_increment,
-  `db_name` varchar(64) NOT NULL default '',
-  `table_name` varchar(64) NOT NULL default '',
-  `column_name` varchar(64) NOT NULL default '',
-  `comment` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL default '',
-  `mimetype` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL default '',
-  `transformation` varchar(255) NOT NULL default '',
-  `transformation_options` varchar(255) NOT NULL default '',
-  PRIMARY KEY  (`id`),
-  UNIQUE KEY `db_name` (`db_name`,`table_name`,`column_name`)
-)
-  ENGINE=MyISAM COMMENT='Column information for phpMyAdmin'
-  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
--- --------------------------------------------------------
---
--- Table structure for table `pma_history`
---
-CREATE TABLE IF NOT EXISTS `pma_history` (
-  `id` bigint(20) unsigned NOT NULL auto_increment,
-  `username` varchar(64) NOT NULL default '',
-  `db` varchar(64) NOT NULL default '',
-  `table` varchar(64) NOT NULL default '',
-  `timevalue` timestamp NOT NULL,
-  `sqlquery` text NOT NULL,
-  PRIMARY KEY  (`id`),
-  KEY `username` (`username`,`db`,`table`,`timevalue`)
-)
-  ENGINE=MyISAM COMMENT='SQL history for phpMyAdmin'
-  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
--- --------------------------------------------------------
---
--- Table structure for table `pma_pdf_pages`
---
-CREATE TABLE IF NOT EXISTS `pma_pdf_pages` (
-  `db_name` varchar(64) NOT NULL default '',
-  `page_nr` int(10) unsigned NOT NULL auto_increment,
-  `page_descr` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL default '',
-  PRIMARY KEY  (`page_nr`),
-  KEY `db_name` (`db_name`)
-)
-  ENGINE=MyISAM COMMENT='PDF relation pages for phpMyAdmin'
-  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
--- --------------------------------------------------------
---
--- Table structure for table `pma_relation`
---
-CREATE TABLE IF NOT EXISTS `pma_relation` (
-  `master_db` varchar(64) NOT NULL default '',
-  `master_table` varchar(64) NOT NULL default '',
-  `master_field` varchar(64) NOT NULL default '',
-  `foreign_db` varchar(64) NOT NULL default '',
-  `foreign_table` varchar(64) NOT NULL default '',
-  `foreign_field` varchar(64) NOT NULL default '',
-  PRIMARY KEY  (`master_db`,`master_table`,`master_field`),
-  KEY `foreign_field` (`foreign_db`,`foreign_table`)
-)
-  ENGINE=MyISAM COMMENT='Relation table'
-  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
--- --------------------------------------------------------
---
--- Table structure for table `pma_table_coords`
---
-CREATE TABLE IF NOT EXISTS `pma_table_coords` (
-  `db_name` varchar(64) NOT NULL default '',
-  `table_name` varchar(64) NOT NULL default '',
-  `pdf_page_number` int(11) NOT NULL default '0',
-  `x` float unsigned NOT NULL default '0',
-  `y` float unsigned NOT NULL default '0',
-  PRIMARY KEY  (`db_name`,`table_name`,`pdf_page_number`)
-)
-  ENGINE=MyISAM COMMENT='Table coordinates for phpMyAdmin PDF output'
-  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
--- --------------------------------------------------------
---
--- Table structure for table `pma_table_info`
---
-CREATE TABLE IF NOT EXISTS `pma_table_info` (
-  `db_name` varchar(64) NOT NULL default '',
-  `table_name` varchar(64) NOT NULL default '',
-  `display_field` varchar(64) NOT NULL default '',
-  PRIMARY KEY  (`db_name`,`table_name`)
-)
-  ENGINE=MyISAM COMMENT='Table information for phpMyAdmin'
-  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
--- --------------------------------------------------------
---
--- Table structure for table `pma_designer_coords`
---
-CREATE TABLE IF NOT EXISTS `pma_designer_coords` (
-  `db_name` varchar(64) NOT NULL default '',
-  `table_name` varchar(64) NOT NULL default '',
-  `x` INT,
-  `y` INT,
-  `v` TINYINT,
-  `h` TINYINT,
-  PRIMARY KEY (`db_name`,`table_name`)
-)
-  ENGINE=MyISAM COMMENT='Table coordinates for Designer'
-  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
--- --------------------------------------------------------
---
--- Table structure for table `pma_tracking`
---
-CREATE TABLE IF NOT EXISTS `pma_tracking` (
-  `db_name` varchar(64) collate utf8_bin NOT NULL,
-  `table_name` varchar(64) collate utf8_bin NOT NULL,
-  `version` int(10) unsigned NOT NULL,
-  `date_created` datetime NOT NULL,
-  `date_updated` datetime NOT NULL,
-  `schema_snapshot` text collate utf8_bin NOT NULL,
-  `schema_sql` text collate utf8_bin,
-  `data_sql` longtext collate utf8_bin,
-  `tracking` set('UPDATE','REPLACE','INSERT','DELETE','TRUNCATE','CREATE DATABASE','ALTER DATABASE','DROP DATABASE','CREATE TABLE','ALTER TABLE','RENAME TABLE','DROP TABLE','CREATE INDEX','DROP INDEX','CREATE VIEW','ALTER VIEW','DROP VIEW') collate utf8_bin default NULL,
-  `tracking_active` int(1) unsigned NOT NULL default '1',
-  PRIMARY KEY  (`db_name`,`table_name`,`version`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=COMPACT;
-</code>