adrianorsouza

Connecting to Vagrant VM MySQL database from host

This gist shows how to connect to your vagrant MySQL database from the host machine.

Change Address Binding from MySQL

• Connect to vagrant using vagrant ssh
• Edit file /etc/mysql/my.cnf:
  • Change parameter bind-address to 0.0.0.0 to allow all incoming connection attempts

adrianorsouza

Docker Commands, Help & Tips

Show commands & management commands

$ docker

Docker version info

adrianorsouza

#!/bin/bash
#
# DEFINE PROPER WRITABLE PERMISSIONS FOR LARAVEL PROJECT.
# Run this script in a fresh Laravel install.
#
# @author   Adriano Rosa (https://adrianorosa.com)
# @created: 2015-02-15 00:59:19
# @updated: 2021-01-28 14:19:16
# @updated: 2023-11-25 20:53:36
#

adrianorsouza

#!/bin/sh
#
# An example hook script to prepare a packed repository for use over
# dumb transports.
#
# To enable this hook, rename this file to "post-update".

echo "--initializing @@SITE_NAME@@ hook--"

git --git-dir @@GIT_DIR@@/.git --work-tree @@GIT_DIR@@ pull @@GIT_REMOTE_NAME@@ @@GIT_BRANCH_NAME@@

adrianorsouza

#!/usr/bin/env bash
#
# Script to make a new release of this project.
# 
# @author Adriano Rosa <https://adrianorosa.com>
# @date:  2020-07-24 14:47
# @link: https://gist.github.com/adrianorsouza/d970eecefa5c9c5db714d439587d1da6
#
# This bash script is a simple version of the npm package:
# `release-task` https://github.com/adrianorsouza/release-task.

adrianorsouza

BUILDING MOZJPEG ON LINUX

Link: https://calendar.perfplanet.com/2014/mozjpeg-3-0/

cd /usr/local/src

sudo curl -LO https://github.com/mozilla/mozjpeg/releases/download/v3.1/mozjpeg-3.1-release-source.tar.gz
sudo tar -xzvf mozjpeg-3.1-release-source.tar.gz

cd mozjpeg

adrianorsouza

.title {
    display: block;
    width: 100%;
    text-overflow: ellipsis;
    white-space: nowrap;
    pointer-events: auto;
    overflow: hidden;
}

adrianorsouza

Fix PHP 7.4 + MySQL 8 errors with server has gone away

PHP 7.4 is now released, and it comes with support for MySQL 8's new password authentication plugin: caching_sha2_password.

1. Connect to the database as root

Depending on your root username, you will be prompted to enter the password, a hostname, etc. By default, typing mysql in your server terminal should work. If you have trouble logging in, try mysql -p -u root, and entering the root password when asked.

2. Check existing authentication plugin:

Replace USERNAME and YOUR_PASSWORD with your application database username and the password.

adrianorsouza

MongoDB Cheat Sheet

Show All Databases

show dbs

Show Current Database

adrianorsouza

// https://davidwalsh.name/react-indeterminate
// To add the indeterminate property to the checkbox, I needed to take advantage of the ref attribute:

const { value, checked, indeterminate } = this.props

return render(
    <input
        type="checkbox"
        value={value}
        checked={checked}