Changes between Version 5 and Version 6 of howto/MySQLWorkbench


Ignore:
Timestamp:
Jun 24, 2011, 2:12:24 AM (13 years ago)
Author:
BjarneDMat
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • howto/MySQLWorkbench

    v5 v6  
    55 * Audience: Intermediate Users
    66 * Requires: MacPorts >=1.9.2
     7 * Created: 23/06-2011
     8 * Revised: 24/06-2011 - modified install intructions
     9 * Author: Bjarne D Mathiesen (macintosh _at_ mathiesen _dot_ info)
    710
    811{{{
     
    3336
    3437{{{
    35 port install mysql5-server                          # intstall mysql5 from macports
    36 sudo -u _mysql mysql_install_db5                    # install the default databases
     38port install mysql5-server                          # install mysql5 from macports
     39cd /private/tmp                                     # the following command is executed as the _mysql user
     40                                                    # + so we'll have to be somewhere in the file system where
     41                                                    # + the _mysql user has write access
     42mysql_install_db5 --user=_mysql                     # install the default databases
    3743port load mysql5                                    # start the mysqld server
    3844ps -axj | grep mysql                                # check that the mysql server is running
    3945/macports/lib/mysql5/bin/mysql_secure_installation  # secure the default installation
    40 echo '[mysqld]' >> /macports/etc/mysql5/my.cnf      # create a configuration file for mysql(d)
     46echo '[mysqld]' >> /macports/etc/mysql5/my.cnf      # create a very basic configuration file for mysql(d)
    4147chown _mysql:_mysql /macports/etc/mysql5/my.cnf
    42 chmod 664 /macports/etc/mysql5/my.cnf
     48chmod 664 /macports/etc/mysql5/my.cnf               # I'ld have preferred 660, but that conflicts with letting
     49                                                    # MySQL Workbench read the file as the current user
    4350}}}
    4451