Misty-StixWhile I was busily seated by my workstation, I noticed that, through the window, the sun was shining accompanied by a dristle.
(photos taken using iPoo.4)
Surreal Friday Noon
Meanwhile at Work
My Setup
I’m another step closer to my dream workstation setup. We have here a Beats™ Studio and a wired cdr-king keyboard with built-in touchpad.
(photo taken using an iPoo.4)
Multiple MySQL Instances
I have seen a lot of versions of this in the web but I decided to create my own copy for ease of setup and simplicity.
First, download the file “mysql55rev.rar” as seen in this post then extract it somewhere in your harddrive.
Follow these steps:
note: extract-dir is the location which you extracted the archive
edit [extract-dir]\my.ini to match your prefernces
51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 | [client] port=3307 [mysql] default-character-set=utf8 # SERVER SECTION # ---------------------------------------------------------------------- # # The following options will be read by the MySQL Server. Make sure that # you have installed the server correctly (see above) so it reads this # file. # [mysqld] # The TCP/IP Port the MySQL Server will listen on port=3307 |
73 74 75 76 77 | #Path to installation directory. All paths are usually resolved relative to this. basedir="[extract-dir]" #Path to the database root datadir="[extract-dir]/data" |
commands via the windows command line (cmd)
1 2 3 4 | [extract-dir]\bin\mysqld.exe --install "mysql3307" --defaults-file="[extract-dir]\my.ini" net start mysql3307 net stop mysql3307 [extract-dir]\bin\mysqld.exe --remove "mysql3307" |
Credentials needed to access the database are included in the archive.
(download: mysql55rev2)
