phpMyAdmin 경고문구 (linked Tables에서 작동하는 부가기능...)

mysql 에서 아래와 같은 에러가 발생되었습니다.

 

linked Tables에서 작동하는 부가기능이 사용되지 않습니다. 이유를 알려면 여기를 클릭하십시오 

 

 

 

APM 환경은 아래와 같습니다.

• WAMP Server 2.0
• Apache 2.0.63
• PHP 5.2.8
• MySQL 5.1.36

 

 

 

Step 1: Edit and run create_tables.sql

This sql file is included with phpMyAdmin, in a wamp installation it can be found at: 
\Install Directory\phpmyadmin\scripts\create_tables.sql

위 디렉토리의 sql 파일을 찾아서 실행, phpmyadmin 디비와 설정 테이블 작성함.

There are two sections at the top which are usually commented out – one to create a phpmyadmin database, and one to create a phpmyadmin user. I usually just create the database myself and I prefer to use the following command in the next step to create the user. So, after creating the database, I usually just run the file as it originally came.

저는 phpMyAdmin > 우측 SQL 버튼 > 파일의 sql 내용을 복사 해 넣고 실행했습니다.

 

Step 2: Create a control user (controluser):

You’re on your own if you used the script above to create your control user, and you probably know what you’re doing. If you don’t, however, I recommend these mysql commands:

CREATE USER 'phpmyadmin'@'localhost' IDENTIFIED BY 'pmapass';
GRANT SELECT, INSERT, UPDATE, DELETE ON phpmyadmin.* TO 'phpmyadmin'@'localhost';

유저를 만들고 권한을 줌.

저는 phpMyAdmin > 메인 좌상단 SQL > 첫번째줄 넣고 실행 , 두번째줄 넣고 실행 했습니다.

 

 

Step 3: Edit config.inc.php:

Add these lines to your config.inc.php file and then you should be good to go!

아래 내용을 설정파일에 넣어줌.

$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]['designer_coords'] = 'pma_designer_coords';
$cfg['Servers'][$i]['tracking'] = 'pma_tracking';

$cfg['Servers'][$i]['controluser']   = 'phpmyadmin';
$cfg['Servers'][$i]['controlpass']   = 'pmapass';

저는 [ $cfg['Servers'][$i]['controlpass'] = 'pmapass'; ] 이부분이 다르더라구요.

 

 

Step 4: 브라우저의 캐시및 쿠키를 모두 삭제한후 재접속. <-- 중요함.

If you’re getting the message “The additional features for working with linked tables have been deactivated. To find out why click here.” or something similar, it probably means you don’t have the pmadb, controluser, and/or controlpass set up correctly to corresponding users in the database.

If you’re getting a message saying  ”not OK [ Documentation ]” but the first line ($cfg['Servers'][$i]['pmadb']) says OK, you either need to adjust the table names, or overcome something more complex. For me, after I switched to Apache 2.0 from 2.2 it started working.

ps: After installing, I was getting this to work fine with firefox 3.5, however, it was a no-go on google chrome.

 

 

 

 

출처: http://techblog.willshouse.com/2009/08/16/enabling-linked-tables-in-phpmyadmin/

참고 : phpMyAdmin 경고문구 (linked Tables에서 작동하는 부가기능...) 해결