Installing MySQL on Linux/UNIX

You can download MySQL from the here. (https://www.mysql.com/downloads/)

Following way to install MySQL on a Linux system is via RPM. MySQL AB makes the following RPMs available for download on its website:

MySQL − 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– MySQL Devel Libraries and header files that come in handy when compiling other programs that use MySQL.

MySQL-shared − Shared libraries for the MySQL client.

MySQL-bench − Benchmark and performance testing tools for the MySQL database server.

Process for installing a MySQL on server:

  • Login into your system with root user.
  • Switching to the directory and containing the RPMs.
  • Install the MySQL database server by executing the following command
    • [root@host]# rpm -i MySQL-5.0.9-0.i386.rpm

The above command wills installing the MySQL server, creating a user of MySQL, creating necessary configuration, settings and start the MySQL server automatically.

You can find all the MySQL related binaries in /usr/bin and /usr/sbin. All the tables and databases will be shown in the /var/lib/mysql directory.

 

Leave a Reply

Your email address will not be published. Required fields are marked *