Installing MySql to Ubuntu

Here are the steps that you need to follow:

1- Install the files that need to create a mysql database.

$sudo apt-get install mysql-server

2- Open the config file and comment out the line "bind-address = 127.0.0.1" as "#bind-address = 127.0.0.1". It makes your server available from internet.

$gksudo gedit /etc/mysql/my.cnf

3- Set the root password of the server and restart it.

$mysqladmin -u root password your-new-password

$sudo /etc/init.d/mysql restart

4- Install the "MYSql query browser" program

$sudo apt-get install mysql-query-browser

5- Program is installed in Applications > Programming, open it. Then type the necessary infos.

Server Hostname: 127.0.0.1
Username: root
Password: ******
Default Schema: (Empty)
Port : 3306