[MacPorts] howto/PHP modified

[MacPorts]

Page "howto/PHP" was changed by magill at mac.com
Diff URL: <https://trac.macports.org/wiki/howto/PHP?action=diff&version=8>
Revision 8
Comment: upd
Changes:
-------8<------8<------8<------8<------8<------8<------8<------8<--------
Index: howto/PHP
=========================================================================
--- howto/PHP (version: 7)
+++ howto/PHP (version: 8)
@@ -92,9 +92,9 @@
 Edit the phpMyAdmin configuration file at ''/opt/local/www/phpmyadmin/config.inc.php''. \\
 A sample configuration file is installed at /opt/local/www/phpmyadmin/config.sample.inc.php.
 
-Consult the documentation at file:///opt/local/www/phpmyadmin/doc/html/config.html
-
-NOTE: This option expects ''"/opt/local/www/phpmyadmin/doc/html/"'' to be accessible under "<Document Root>." This can be accomplished by
+Consult the documentation on your server at ''"/opt/local/www/phpmyadmin/doc/html/config.html"''
+
+NOTE: This option expects ''"/opt/local/www/phpmyadmin/doc/html"'' to be accessible under "<Document Root>." This can be accomplished by
 {{{
 $ cd <Document Root>
 $ ln -s /opt/local/www/phpmyadmin/doc/html/ phpmyadmin-doc
@@ -128,6 +128,7 @@
 However, as this is to simply get you "up-and-running," details for configuring those two authorization options are not given here.
 Details on "Using Authentication Modes" can be found at "''https://docs.phpmyadmin.net/en/latest/setup.html#using-authentication-modes''."
 
+
 There is also an interactive setup, see http://www.phpmyadmin.net/documentation/#setup_script and the demo at http://www.phpmyadmin.net/documentation/setup/
 
 To check your phpMyAdmin installation, point your browser to http://localhost/phpmyadmin and verify that phpMyAdmin loads and can access your database (by providing a username and password, depending on the authentication method you selected).
@@ -146,7 +147,7 @@
 $ mysql -u root -p < /opt/local/www/phpmyadmin/examples/create_tables.sql
 }}}
 
-Then run this SQL to setup the pma 'controluser' (change the 'pmapass' to your password).
+Next: 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.)
 {{{
 -- HOW TO USE THIS FILE (with MacPorts installation)
 -- mysql -u root -p < /opt/local/www/phpmyadmin/examples/create_tables.sql
@@ -171,19 +172,33 @@
 GRANT SELECT, INSERT, DELETE, UPDATE ON `phpmyadmin`.* TO 'pma'@localhost;
 }}}
 
-Finally, edit the config file, at {{{/opt/local/www/phpmyadmin/config.inc.php}}}, so it's like this:
-{{{
-/* User for advanced features */
+Then run this SQL to setup the pma 'controluser' (change the 'pmapass' to your password).
+
+Finally, verify that the config file, at ''/opt/local/www/phpmyadmin/config.inc.php'', is like this:\\
+'''Note:''' The database name is ''pma underscore underscore'' -- two underscores!
+{{{
+/* User used to manipulate with storage */
+// $cfg['Servers'][$i]['controlhost'] = '';                                                                                             
+// $cfg['Servers'][$i]['controlport'] = '';    
 $cfg['Servers'][$i]['controluser'] = 'pma';
 $cfg['Servers'][$i]['controlpass'] = 'pmapass';
-/* Advanced phpMyAdmin features */
-$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';
-}}}
+/* Storage database and tables */
+// $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]['table_uiprefs'] = 'pma__table_uiprefs';                                                                         
+// $cfg['Servers'][$i]['tracking'] = 'pma__tracking';                                                                                   
+// $cfg['Servers'][$i]['userconfig'] = 'pma__userconfig';                                                                               
+// $cfg['Servers'][$i]['recent'] = 'pma__recent';                                                                                       
+// $cfg['Servers'][$i]['favorite'] = 'pma__favorite';                                                                                   
+// $cfg['Servers'][$i]['users'] = 'pma__users';                                                                                         
+// $cfg['Servers'][$i]['usergroups'] = 'pma__usergroups';                                                                               
+// $cfg['Servers'][$i]['navigationhiding'] = 'pma__navigationhiding';                                                                   
+// $cfg['Servers'][$i]['savedsearches'] = 'pma__savedsearches';                                                                         
+// $cfg['Servers'][$i]['central_columns'] = 'pma__central_columns';       
+}}}
-------8<------8<------8<------8<------8<------8<------8<------8<--------

--
Page URL: <https://trac.macports.org/wiki/howto/PHP>
MacPorts <https://www.macports.org/>
Ports system for OS X

This is an automated message. Someone added your email address to be
notified of changes on 'howto/PHP' page.
If it was not you, please report to .