MySQL Windows 10

MySQL on Windows 10

 a list of tiny gotchas

Firstly, MySQL works great out of the box!

However, I wanted to change the location of the data directory.  What should have been an easy Custom install option turned into a nightmare (this option may have disappeared in version 8.2).

linux platform notes and hints often do not apply to Windows

edit my.ini with notepad++ do not use Windows notepad something about ANSI vs. UTF-8 text!

changing the location of the data directory is a goose chase.

extended directory attributes a nightmare to get right  

datadir location has changed between MySQL 5.6 and 8.x

crash course in Windows services

 

Stack Overflow and searching is your friend:

Change existing datadir path

 

MySQL some settings

Impressions

Installed MySQL and MySQL Workbench on my Macbook Pro x86 and everything worked right out of the box!  Workbench is very useful and takes care of connections and settings that as a non-database person would have gotten in the way of getting work done.

Setting up

Timeouts

Increase connect and wait timeouts.

 

Grid view

To see results in Workbench make sure the middle pane in grid view is visible.

 

MySQL database and Workbench and MariaDB on MBP x86

Hardware

MacBook Pro early 2015 Intel, macos 12.x

Reason run a database on my laptop. 

 1. MySQL database and Workbench

Installs flawlessly; ready to go right from the installation.  As a noob, Workbench was a life saver.

 

2.  Maria db

This is another story.  10.1 -10.x are marked beta on macport.  They don't successfully install.  I did not try homebrew which mixes their binaries with the stock ones.  

 

Your best bet is going with the official Docker image which worked great and you get the most recent release 11.2.

 

 

How a little juju helped my Wordpress

quick install WP (wordpress) using juju charms

Help I have undead juju hanging around (even after restarting!)

getting rid of juju state

juju destroy-environment --force

sudo cleanup-juju

Resources

ubuntu 13.10: deploy wordpress and mysql with juju-local

Redeploying OMG!Ubuntu onto the cloud with juju

Installing and configuring Juju for LXC (Linux)

Remove Juju Local Environment Cleanly

Adventures with OpenSolaris 2010.03 and the DL380

I ordered up three 36GB U320 disks for the ol'serverbeast (DL380 G3). It lives in a closet now where the loud fan noise is bearable.

Whoa! OpenSolaris not too linuxy at all. Curious about the ZFS hoopla. Maybe look into zones.

My own OpenSolaris cheatsheet (some useful commands):
System, version???
uname -a
SunOS kestrel 5.11 snv_134 i86pc i386 i86pc Solaris

Using the package manager (there's a GUI, but my box is headless)

= = = AMP (Apache Mysql Php)= = =

add software repo:
sudo pkg set-authority -O http://pkg.opensolaris.org/webstack webstack.opensolaris.org
sudo pkg set-authority -O http://pkg.opensolaris.org/contrib contrib.opensolaris.org

look for the AMP (apache mysql php) package:
pkg search amp

install the AMP (apache mysql php) package:
sudo pkg install amp

Activate and start installed AMP
pfexec /usr/sbin/svccfg import /var/svc/manifest/network/http-apache22.xml
pfexec /usr/sbin/svccfg import /var/svc/manifest/application/database/mysql_51.xml

pfexec /usr/sbin/svcadm enable network/http
pfexec /usr/sbin/svcadm enable database/mysql:version_51

replace enable with disable to turn these services off.
more info.

VirtualBox OS X host / OpenSolaris 2010.03 guest is sucking down all the free memory I have.
Lets find out what's going on
df -k -F tmpfs and
echo "::memstat" | mdb -k

swap -l

Uggh; can't find anything.

Glassfish
Installing glassfish.
Using glassfish in production.

securing MAMP

I want to set up a web site for our school garden. I have a piece of high industrial art called a Mac G4 Cube that could serve this purpose well.

Since I am a parent I don't have a lot of time to configure apache, mysql and probably joomla (content management) and its too error prone to do it that way (easy Boris I'm not talking about you who do it all the time). I turn to MAMP.

But I need to secure MAMP to put it out on the actual net (not just my little home net). I'll walk you through it as soon as a I am finished zapping some turkey meatballs.


Resources:
http://www.leifohman.com/pgSamples/SecureWamp.aspx
= = = = = = = = = = = = = = = =