MySQL installation with RPM

rpm stands for Redhat Package Manager. It is a utility which makes it easy to add, remove, or update software from your system. Packages can then be distributed as .rpm files for the rpm utility to query and install. To find out about rpm, try typing "man rpm" on your command line to read the manual page.

MySQL is available as a set of .rpm files. They come as a set because MySQL exists as several different components. The first component is the mysql database server itself. This is the database program (also called a deamon) you run on your computer. Once this is running it can be accessed from anywhere. To access it and manage it you'll need the second component, the client programs. These are programs that allow you to connect to and interact with the database. Lastly, if you want to access the database using other programs, such as those written in Perl, you'll need the development libraries.

For example on the MySQL website you can find the following rpms:

MySQL-3.22.32-1.i386.rpm

The MySQL server

MySQL-client-3.22.32-1.i386.rpm

Client programs for accessing a MySQL server

MySQL-devel-3.22.32-1.i386.rpm

Libraries and header files. You'll need these if you plan to write or use your own programs with things like Perl's DBI for accessing the server. In fact you'll need this module to install DBI on your system later.

Once you've downloaded the rpm files (or located them in the RH7 distribution) you can use the rpm command to install them. (For a list of options to use with rpm you can try typing: rpm --help.) Here is an example of the output from using rpm to install MySQL on my machine:

[root@localhost Mysql]# rpm -i MySQL-3.22.32-1.i386.rpm Creating db table Creating host table Creating user table Creating func table Creating tables_priv table Creating columns_priv table PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! This is done with: /usr/bin/mysqladmin -u root password 'new-password' See the manual for more instructions. Please report any problems with the /usr/bin/mysqlbug script! The latest information about MySQL is available on the web at http://www.mysql.com Support MySQL by buying support/licenses at http://www.tcx.se/license.htmy. Starting mysqld daemon with databases from /var/lib/mysql [root@localhost Mysql]#

Now try setting the root password:

[root@zenith /var]# mysqladmin -u root password 'friday'

You can also try connecting to the server and issuing a command:

[root@zenith /var]# mysql -pfriday mysql> show databases; +----------+ | Database | +----------+ | mysql | | test | +----------+ 2 rows in set (0.00 sec) mysql>

Back to Nomad installation.