| 240 | | }}} |
| 241 | | then make changes to that newly created php.ini file - ''/opt/local/etc/php56/php.ini'' |
| 242 | | |
| 243 | | = Step 3: Install phpMyAdmin = #phpmyadmin |
| 244 | | |
| 245 | | Use MacPorts to install the latest version of `phpMyAdmin`. |
| 246 | | |
| 247 | | {{{ |
| 248 | | $ sudo port install phpmyadmin |
| 249 | | }}} |
| 250 | | |
| 251 | | '''phpMyAdmin''' must be configured before it can be used. We do this in Step 5 below. |
| 252 | | |
| 253 | | = Step 4: Visit [[howto/MAMP]] for integration information = |
| 254 | | [[howto/MAMP]] must be consulted next for modifications to the Apache Configuration file to enable PHP and MySQL. |
| 255 | | |
| 256 | | = Trouble shoot = |
| 257 | | If by some reason the server still doesn't interpret PHP files (i.e. your web client tries to download them) it means the PHP configurations, as described at [[howto/MAMP#job1]], are not taking effect. |
| 258 | | Typically, the file ''"Include conf/extra/mod_php56.conf"'' - is not being processed; the file is missing; or the contents incorrect. That file contains the two "AddType" lines below. |
| 259 | | |
| 260 | | == Verify your config file again! == |
| 261 | | Verify any changes you have made to the config file: /opt/local/apache2/conf/httpd.conf - The most common problem is that the files in the "extra" directory are not "readable" |
| 262 | | All files in that directory should be "-rw-r--r--" |
| 263 | | |
| 264 | | {{{ |
| 265 | | $ /opt/local/apache2/bin/apachectl -t |
| 266 | | }}} |
| 267 | | This will return either "Syntax OK" or a specific line by line error listing. |
| 268 | | The typical error message: ''"Could not open configuration file /opt/local/apache2/conf/extra/httpd-mod_php56.conf: Permission denied"'' |
| 269 | | After correcting any config errors and saving the updated config file, simply run: |
| 270 | | {{{ |
| 271 | | $ sudo port unload apache2 |
| 272 | | }}} |
| 273 | | |
| 274 | | to stop apache (even though it is not running) and then start it using |
| 275 | | |
| 276 | | {{{ |
| 277 | | $ sudo port load apache2 |
| 278 | | }}} |
| 279 | | |
| 280 | | to start it again. |
| 281 | | |
| 282 | | If the above fails to cause php files to be interpreted, you can edit the Apache httpd.conf file itself again and search for the block: |
| 283 | | {{{ |
| 284 | | <IfModule mime_module> |
| 285 | | }}} |
| 286 | | |
| 287 | | And then add the following two lines before the end of that block. |
| 288 | | |
| 289 | | {{{ |
| 290 | | AddType application/x-httpd-php .php |
| 291 | | AddType application/x-httpd-php-source .phps |
| 292 | | }}} |
| 293 | | |
| 294 | | Then restart the server. |
| 295 | | |
| 296 | | As a last check, reboot and verify that everything has autostarted and is running (i.e., repeat the above tests). |
| 297 | | |
| 298 | | = Step 5: Configure phpMyAdmin = |
| 299 | | |
| 300 | | Edit the phpMyAdmin configuration file at ''/opt/local/www/phpmyadmin/config.inc.php''. \\ |
| 301 | | A sample configuration file is installed at /opt/local/www/phpmyadmin/config.sample.inc.php. |
| 302 | | |
| 303 | | Consult the documentation on your server at ''"/opt/local/www/phpmyadmin/doc/html/config.html"'' |
| 304 | | |
| 305 | | NOTE: This option expects ''"/opt/local/www/phpmyadmin/doc/html"'' to be accessible under "<Document Root>." This can be accomplished by |
| 306 | | {{{ |
| 307 | | $ cd <Document Root> |
| 308 | | $ ln -s /opt/local/www/phpmyadmin/doc/html/ phpmyadmin-doc |
| 309 | | }}} |
| 310 | | and then accessing ''http://<servername>/phpmyadmin-doc/'' |
| 311 | | |
| 312 | | Finally, you need to set up the `phpMyAdmin` configuration to access MySQL. |
| 313 | | |
| 314 | | First create the config.inc.php file: |
| 315 | | {{{ |
| 316 | | $ cd /opt/local/www/phpmyadmin/ |
| 317 | | $ sudo cp config.sample.inc.php config.inc.php |
| 318 | | }}} |
| 319 | | |
| 320 | | This will create a file `config.inc.php` in the `phpMyAdmin` directory. \\ |
| 321 | | Next, Edit that file, and locate the line: |
| 322 | | {{{ |
| 323 | | $cfg['Servers'][$i]['auth_type'] = 'config'; // Authentication method (config, http or cookie based)? - default is Cookie. |
| 324 | | }}} |
| 325 | | It will be right at the beginning in the section labeled: "/* Authentication type */" |
| 326 | | |
| 327 | | You will need to add the following two lines immediately after it. |
| 328 | | {{{ |
| 329 | | $cfg['Servers'][$i]['user'] = 'root'; // MySQL user |
| 330 | | $cfg['Servers'][$i]['password'] = ''; // MySQL password (only needed with auth_type = 'config') |
| 331 | | }}} |
| 332 | | |
| 333 | | Where ' ' is an empty password; fill it with your MySQL root password. \\ |
| 334 | | '''NOTE:''' You should change the 'auth_type' from 'config' to 'cookie' or 'httpd' so that you do not need to provide the password you selected for the MySQL root user in the 'password' option. |
| 335 | | (I.e. leaving it in plain text in this config file.) \\ |
| 336 | | However, as this is to simply get you "up-and-running," details for configuring those two authorization options are not given here. |
| 337 | | Details on "Using Authentication Modes" can be found at "''https://docs.phpmyadmin.net/en/latest/setup.html#using-authentication-modes''." |
| 338 | | |
| 339 | | |
| 340 | | There is also an interactive setup, see http://www.phpmyadmin.net/documentation/#setup_script and the demo at http://www.phpmyadmin.net/documentation/setup/ |
| 341 | | |
| 342 | | 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). |
| 343 | | |
| 344 | | |
| 345 | | = Step 6: Install pmadb = #pmadb |
| 346 | | Some consider the installation of pmadb "optional." \\ |
| 347 | | However, phpMyAdmin will flag the fact that it is missing and therefore certain features are not functional with the message: |
| 348 | | {{{ |
| 349 | | The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated. Find out why. |
| 350 | | Or alternately go to 'Operations' tab of any database to set it up there. |
| 351 | | }}} |
| 352 | | |
| 353 | | For additional features provided by pmadb (http://wiki.phpmyadmin.net/pma/pmadb), run |
| 354 | | {{{ |
| 355 | | $ mysql -u root -p < /opt/local/www/phpmyadmin/examples/create_tables.sql |
| 356 | | }}} |
| 357 | | |
| 358 | | 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.) |
| 359 | | {{{ |
| 360 | | -- HOW TO USE THIS FILE (with MacPorts installation) |
| 361 | | -- mysql -u root -p < /opt/local/www/phpmyadmin/examples/create_tables.sql |
| 362 | | -- mysq5 -u root -p < mysql_phpMyAdmin_pmaSetup.sql |
| 363 | | |
| 364 | | CREATE USER 'pma'@'localhost' IDENTIFIED BY 'pmapass'; |
| 365 | | |
| 366 | | GRANT USAGE ON mysql.* TO 'pma'@'localhost' IDENTIFIED BY 'pmapass'; |
| 367 | | GRANT SELECT ( |
| 368 | | Host, User, Select_priv, Insert_priv, Update_priv, Delete_priv, |
| 369 | | Create_priv, Drop_priv, Reload_priv, Shutdown_priv, Process_priv, |
| 370 | | File_priv, Grant_priv, References_priv, Index_priv, Alter_priv, |
| 371 | | Show_db_priv, Super_priv, Create_tmp_table_priv, Lock_tables_priv, |
| 372 | | Execute_priv, Repl_slave_priv, Repl_client_priv |
| 373 | | ) ON mysql.user TO 'pma'@'localhost'; |
| 374 | | GRANT SELECT ON mysql.db TO 'pma'@'localhost'; |
| 375 | | GRANT SELECT ON mysql.host TO 'pma'@'localhost'; |
| 376 | | GRANT SELECT (Host, Db, User, Table_name, Table_priv, Column_priv) |
| 377 | | ON mysql.tables_priv TO 'pma'@'localhost'; |
| 378 | | |
| 379 | | -- Privileges |
| 380 | | GRANT SELECT, INSERT, DELETE, UPDATE ON `phpmyadmin`.* TO 'pma'@localhost; |
| 381 | | }}} |
| 382 | | |
| 383 | | Then run this SQL to setup the pma 'controluser' (change the 'pmapass' to your password). |
| 384 | | |
| 385 | | Finally, verify that the config file, at ''/opt/local/www/phpmyadmin/config.inc.php'', is like this:\\ |
| 386 | | '''Note:''' The database name is ''pma underscore underscore'' -- two underscores! |
| 387 | | {{{ |
| 388 | | /* User used to manipulate with storage */ |
| 389 | | // $cfg['Servers'][$i]['controlhost'] = ''; |
| 390 | | // $cfg['Servers'][$i]['controlport'] = ''; |
| 391 | | $cfg['Servers'][$i]['controluser'] = 'pma'; |
| 392 | | $cfg['Servers'][$i]['controlpass'] = 'pmapass'; |
| 393 | | /* Storage database and tables */ |
| 394 | | // $cfg['Servers'][$i]['pmadb'] = 'phpmyadmin'; |
| 395 | | // $cfg['Servers'][$i]['bookmarktable'] = 'pma__bookmark'; |
| 396 | | // $cfg['Servers'][$i]['relation'] = 'pma__relation'; |
| 397 | | // $cfg['Servers'][$i]['table_info'] = 'pma__table_info'; |
| 398 | | // $cfg['Servers'][$i]['table_coords'] = 'pma__table_coords'; |
| 399 | | // $cfg['Servers'][$i]['pdf_pages'] = 'pma__pdf_pages'; |
| 400 | | // $cfg['Servers'][$i]['column_info'] = 'pma__column_info'; |
| 401 | | // $cfg['Servers'][$i]['history'] = 'pma__history'; |
| 402 | | // $cfg['Servers'][$i]['table_uiprefs'] = 'pma__table_uiprefs'; |
| 403 | | // $cfg['Servers'][$i]['tracking'] = 'pma__tracking'; |
| 404 | | // $cfg['Servers'][$i]['userconfig'] = 'pma__userconfig'; |
| 405 | | // $cfg['Servers'][$i]['recent'] = 'pma__recent'; |
| 406 | | // $cfg['Servers'][$i]['favorite'] = 'pma__favorite'; |
| 407 | | // $cfg['Servers'][$i]['users'] = 'pma__users'; |
| 408 | | // $cfg['Servers'][$i]['usergroups'] = 'pma__usergroups'; |
| 409 | | // $cfg['Servers'][$i]['navigationhiding'] = 'pma__navigationhiding'; |
| 410 | | // $cfg['Servers'][$i]['savedsearches'] = 'pma__savedsearches'; |
| 411 | | // $cfg['Servers'][$i]['central_columns'] = 'pma__central_columns'; |
| 412 | | }}} |
