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.

If you want to set up MySQL in other platforms, check the following links:
And that's all, folks! Happy SQL'ing

Optimise Windows 10/11

How to optimise your Windows setup Just in case you need it. If you want a safe and conservative approach, just disable the background apps ...