Tag Archives: WAMP

Jun
13
2011 How to enable Linked Tables in phpMyAdmin !
by Q under Software

0
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.

Jun
04
2011 phpMyAdmin access denied under Wamp Server
by Q under Software

0

How to solve #1045 – Access denied for user ‘root’@'localhost’ (using password: NO). For those who chose to add password to access MySQL and get the following error:

Welcome to phpMyAdmin

Error
MySQL said:

#1045 – Access denied for user ‘root’@'localhost’ (using password: NO)

phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.

The solution is:

  • go to c:\wamp\apps\phpmyadmin3.3.9\
  • open/edit [config.inc.php]
  • find line [$cfg['Servers'][$i]['password'] = ”;] and insert your password,  you should have something like [$cfg['Servers'][$i]['password'] = ‘MyPassword’;]
  • save and refresh http://localhost/phpmyadmin/ ,  you can restart WAMP (Restart All Service) if you want but is not really necessary