Changes between Initial Version and Version 1 of howto/MySQLWorkbench

Timestamp:

Jun 23, 2011, 8:54:39 AM (13 years ago)

Author:

BjarneDMat

Comment:

--

howto/MySQLWorkbench

@@ +1 @@
+[wiki:howto <- Back to the HOWTO section]
+
+= TODO: title =
+
+ * Audience: Intermediate Users
+ * Requires: MacPorts >=1.9.2
+
+== Introduction ==
+
+MySQL Workbench is a nice and advanced GUI frontend to administer MySQL databases. It's basically a GUI frontend to the mysql client and as such is similiar to the phpMyAdmin web-frontend .
+
+The MySQL Workbench program make some assumptions as to where files are under Mac OS X - specifically the program assumes that MySQL has been installed from the *.dmg downloaded from MySQL.
+
+This tutorial shows how to modify the default setting to get it to recognize the MacPorts install of MySQL5 as well as giving a very basic introduction in setting up a basic configuration that the postfixadmin port can use.
+
+Many web-interfaces / web-services require a basic setup in the MySQL database in order to do their own configuration stuff.
+
+== Installation ==
+
+=== 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 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)
+chown _mysql:_mysql /macports/etc/mysql5/my.cnf
+chmod 664 /macports/etc/mysql5/my.cnf
+}}}
+
+The following are the questions asked by mysql_secure_installation and the appropriate answers
+{{{
+Enter current password for root (enter for none):   # just hit [enter] as the database is new
+Set root password? [Y/n] Y                          # we do want the root user to have a password
+New password:                                       # enter at very secure password
+Re-enter new password: 
+Remove anonymous users? [Y/n] Y                     # anonymous users are not wanted !
+Disallow root login remotely? [Y/n] Y               # root can only log in from localhost
+Remove test database and access to it? [Y/n] Y      # we have no need for a test database
+Reload privilege tables now? [Y/n] Y                # make sure the above settings are applied
+}}}
+
+
+== Configuration ==
+
+=== Step 1: '''Install MySQL Workbench''' ===
+
+Download and install the MySQL Workbench program from [http://wb.mysql.com/ MySQL Workbench]
+
+=== Step 2: '''Modify the default settings in MySQL WorkBench''' ===
+
+
+== Optional Parts ==
+
+=== '''TODO: What else can be done?''' ===
+
+[wiki:howto <- Back to the HOWTO section]