How do I uninstall Java 7 and later versions on my Mac?

Following the steps listed will uninstall Oracle Java from your system using a Terminal.

Click on the Finder icon located in your dock
Click on Applications tab on sidebar
Click on the Utilities folder
Double-click on the Terminal icon
In the Terminal window, copy and paste the command:

sudo rm -fr /Library/Internet\ Plug-Ins/JavaAppletPlugin.plugin

https://www.java.com/en/download/help/mac_uninstall_java.xml

Password protect zip files in OS X

Password protect a zip file archive Creating a password protected zip file is easy in Mac OS X and does not require any add-ons or downloads. Instead, use the zip utility that is bundled with all Macs.

If you’re familiar with the command line, the syntax of the encrypted zip command is as follows:

zip -e [archive] [file]

For encrypting multiple files with a password, such as folder or an entire directory, the syntax would be as follows:

zip -er [archive] [folder]

If you’re not sure how to use that, read on to learn how to create zip archives encrypted with passwords. These encrypted zip files will maintain password protection across platforms, meaning you can send a protected zip file to a Windows user and they will still need to enter the password in order to view the contents.

Zip Password in Mac OS X

Set a Zip Password in Mac OS X

You can create password protected archives of files and folders:

Launch the Terminal from the Applications > Utilities folder

Type the following command:

zip -e archivename.zip filetoprotect.txt

Enter and verify the password – don’t forget this

The resulting archive, in this case named “archivename.zip”, is now encrypted with the password provided. The file that was encrypted, “filetoprotect.txt”, is now inaccessible without entering that password.

If you plan on compressing multiple files within a folder, you will want to slightly modify the command with the -er flag like so:

zip -er archive.zip /path/to/directory/

This is particularly important for encrypting zips of multiple files under OS X Mavericks.

Example: Zipping a Folder and Setting a Password

Here is an example of what this will look like from the command line, in this case we are compressing and password protecting the entire ‘Confidential’ folder located within the users /Documents directory, and the password protected zip is being placed on the users desktop for easy access:

$ zip -er ~/Desktop/encrypted.zip ~/Documents/Confidential/
Enter password:
Verify password:
adding: ~/Documents/Confidential/ (deflated 13%)

Notice the password will not display, this is normal behavior for the Terminal.

Notice that with a folder of multiple files, you will want to use the -er flag, the addition of the r indicates that zip will recursively compress and password protect all files in the folder.

Opening the Password Protected Zip

Despite being created at the command line, you do not need to unzip the file from the terminal, it can be expanded from the Mac OS X Finder or within Windows using standard unzipping apps. Just double click on the file, then enter the password, and it will decompress. You can also decompress the zip archive from the command line with:

unzip filename.zip

Here are some use cases for password protected zip archives:

Password protecting an individual file or directory

Sending a sensitive and encrypted file over an unencrypted network

Emailing confidential data to a Windows user

Adding an additional layer of security to a hidden folder

Password protecting your own backups, outside of Time Machine

While this can provide some protection on a per-file or folder basis, it’s always a good idea to password protect the Mac in general with a login requirement on system boot, wake from sleep, and waking from the screen saver.

CLI – List of all MySQL command

List of all MySQL commands:
Note that all text commands must be first on line and end with ‘;’

?         (\?) Synonym for `help'.
clear     (\c) Clear the current input statement.
connect   (\r) Reconnect to the server. Optional arguments are db and host.
delimiter (\d) Set statement delimiter.
edit      (\e) Edit command with $EDITOR.
ego       (\G) Send command to mysql server, display result vertically.
exit      (\q) Exit mysql. Same as quit.
go        (\g) Send command to mysql server.
help      (\h) Display this help.
nopager   (\n) Disable pager, print to stdout.
notee     (\t) Don't write into outfile.
pager     (\P) Set PAGER [to_pager]. Print the query results via PAGER.
print     (\p) Print current command.
prompt    (\R) Change your mysql prompt.
quit      (\q) Quit mysql.
rehash    (\#) Rebuild completion hash.
source    (\.) Execute an SQL script file. Takes a file name as an argument.
status    (\s) Get status information from the server.
system    (\!) Execute a system shell command.
tee       (\T) Set outfile [to_outfile]. Append everything into given outfile.
use       (\u) Use another database. Takes database name as argument.
charset   (\C) Switch to another charset. Might be needed for processing binlog with multi-byte charsets.
warnings  (\W) Show warnings after every statement.
nowarning (\w) Don't show warnings after every statement.