상세 컨텐츠

본문 제목

phpMyAdmin 설정 스토리지가 완전히 설정되지 않아

Bitnami/phpMyAdmin

by History+Young 2017. 7. 9. 07:00

본문


Disable the default warning that is displayed on the DB Details Structure page if any of the required Tables for the configuration storage could not be found


설정 스토리지(the configuration storage)에 필요한 테이블을 찾을 수 없는 경우

DB 세부 구조 페이지에 표시된 기본 경고(the default warning)를 비활성화합니다.

$cfg['PmaNoRelation_DisableWarning'] = true;


http://www.softore.co.kr/index.php?document_srl=1041&mid=SoftoreBlog



가장 좋은 방법은 위와 같이 비활성화 기능을 켜주는 것이다.

위 증상과 관련하여 아래와 같은 글을 찾을 수 있음.


1. 데이터베이스를 생성하여 설정한다.

2.설정파일을 수정해준다.


참고 : https://www.conory.com/note_linux/44014



1. phpmyadmin/htdocs/config.inc.php 수정


$cfg['Servers'][$i]['controlhost'] = 'localhost';

$cfg['Servers'][$i]['controlport'] = '3306';

$cfg['Servers'][$i]['controluser'] = $dbuser;

$cfg['Servers'][$i]['controlpass'] = $dbpass;

검색 pma -> 추천항목으로 입력.


/**

 * Database used for Relation, Bookmark and PDF Features

 * (see sql/create_tables.sql)

 *   - leave blank for no support

 *     SUGGESTED: 'phpmyadmin'

 *

 * @global string $cfg['Servers'][$i]['pmadb']

 */

$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';

$cfg['Servers'][$i]['pmadb'] = $dbname;


/**

 * Bookmark table

 *   - leave blank for no bookmark support

 *     SUGGESTED: 'pma__bookmark'

 *

 * @global string $cfg['Servers'][$i]['bookmarktable']

 */

$cfg['Servers'][$i]['bookmarktable'] = 'pma__bookmark';


/**

 * table to describe the relation between links (see doc)

 *   - leave blank for no relation-links support

 *     SUGGESTED: 'pma__relation'

 *

 * @global string $cfg['Servers'][$i]['relation']

 */

$cfg['Servers'][$i]['relation'] = 'pma__relation';


/**

 * table to describe the display fields

 *   - leave blank for no display fields support

 *     SUGGESTED: 'pma__table_info'

 *

 * @global string $cfg['Servers'][$i]['table_info']

 */

$cfg['Servers'][$i]['table_info'] = 'pma__table_info';


/**

 * table to describe the tables position for the designer and PDF schema

 *   - leave blank for no PDF schema support

 *     SUGGESTED: 'pma__table_coords'

 *

 * @global string $cfg['Servers'][$i]['table_coords']

 */

$cfg['Servers'][$i]['table_coords'] = 'pma__table_coords';


/**

 * table to describe pages of relationpdf

 *   - leave blank if you don't want to use this

 *     SUGGESTED: 'pma__pdf_pages'

 *

 * @global string $cfg['Servers'][$i]['pdf_pages']

 */

$cfg['Servers'][$i]['pdf_pages'] = 'pma__pdf_pages';


/**

 * table to store column information

 *   - leave blank for no column comments/mime types

 *     SUGGESTED: 'pma__column_info'

 *

 * @global string $cfg['Servers'][$i]['column_info']

 */

$cfg['Servers'][$i]['column_info'] = 'pma__column_info';


/**

 * table to store SQL history

 *   - leave blank for no SQL query history

 *     SUGGESTED: 'pma__history'

 *

 * @global string $cfg['Servers'][$i]['history']

 */

$cfg['Servers'][$i]['history'] = 'pma__history';


/**

 * table to store recently used tables

 *   - leave blank for no "persistent" recently used tables

 *     SUGGESTED: 'pma__recent'

 */

$cfg['Servers'][$i]['recent'] = 'pma__recent';


/**

 * table to store favorite tables

 *   - leave blank for no favorite tables

 *     SUGGESTED: 'pma__favorite'

 */

$cfg['Servers'][$i]['favorite'] = 'pma__favorite';


/**

 * table to store UI preferences for tables

 *   - leave blank for no "persistent" UI preferences

 *     SUGGESTED: 'pma__table_uiprefs'

 */

$cfg['Servers'][$i]['table_uiprefs'] = 'pma__table_uiprefs';


/**

 * table to store SQL tracking

 *   - leave blank for no SQL tracking

 *     SUGGESTED: 'pma__tracking'

 *

 * @global string $cfg['Servers'][$i]['tracking']

 */

$cfg['Servers'][$i]['tracking'] = 'pma__tracking';


/**

 * table to store user preferences

 *   - leave blank to disable server storage

 *     SUGGESTED: 'pma__userconfig'

 *

 * @global string $cfg['Servers'][$i]['userconfig']

 */

$cfg['Servers'][$i]['userconfig'] = 'pma__userconfig';


/**

 * table to store users and their assignment to user groups

 *   - leave blank to disable configurable menus feature

 *     SUGGESTED: 'pma__users'

 *

 * @global string $cfg['Servers'][$i]['users']

 */

$cfg['Servers'][$i]['users'] = 'pma__users';


/**

 * table to store allowed menu items for each user group

 *   - leave blank to disable configurable menus feature

 *     SUGGESTED: 'pma__usergroups'

 *

 * @global string $cfg['Servers'][$i]['usergroups']

 */

$cfg['Servers'][$i]['usergroups'] = 'pma__usergroups';


/**

 * table to store information about item hidden from navigation tree

 *   - leave blank to disable hide/show navigation items feature

 *     SUGGESTED: 'pma__navigationhiding'

 *

 * @global string $cfg['Servers'][$i]['navigationhiding']

 */

$cfg['Servers'][$i]['navigationhiding'] = 'pma__navigationhiding';


/**

 * table to store information about saved searches from query-by-example on a db

 *   - leave blank to disable saved searches feature

 *     SUGGESTED: 'pma__savedsearches'

 *

 * @global string $cfg['Servers'][$i]['savedsearches']

 */

$cfg['Servers'][$i]['savedsearches'] = 'pma__savedsearches';


/**

 * table to store central list of columns per database

 *   - leave blank to disable central list of columns feature

 *     SUGGESTED: 'pma__central_columns'

 *

 * @global string $cfg['Servers'][$i]['central_columns']

 */

$cfg['Servers'][$i]['central_columns'] = 'pma__central_columns';


/**

 * table to store designer settings

 *   - leave blank to disable the storage of designer settings

 *     SUGGESTED: 'pma__designer_settings'

 *

 * @global string $cfg['Servers'][$i]['designer_settings']

 */

$cfg['Servers'][$i]['designer_settings'] = 'pma__designer_settings';


/**

 * table to store export templates

 *   - leave blank to disable saved searches feature

 *     SUGGESTED: 'pma__export_templates'

 *

 * @global string $cfg['Servers'][$i]['export_templates']

 */

$cfg['Servers'][$i]['export_templates'] = 'pma__export_templates';

'Bitnami > phpMyAdmin' 카테고리의 다른 글

phpMyAdmin 설치시 자주쓰는 경고문 해결  (0) 2017.07.09

관련글 더보기