Opening executable files from network even if is Local Area (Trusted Network) you get annoying [Open file - Security warning]. This message can be ovoid using following procedure:
- Start > Run > type [gpedit.msc] to open [Local Group Policy Editor]
- Local Group Policy Editor > User Configuration > Administrative Templates > Windows Compoenents > Attachment Manager
- open and modify [Inclusion list for low filestypes], when you enable this option under [Options] > [Specify low risk extensions] you need to insert files extension that you want to exclude from security warning.
“Failed to Open the Group Policy Object” Error Message Occurs When You Try to Open a Policy As a Domain Administrator
Resolution:
After fresh install of Wamp Server suite you may get the following message under phpMyAdmin v3.3.9. These are addional features of phpMyAmin. You do not need to worry about as they won’t affect your databases. Anyway if you want to enable those features or just get rid of the message follow this guide.
The additional features for working with linked tables have been deactivated. To find out why click here.
localhost |
| $cfg['Servers'][$i]['pmadb'] … |
not OK [ Documentation ] |
| $cfg['Servers'][$i]['relation'] … |
not OK [ Documentation ] |
| General relation features: Disabled |
|
|
| $cfg['Servers'][$i]['table_info'] … |
not OK [ Documentation ] |
| Display Features: Disabled |
|
|
| $cfg['Servers'][$i]['table_coords'] … |
not OK [ Documentation ] |
| $cfg['Servers'][$i]['pdf_pages'] … |
not OK [ Documentation ] |
| Creation of PDFs: Disabled |
|
|
| $cfg['Servers'][$i]['column_info'] … |
not OK [ Documentation ] |
| Displaying Column Comments: Disabled |
| Browser transformation: Disabled |
|
|
| $cfg['Servers'][$i]['bookmarktable'] … |
not OK [ Documentation ] |
| Bookmarked SQL query: Disabled |
|
|
| $cfg['Servers'][$i]['history'] … |
not OK [ Documentation ] |
| SQL history: Disabled |
|
|
| $cfg['Servers'][$i]['designer_coords'] … |
not OK [ Documentation ] |
| Designer: Disabled |
|
|
| $cfg['Servers'][$i]['tracking'] … |
not OK [ Documentation ] |
| Tracking: Disabled |
Resolution:
- Find and Run [create_tables.sql] or just copy/paste in phpMyAdmin > SQL, don’t worry about comments in *.sql script file as they would be ignored so just copy as it is.
- for Wamp Server instalation can be found [c:\wamp\apps\phpmyadmin3.3.9\scripts\]
- Create the user for [phpmyadmin] newly created database manually using phpMyAdmin > Privileges > Add new User or using this script
CREATE USER ‘pma’@'localhost’ IDENTIFIED BY ‘pmapass’;
GRANT SELECT, INSERT, UPDATE, DELETE ON phpmyadmin.* TO ‘pma’@'localhost’;
- Find and Edit [config.inc.php], you need to enable / add few lines as follows:
$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'] = ‘pma’;
$cfg['Servers'][$i]['controlpass'] = ‘pmapass’;
- Close browser if is already open to get proper refresh and open it again.