Articles, notes and random thoughts on Software Development and Technology
I’ve covered in previous posts why I wanted to Dockerize my site and move to containers, you can read about it in my other posts shared here. Having played with Docker for personal projects for several months at this point, I thought it was going to be easy, but ran into several issues and unexpected …
My WordPress blog that you’re reading right now is running on nginx and MySQL installed on a cheap OpenVZ VPS. I’ve been running on a $2.50 VPS from Virmach for the past 6 months or so and been very happy with the service. I spent a bunch of time tweaking the nginx and MySQL config params …
Download the Jira server install from here. Follow the steps here to download and add the JDBC driver to your Jira server. Download and copy the mysql connector jar to /opt/atlassian/jira/lib/ Chose the ‘set up myself’ option, and complete the form to point to your already installed MySQL db instance: Configure your install properties: On …
Continue reading “Setting up a local production Jira installation with MySQL”
mysql’s ‘select … into outfile …’ is an easy way to export the results of a query to a file, but to execute this command you need the additional FILE privilege. The privilege is not granted by default, even with ALL, e.g. grant ALL on exampledb.* to exampleuser; The ALL privilege does not include FILE, …
Continue reading “mysql ‘select … into outfile’ access denied”