Changed page "howto/MySQLWorkbench" by macintosh@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 .