MySQL is not easy to work via command line. The package has some built in tools but they are not the most user friendly. So we will install SQLyog which is a free MySQL tool that allows you to manage your databases effectively and efficiently.

As an alternative you may chose to install a web based database management utility called phpmyadmin

MySQL Management Step 1.
Download SQLyog and begin install

---

MySQL Management Step 2.

---

MySQL Management Step 3.
After accepting the license agreement you can set the install directory.

---

MySQL Management Step 4.
.

---

On the next page we will setup the management tool and create a new MySQL user.

MySQL skills

In a moment we will create a new MySQL database user. But first we need set up our new tool.

MySQL skills Step 1.
After starting SQLyog the first time you need to create a new connection.

---

MySQL skills Step 2.
Create a new connection and fill the Server information as follows. You have defined the root password during the installation of MySQL

---

MySQL skills Step 3.
The interface is quite friendly. You can find available databases on the left, a query editor on the top right and a result set browser on the bottom right.

---

MySQL skills Step 4.
Before we start playing with the tool, let's create a new user.
Select Tool -> User Manager -> Add User

---

MySQL skills Step 5.
Setup a user name, password and privileges as follows and save it.

---

MySQL skills Step 6.
Now you have created a new user with limited privileges. You can repeat the Step 1 and 2 to login as the new user.

---

We are now ready to take a look at a slection of editors.