Changes between Version 5 and Version 6 of howto/MySQLWorkbench

Timestamp:

Jun 24, 2011, 2:12:24 AM (13 years ago)

Author:

BjarneDMat

Comment:

--

howto/MySQLWorkbench

@@ -5 +5 @@
  * 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)
 
 {{{
@@ -33 +36 @@
 
 {{{
-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
 }}}