On Ubuntu 10.10(Maverick Meerkat) MySQL(server/client) Database Management System is recommended because it’s free,open source,fast and easy to install.MySQL is one of the most widely used DBMS specifically for web development.PHP+MySQL is a De Facto standard for creating dynamic websites.The most widely preferred cms(Content Management System) i.e wordpress(This blog is also running on wordpress) also uses PHP+MySQL to generate dynamic pages.
Installing MySQL in Ubuntu 10.10
#1. Open Synaptic Package Manager and search for ‘mysql’ or ‘mysql 5’ and select the packages(client and server) you need.
#2. Then click on Apply button to begin the installation procedure.In the middle of the installation you will be prompted for MySQL root password,set strong password for MySQL server.You will need this password for logging to your MySQL server account,with administrative power.
#3. Next installation will complete within a minute.You can start using your server/client now.Open terminal and Type the following command :
mysql -u user -h host –p //Then Enter the User’s Password
In this scenario,the user is ‘root’ and in host use ‘localhost’;so the actual command will be
mysql -u root -h localhost –p