MySQL Wildcards

MySQL Wildcards

MySQL Aliases

MySQL Aliases

MySQL Data Types

MySQL Data Types

MySQL Interview Questions

MySQL Interview Questions and Answers


Installing the MySQL Database on Linux

Download MySQL

First you need to Download MySQL Server from MySQL Community Server and follow the below steps to install MySQL on Linux plateform.

MySQL Community Edition is a freely downloadable version of the world's most popular open source database that is supported by an active community of open source developers and enthusiasts.

Installing MySQL on Linux

Step 1:

Go to MySQL official website https://dev.mysql.com/downloads/mysql/

Step 2:

Select the right version for MySQL community server which you want.

Step 3:

Select the RPMs that you want to installed. You need to download three RPMs : MySQL Client, MySQL Server and MySQL Devel. MySQL Devel library is required if you are using PHP otherwise it is not required.

MySQL-server - The MySQL database server manages the databases and tables, controls user access and processes the SQL queries.

MySQL-client - MySQL client programs, which make it possible to connect to and interact with the server.

MySQL-devel - Libraries and header files that come in handy when compiling other programs that use MySQL.

Step 4:

Now begin installation the downloaded RPMs on your envoirnment.

Step 5:

First start installation of MySQL Client RPM on your plateform.

The above command takes care of installing the MySQL client and server, creating a user of MySQL, creating necessary configuration and starting the MySQL server automatically.

Step 6:

Now start installation of MySQL Server RPM on your plateform.

Step 7:

Now start MySQL Server and change the password.

Step 8:

Now login to MySQL Server by typing the password and press enter.

Step 9:

Once you login, start installation of MySQL Devel RPM on your plateform.

Verify MySQL installation

Step 10:

Once you login into MySQL, it will appeared with a mysql> prompt. Now, you are connected to the MySQL server and you can execute all the SQL command at mysql> prompt as follows: