Changes between Version 53 and Version 54 of howto/MAMP


Ignore:
Timestamp:
Apr 8, 2010, 9:57:27 PM (14 years ago)
Author:
dweber@…
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • howto/MAMP

    v53 v54  
    391391There is also an interactive setup, see http://www.phpmyadmin.net/documentation/#setup_script and the demo at http://www.phpmyadmin.net/documentation/setup/
    392392
     393To 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
    393398For 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{{{
     400mysql5 -u root -p < /opt/local/www/phpmyadmin/scripts/create_tables.sql
     401}}}
     402
     403Then 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
     409CREATE USER 'pma'@'localhost' IDENTIFIED BY 'pmapass';
     410
    398411GRANT USAGE ON mysql.* TO 'pma'@'localhost' IDENTIFIED BY 'pmapass';
    399412GRANT SELECT (
     
    408421GRANT SELECT (Host, Db, User, Table_name, Table_priv, Column_priv)
    409422    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
     425GRANT SELECT, INSERT, DELETE, UPDATE ON `phpmyadmin`.* TO 'pma'@localhost;
     426}}}
     427
     428Finally, 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}}}
    424444
    425445