How to display Schemas Panel on Mysql Workbench

Sometimes, you have trouble with Schemas Panel that cannot be displayed when you run MySQLWorkbench. You can see "no object selected" message instead of Schemas Panel on Navigator Panel.

To fix this issue and get Schemas Panel back, I recommend instructions below:

1) Open Terminal.

2) Reset workbench setting and configurations like below:

cd ~/Library/Application\ Support/MySQL/Workbench/

rm wb_state.xml

rm wb_options.xml

3) Open MysqlWorkbench. On initial open after the fix above, you will wait a little bit, but then you see Schemas Panel on the left side!

How to install an additional java on MacOS?

Java 8 is already built on my Mac, but I also need Java 7 to run some projects properly. Addition to this, switching between these versions should be easy, because I may need to switch it based on a project I work on.

Actually, the fastest and right way is to install Java 7 and manage versions of Java via "homebrew". However, I don't know why, Oracle put Java 7 installer under the authentication. It needs username and password. Because of this, related installer cannot be found on homebrew repos.

Not the fastest way, but there is only one way left, MANUEL SETUP.
1) Uninstall jdk8:

sudo rm -rf /Library/Java/*
sudo rm -rf /Library/PreferencePanes/Java*
sudo rm -rf /Library/Internet\ Plug-Ins/Java*

2) Install jdk7:

You must have oracle account. Enter your username & password on Oracle Java 7 download page and download/install it.

3) Reinstall jdk8:

You don't need oracle account for this.

4) Prepare environment variables:

Add something below into .profile(.bash_profile) file on your home directory.

export JAVA_8_HOME=$(/usr/libexec/java_home -v1.8)
export JAVA_7_HOME=$(/usr/libexec/java_home -v1.7)

alias java7='export JAVA_HOME=$JAVA_7_HOME'
alias java8='export JAVA_HOME=$JAVA_8_HOME'

#default java8
export JAVA_HOME=$JAVA_8_HOME

5) Check the version of your java installed on your Mac.

References:

1. https://stackoverflow.com/a/26252993
2. https://github.com/caskroom/homebrew-cask/issues/9447
3. https://stackoverflow.com/a/30412014

Links of my journal paper and conference proceedings

My last paper "A Review of Security Concerns in Internet of Things" was accepted by Scientific Research Publishing to be published in one of its journals whose name is "Journal of Computer and Communications" in the past months. I hereby share the link of the paper and other conference proceedings that I wrote in the past:

.: E. Leloglu, "A Review of Security Concerns in Internet of Things", Journal of Computer and Communications, 5, 121-136. doi: 10.4236/jcc.2017.51010.

.: E. Leloglu, T. Ayav and B. Ergenc, "Coefficient-Based Exact Approach for Frequent Itemset Hiding", The Sixth International Conference on Information, Process, and Knowledge Management (eKNOW 2014), Barcelona, Spain, 2014. The link.

.: E. Leloglu, T. Ayav and B. G. Aslan, "A review of cloud deployment models for e-learning systems", 43rd Annual IEEE/IFIP International Conference on Dependable Systems and Networks (DSN), Budapest, Hungry, 2013, pp. 1-2. doi: 10.1109/DSN.2013.6575331

Why does not MySQL event run?

The event scheduler may be on OFF position.

.: SQL command below can be used to see if the event scheduler is ON or OFF;

SHOW PROCESSLIST;

If there is no line that has a process "Daemon" by user "event_scheduler", it means that the event scheduler is OFF and should be activated in order that events can run.

.: The event scheduler can be activated with the SQL command;

SET GLOBAL event_scheduler = ON;