How to Install MySQL Server 5 on Ubuntu 10.10

I found the way to install MySQL Server 5 on Ubuntu. Currently I am using Ubuntu 10.10. This how you do it.

sudo apt-get install mysql-server

If you are running PHP you will also need to install the php module for mysql 5:

sudo apt-get install php5-mysql

To create a new database, use the mysqladmin command:

mysqladmin create

How to Sign in as ROOT in Ubuntu Terminal

You can sign in as ROOT in Ubuntu Terminal without password in the first time by typing

sudo bash

After that you can change the password for the ROOT by typing

sudo passwd root

And then you type the password. Don’t afraid when you type there is no character appears because it is the default. It is recording what you type.

If you’ve changed the password you can sign as ROOT by typing

su root

or

su

For further reading you can read Sudo Manual and SU Command in Wikipedia

How to Install Apache and PHP 5 on Ubuntu

I found this site when I search the way to install Apache as webserver and PHP5 on my Ubuntu 10.10.

sudo apt-get install apache2

sudo apt-get install php5

sudo apt-get install libapache2-mod-php5

sudo /etc/init.d/apache2 restart

One said that you don’t need to run sudo apt-get install libapache2-mod-php5 command because it is done with sudo apt-getinstall apache2.