How To Install MySQL on Ubuntu 10.04 Lucid Lynx

MySQL is one of the most popular relational database systems which is widely used with PHP applications. It's relatively easy to set up and use. Here's a quick guide of how to install and configure MySQL in the Ubuntu 10.04 Lucid Lynx release.

1. Open terminal
2. Install MySQL by typing sudo aptitude install mysql-server. The installer will ask you for a root password. Using root user, however, is not the best practice. It's way better to give yourself permissions to create and use databases.
3. Open MySQL console by typing mysql -p -u root
4. Next, grant yourself all priviledges for localhost connections (replace 'kuba' with your user name and password with password of your preference): GRANT ALL PRIVILEGES ON *.* TO kuba@'localhost' IDENTIFIED BY 'my$ecret';
5.  Now you can create MySQL databases without the need of using root account: mysqladmin -p create wordpress

You can either use Synaptic Package Manager for installing MySQL on Ubuntu 10.04 Lucid Lynx, here the step by step.

1. Open Synaptic Package Manager from System - Administration - Synaptic Package Manager. Enter your password(Ubuntu login account) if it ask else,proceed to next step.
2. Search for mysql by using the Quick Search box(on Top Upper part of the window).
3. Mark the package’s box you want to install e.g my sql client ,server.
4. Click on Apply to begin the installation(Followed by downloading process).
5. After few minutes, when the download will complete,installation begins automatically.It will hardly takes couple of minutes.In middle of installation you will have to enter root password for MySQL server.Enter a strong password for that.

Source(s):
Zalas visit | license
Sudo Bits visit