Tag Archives: administrator

How to install MySQL 5.1 on Ubuntu

 

# apt-get install mysql-client-5.1 mysql-client-core-5.1 mysql-common mysql-server-5.1 mysql-server-core-5.1 mysql-admin mysql-gui-tools-common mysql-query-browser

With this packages we install mysql client, mysql server and some administration tools.

Packages to install

Packages to install

Later, we will be asked to set up a root password:

Asking for root password

Asking for root password

Be sure to remember that password.

Once it is installed we can run MySQL Administrator to manage our recently installed server.

MySQL Administrator Connection

MySQL Administrator Connection

It’s highly recommended to create other user to work

Creating a new user

Creating a new user

With MySQL Administrator you also can manage backups or check server’s health for example.

And finally, with MySQL Query Browser you can que to your server; create new databases, insert values, sql queries, etc.

Creating a new database with Query Browser

Creating a new database with Query Browser