Friday, 15 July 2016

How to install MySQL Workbench in Ubuntu

Installing MySQL Workbench in Ubuntu is very straightforward, but not always easy to come across.
Hope this quick tutorial helps get the job done without wasting time.

Let us take the most direct approach, using the Terminal to install what we need in order to use MySQL Workbench.

sudo apt-get update sudo apt-get install mysql-server mysql-workbench -y

The above will ask you to type your (user) password. If you have not used the terminal much, be aware that nothing will appear on screen as you type your password. This is a security measure and it is normal.

When the download and installation of the two packages finish, you will be presented with the following screen:

Enter a password that you will easily remember. You may use your Ubuntu user password if you want, but bear in mind that this will be the root password for the MySQL server; this is a individual service and its password is independent from the rest of your Ubuntu system. So you could use any password you want, just make sure you do not forget it!

Now you can open the Workbench, using the search function of your desktop or by typing mysql-workbench in the Terminal.

Next we need to connect to the MySQL service so we can start using the Workbench. You should see a Local instance under MySQL Connections in the main Workbench initial window.

When you click on the Local instance icon/rectangle, it will ask you for the root password of the MySQL service that you set during the installation. If you do not want to enter the password every time, just save it to the key chain.

And that's all, folks! Happy SQL'ing

Friday, 8 July 2016

Tweaking Ubuntu

I have been playing around with the new LTS version of Ubuntu 16.04 and in my efforts to tweak it to my comfort, did the following:

sudo apt-get install synaptic unity-tweak-tool chromium-browser mc gnome-themes-standard ubuntu-restricted-extras vlc audacious -y

If you're into themes, you may want to have a look at the following resources:

http://www.noobslab.com/p/themes-icons.html
http://lmelinux.net/2016/03/31/adapta-another-beautiful-gtk-theme/
http://lmelinux.net/2016/04/25/apply-adapta-dark-theme-ubuntu-unity/

If you need programming/basic development tools:

sudo apt-get install build-essential default-jdk ruby python python3 geany geany-plugins vim -y

Other Sources:
https://help.ubuntu.com/community/RestrictedFormats
http://askubuntu.com/questions/56446/how-do-i-install-the-ubuntu-restricted-extras-package

Get back the command prompt in Windows 10

If you've updated your Windows 10 system to the Creators Update (or newer), you may have noticed that the contextual menu (shift+right c...