I’ve been going through my lab and changing generic passwords to much stronger, randomly generated passwords for each service. One service posed a problem: VUM. I updated the ODBC Data Source but vCenter still reported
Read moreCategory: Databases
Setup MySQL Server on Ubuntu 16.04
Here’s a quick guide to setting up the popular database server MySQL on Ubuntu 16.04. Install MySQL Update repositories sudo apt-get update Install MySQL sudo apt-get install mysql-server Enter a root password when prompted
Read moreSetup phpMyAdmin on Ubuntu 16.04 with Nginx and a Remote MySQL Server
I’ve been rebuilding my lab recently, most notably breaking down my LXD stack into individual Ubuntu virtual machines for each service. One thing I always meant to do but never got around to figuring out
Read moreMagento Error: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘363624’ for key ‘PRIMARY’
Today I was setting up a Magento staging store. This is something I’ve done more times than I’d care to admit recently and as a result, have the process down to a fine art. However,
Read moreBlog: Merging MS SQL Server and MySql databases
For some time now, I’ve been running Microsoft Server 2012 with IIS and Microsoft Sql Server. I run a small photo upload service built in C# and asp.net that was once a university project (although
Read more