Changes between Version 53 and Version 54 of howto/MAMP
- Timestamp:
- Apr 8, 2010, 9:57:27 PM (15 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
howto/MAMP
v53 v54 391 391 There is also an interactive setup, see http://www.phpmyadmin.net/documentation/#setup_script and the demo at http://www.phpmyadmin.net/documentation/setup/ 392 392 393 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). 394 395 396 ==== Optional pmadb ==== #phpMyAdmin_pmadb 397 393 398 For additional features provided by pmadb (http://wiki.phpmyadmin.net/pma/pmadb), run 394 run this SQL to setup the pma 'controluser' (change the 'pmapass' to your password). 395 {{{ 396 $ mkdir ~/tmp && cd tmp 397 $ cat > tmp.sql 399 {{{ 400 mysql5 -u root -p < /opt/local/www/phpmyadmin/scripts/create_tables.sql 401 }}} 402 403 Then run this SQL to setup the pma 'controluser' (change the 'pmapass' to your password). 404 {{{ 405 -- HOW TO USE THIS FILE (with MacPorts installation) 406 -- mysql5 -u root -p < /opt/local/www/phpmyadmin/scripts/create_tables.sql 407 -- mysql5 -u root -p < mysql_phpMyAdmin_pmaSetup.sql 408 409 CREATE USER 'pma'@'localhost' IDENTIFIED BY 'pmapass'; 410 398 411 GRANT USAGE ON mysql.* TO 'pma'@'localhost' IDENTIFIED BY 'pmapass'; 399 412 GRANT SELECT ( … … 408 421 GRANT SELECT (Host, Db, User, Table_name, Table_priv, Column_priv) 409 422 ON mysql.tables_priv TO 'pma'@'localhost'; 410 -- 411 -- [Hit CNT-D] 412 -- 413 $ mysql5 -u root -p < tmp.sql 414 }}} 415 416 Then setup all the tables for the pmadb features with: 417 {{{ 418 mysql5 -u root -p < /opt/local/www/phpmyadmin/scripts/create_tables.sql 419 }}} 420 421 422 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). 423 423 424 -- Privileges 425 GRANT SELECT, INSERT, DELETE, UPDATE ON `phpmyadmin`.* TO 'pma'@localhost; 426 }}} 427 428 Finally, edit the config file, at {{{/opt/local/www/phpmyadmin/config.inc.php}}}, so it's like this: 429 {{{ 430 /* User for advanced features */ 431 $cfg['Servers'][$i]['controluser'] = 'pma'; 432 $cfg['Servers'][$i]['controlpass'] = 'pmapass'; 433 /* Advanced phpMyAdmin features */ 434 $cfg['Servers'][$i]['pmadb'] = 'phpmyadmin'; 435 $cfg['Servers'][$i]['bookmarktable'] = 'pma_bookmark'; 436 $cfg['Servers'][$i]['relation'] = 'pma_relation'; 437 $cfg['Servers'][$i]['table_info'] = 'pma_table_info'; 438 $cfg['Servers'][$i]['table_coords'] = 'pma_table_coords'; 439 $cfg['Servers'][$i]['pdf_pages'] = 'pma_pdf_pages'; 440 $cfg['Servers'][$i]['column_info'] = 'pma_column_info'; 441 $cfg['Servers'][$i]['history'] = 'pma_history'; 442 $cfg['Servers'][$i]['designer_coords'] = 'pma_designer_coords'; 443 }}} 424 444 425 445