Changes between Version 10 and Version 11 of howto/PHP
- Timestamp:
- Jan 7, 2015, 2:47:42 AM (10 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
howto/PHP
v10 v11 129 129 Details on "Using Authentication Modes" can be found at "''https://docs.phpmyadmin.net/en/latest/setup.html#using-authentication-modes''." 130 130 131 132 There is also an interactive setup, see http://www.phpmyadmin.net/documentation/#setup_script and the demo at http://www.phpmyadmin.net/documentation/setup/133 134 131 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). 135 132 … … 137 134 = Step 6: Install pmadb = #pmadb 138 135 Some consider the installation of pmadb "optional." \\ 139 However, phpMyAdmin will flag the fact that it is missing and therefore certain features are not functional with the message:136 However, phpMyAdmin will flag the fact that it is missing and therefore certain features are not functional, with the message: 140 137 {{{ 141 138 The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated. Find out why. … … 143 140 }}} 144 141 145 For additional features provided by pmadb (http://wiki.phpmyadmin.net/pma/pmadb), run142 For additional features provided by pmadb (http://wiki.phpmyadmin.net/pma/pmadb), first run 146 143 {{{ 147 144 $ mysql -u root -p < /opt/local/www/phpmyadmin/examples/create_tables.sql 148 145 }}} 149 146 150 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.) 147 Next: create a file: ''mysql_phpMyAdmin_pmaSetup.sql'' - containing the following SQL code: (change the 'pmapass' to your password) 148 - this is a one-time use scratch file so you can place it anywhere and delete it after use. (It is not included with the phpMyAdmin distribution.) 149 151 150 {{{ 152 151 -- HOW TO USE THIS FILE (with MacPorts installation) 153 152 -- mysql -u root -p < /opt/local/www/phpmyadmin/examples/create_tables.sql 154 -- mysq 5-u root -p < mysql_phpMyAdmin_pmaSetup.sql153 -- mysql -u root -p < mysql_phpMyAdmin_pmaSetup.sql 155 154 156 155 CREATE USER 'pma'@'localhost' IDENTIFIED BY 'pmapass'; … … 173 172 }}} 174 173 175 Then run this SQL to setup the pma 'controluser' (change the 'pmapass' to your password).174 Then run this SQL to setup the pma 'controluser' 176 175 177 176 Finally, verify that the config file, at ''/opt/local/www/phpmyadmin/config.inc.php'', is like this:\\