[MacPorts] howto/MySQLWorkbench modified

[MacPorts]

Changed page "howto/MySQLWorkbench" by macintosh at mathiesen.info from 90.184.12.220*
Page URL: <https://trac.macports.org/wiki/howto/MySQLWorkbench>
Diff URL: <https://trac.macports.org/wiki/howto/MySQLWorkbench?action=diff&version=6>
Revision 6

-------8<------8<------8<------8<------8<------8<------8<------8<--------
Index: howto/MySQLWorkbench
=========================================================================
--- howto/MySQLWorkbench (version: 5)
+++ howto/MySQLWorkbench (version: 6)
@@ -4,6 +4,9 @@
 
  * Audience: Intermediate Users
  * Requires: MacPorts >=1.9.2
+ * Created: 23/06-2011
+ * Revised: 24/06-2011 - modified install intructions
+ * Author: Bjarne D Mathiesen (macintosh _at_ mathiesen _dot_ info)
 
 {{{
 #!html
@@ -32,14 +35,18 @@
 === Step 1: '''Install and configure the mysql5 port''' ===
 
 {{{
-port install mysql5-server                          # intstall mysql5 from macports
-sudo -u _mysql mysql_install_db5                    # install the default databases
+port install mysql5-server                          # install mysql5 from macports
+cd /private/tmp                                     # the following command is executed as the _mysql user
+                                                    # + so we'll have to be somewhere in the file system where
+                                                    # + the _mysql user has write access
+mysql_install_db5 --user=_mysql                     # install the default databases
 port load mysql5                                    # start the mysqld server
 ps -axj | grep mysql                                # check that the mysql server is running
 /macports/lib/mysql5/bin/mysql_secure_installation  # secure the default installation
-echo '[mysqld]' >> /macports/etc/mysql5/my.cnf      # create a configuration file for mysql(d)
+echo '[mysqld]' >> /macports/etc/mysql5/my.cnf      # create a very basic configuration file for mysql(d)
 chown _mysql:_mysql /macports/etc/mysql5/my.cnf
-chmod 664 /macports/etc/mysql5/my.cnf
+chmod 664 /macports/etc/mysql5/my.cnf               # I'ld have preferred 660, but that conflicts with letting
+                                                    # MySQL Workbench read the file as the current user
 }}}
 
 The following are the questions asked by mysql_secure_installation and the appropriate answers

-------8<------8<------8<------8<------8<------8<------8<------8<--------

* The IP shown here might not mean anything if the user or the server is
behind a proxy.

--
MacPorts <http://www.macports.org/>
Ports system for Mac OS

This is an automated message. Someone at http://www.macports.org/ added your email
address to be notified of changes on howto/MySQLWorkbench. If it was not you, please
report to .