Clive Walkden clivewalkden

## motd.sh
#!/bin/bash


# This motd.sh file is to be placed in /etc/profile.d/ to be executed upon
# successful login.
# -------------------------------------------------------------------------
# Copyright (c) 2018 Mike Centola (mikecentola.com)
#
# This program is free software: you can redistribute it and/or modify it under
# the terms of the GNU General Public License as published by the Free Software

## mysql-cheat-sheet.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                clivewalkden
                / mysql-cheat-sheet.md
            
            
              Last active
              June 10, 2020 23:16
                — forked from loonies/mysql-cheat-sheet.md
            
              
                MySql Cheat Sheet
              
          
    MySQL Cheat Sheet

TOC


General
Users, privileges
Table structure
Relations
Misc
Resources


## check-mysql.py
#!/usr/bin/python
#@author Bommarito Consulting, LLC; http://bommaritollc.com
#@date 2012-12-20

import subprocess
import smtplib
from email.mime.text import MIMEText

fromAddress = 'root@bommaritollc.com'
adminEmail = 'michael@bommaritollc.com'

## centos-7-package.sh
# Start the old vagrant
$ vagrant init centos-7
$ vagrant up

# You should see a message like:
#  Installing Virtualbox Guest Additions 5.0.20 - guest version is unknown

$ vagrant ssh
vagrantup:~$ sudo rpm -Uvh http://dl.fedoraproject.org/pub/epel/7/x86_64/e/epel-release-7-6.noarch.rpm
vagrantup:~$ sudo yum -y update
	#!/bin/bash


	# This motd.sh file is to be placed in /etc/profile.d/ to be executed upon
	# successful login.
	# -------------------------------------------------------------------------
	# Copyright (c) 2018 Mike Centola (mikecentola.com)
	#
	# This program is free software: you can redistribute it and/or modify it under
	# the terms of the GNU General Public License as published by the Free Software
	#!/usr/bin/python
	#@author Bommarito Consulting, LLC; http://bommaritollc.com
	#@date 2012-12-20

	import subprocess
	import smtplib
	from email.mime.text import MIMEText

	fromAddress = 'root@bommaritollc.com'
	adminEmail = 'michael@bommaritollc.com'
	# Start the old vagrant
	$ vagrant init centos-7
	$ vagrant up

	# You should see a message like:
	# Installing Virtualbox Guest Additions 5.0.20 - guest version is unknown

	$ vagrant ssh
	vagrantup:~$ sudo rpm -Uvh http://dl.fedoraproject.org/pub/epel/7/x86_64/e/epel-release-7-6.noarch.rpm
	vagrantup:~$ sudo yum -y update