Changes between Version 7 and Version 8 of howto/PHP


Ignore:
Timestamp:
Jan 7, 2015, 12:17:01 AM (10 years ago)
Author:
magill@…
Comment:

upd

Legend:

Unmodified
Added
Removed
Modified

  • howto/PHP

    v7 v8  
    9393A sample configuration file is installed at /opt/local/www/phpmyadmin/config.sample.inc.php.
    9494
    95 Consult the documentation at file:///opt/local/www/phpmyadmin/doc/html/config.html
    96 
    97 NOTE: This option expects ''"/opt/local/www/phpmyadmin/doc/html/"'' to be accessible under "<Document Root>." This can be accomplished by
     95Consult the documentation on your server at ''"/opt/local/www/phpmyadmin/doc/html/config.html"''
     96
     97NOTE: This option expects ''"/opt/local/www/phpmyadmin/doc/html"'' to be accessible under "<Document Root>." This can be accomplished by
    9898{{{
    9999$ cd <Document Root>
    … …  
    129129Details on "Using Authentication Modes" can be found at "''https://docs.phpmyadmin.net/en/latest/setup.html#using-authentication-modes''."
    130130
     131
    131132There is also an interactive setup, see http://www.phpmyadmin.net/documentation/#setup_script and the demo at http://www.phpmyadmin.net/documentation/setup/
    132133
    … …  
    147148}}}
    148149
    149 Then run this SQL to setup the pma 'controluser' (change the 'pmapass' to your password).
     150Next: create a file: ''mysql_phpMyAdmin_pmaSetup.sql'' - it is a one-time use scratch file so you can place it anywhere. (It is not included with the phpMyAdmin distribution.)
    150151{{{
    151152-- HOW TO USE THIS FILE (with MacPorts installation)
    … …  
    172173}}}
    173174
    174 Finally, edit the config file, at {{{/opt/local/www/phpmyadmin/config.inc.php}}}, so it's like this:
    175 {{{
    176 /* User for advanced features */
     175Then run this SQL to setup the pma 'controluser' (change the 'pmapass' to your password).
     176
     177Finally, verify that the config file, at ''/opt/local/www/phpmyadmin/config.inc.php'', is like this:\\
     178'''Note:''' The database name is ''pma underscore underscore'' -- two underscores!
     179{{{
     180/* User used to manipulate with storage */
     181// $cfg['Servers'][$i]['controlhost'] = '';                                                                                             
     182// $cfg['Servers'][$i]['controlport'] = '';   
    177183$cfg['Servers'][$i]['controluser'] = 'pma';
    178184$cfg['Servers'][$i]['controlpass'] = 'pmapass';
    179 /* Advanced phpMyAdmin features */
    180 $cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
    181 $cfg['Servers'][$i]['bookmarktable'] = 'pma__bookmark';
    182 $cfg['Servers'][$i]['relation'] = 'pma__relation';
    183 $cfg['Servers'][$i]['table_info'] = 'pma__table_info';
    184 $cfg['Servers'][$i]['table_coords'] = 'pma__table_coords';
    185 $cfg['Servers'][$i]['pdf_pages'] = 'pma__pdf_pages';
    186 $cfg['Servers'][$i]['column_info'] = 'pma__column_info';
    187 $cfg['Servers'][$i]['history'] = 'pma__history';
    188 $cfg['Servers'][$i]['designer_coords'] = 'pma__designer_coords';
    189 }}}
     185/* Storage database and tables */
     186// $cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';                                                                                         
     187// $cfg['Servers'][$i]['bookmarktable'] = 'pma__bookmark';                                                                             
     188// $cfg['Servers'][$i]['relation'] = 'pma__relation';                                                                                   
     189// $cfg['Servers'][$i]['table_info'] = 'pma__table_info';                                                                               
     190// $cfg['Servers'][$i]['table_coords'] = 'pma__table_coords';                                                                           
     191// $cfg['Servers'][$i]['pdf_pages'] = 'pma__pdf_pages';                                                                                 
     192// $cfg['Servers'][$i]['column_info'] = 'pma__column_info';                                                                             
     193// $cfg['Servers'][$i]['history'] = 'pma__history';                                                                                     
     194// $cfg['Servers'][$i]['table_uiprefs'] = 'pma__table_uiprefs';                                                                         
     195// $cfg['Servers'][$i]['tracking'] = 'pma__tracking';                                                                                   
     196// $cfg['Servers'][$i]['userconfig'] = 'pma__userconfig';                                                                               
     197// $cfg['Servers'][$i]['recent'] = 'pma__recent';                                                                                       
     198// $cfg['Servers'][$i]['favorite'] = 'pma__favorite';                                                                                   
     199// $cfg['Servers'][$i]['users'] = 'pma__users';                                                                                         
     200// $cfg['Servers'][$i]['usergroups'] = 'pma__usergroups';                                                                               
     201// $cfg['Servers'][$i]['navigationhiding'] = 'pma__navigationhiding';                                                                   
     202// $cfg['Servers'][$i]['savedsearches'] = 'pma__savedsearches';                                                                         
     203// $cfg['Servers'][$i]['central_columns'] = 'pma__central_columns';       
     204}}}