Changes between Version 48 and Version 49 of howto/MAMP

Timestamp:

Apr 6, 2010, 11:42:39 PM (14 years ago)

Author:

dweber@…

Comment:

--

howto/MAMP

@@ -74 +74 @@
 Restart Apache using `sudo /opt/local/apache2/bin/apachectl -k restart` to make this change take effect. You can then view your personal pages by accessing http://localhost/~username/, where "username" is your Mac OS X account's short name.
 
-
 ==== Local Apache manual ==== #manual
 
@@ -90 +89 @@
 
 Restart Apache using `sudo /opt/local/apache2/bin/apachectl -k restart` to make this change take effect. You can then view the manual by accessing http://localhost/manual/.
+
+
+==== Secure Sockets (https) ==== #ssl
+
+This works for a development system (not recommended for production!).
+
+{{{
+openssl genrsa -des3 -out server.key 1024
+# [enter your passphrase, a simple password we will remove soon]
+openssl req -new -key server.key -out server.csr
+# [you can accept all the defaults, it does not matter, or customize it to your liking]
+openssl x509 -req -days 3650 -in server.csr -signkey server.key -out server.crt
+# [will ask for passphrase]
+cp server.key server.key.bak
+openssl rsa -in server.key.bak -out server.key
+# [passphrase needs to be typed]
+sudo cp server.crt /opt/local/apache2/conf/
+sudo cp server.key /opt/local/apache2/conf/
+}}}
+
+Then enable the following in {{{/opt/local/apache2/conf/httpd.conf}}}
+
+{{{
+LoadModule ssl_module modules/mod_ssl.so
+
+# Secure (SSL/TLS) connections
+Include conf/extra/httpd-ssl.conf
+}}}
+
+
 
 
@@ -319 +348 @@
 There is also an interactive setup, see http://www.phpmyadmin.net/documentation/#setup_script and the demo at http://www.phpmyadmin.net/documentation/setup/
 
+For additional features provided by pmadb (http://wiki.phpmyadmin.net/pma/pmadb), run 
+run this SQL to setup the pma 'controluser' (change the 'pmapass' to your password).
+{{{
+$ mkdir ~/tmp && cd tmp
+$ cat > tmp.sql
+GRANT USAGE ON mysql.* TO 'pma'@'localhost' IDENTIFIED BY 'pmapass';
+GRANT SELECT (
+    Host, User, Select_priv, Insert_priv, Update_priv, Delete_priv,
+    Create_priv, Drop_priv, Reload_priv, Shutdown_priv, Process_priv,
+    File_priv, Grant_priv, References_priv, Index_priv, Alter_priv,
+    Show_db_priv, Super_priv, Create_tmp_table_priv, Lock_tables_priv,
+    Execute_priv, Repl_slave_priv, Repl_client_priv
+    ) ON mysql.user TO 'pma'@'localhost';
+GRANT SELECT ON mysql.db TO 'pma'@'localhost';
+GRANT SELECT ON mysql.host TO 'pma'@'localhost';
+GRANT SELECT (Host, Db, User, Table_name, Table_priv, Column_priv)
+    ON mysql.tables_priv TO 'pma'@'localhost';
+--
+-- [Hit CNT-D]
+--
+$ mysql5 -u root -p < tmp.sql
+}}}
+
+Then setup all the tables for the pmadb features with:
+{{{
+mysql5 -u root -p < /opt/local/www/phpmyadmin/scripts/create_tables.sql
+}}}
+
+
 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).
 
+
+
+
 [wiki:howto <- Back to the HOWTO section]