How to install MySQL on redhat server

[sarg]

Hello,

Someone gave me a box set of rh7.3 for free so I may try linux. After I installed with gnome desktop I now realize I did not install MySQL. I want to now install it. Can I do it from the cd's or download rpm's?

thanks.

[cristobal]

What is the name of the box? Or is it a whitebox?
If its a white box you can try to cobvert it to RH9.0 and then use the Ruby software to load the GUI and also upload PHP and MySQL.

If its a Cobalt server then you may have to look for PKGs.

[allon]

Hey I found a site that shows you some basics

http://www.linuxshaman.com/

It looks uncompleted but at least the basics of install stuff and running the system is up. You may want to take a look at it.

[augustine]

You may want to take a look at this site
http://rpmfind.net//linux/RPM/redhat...49-3.i386.html

Its the RPM for the version 7.3 of RedHat.
Though I would suggest that you upgrade it to RH9.0

[sandman]

Here is an example for installing MySQL 3.22.25-1

For this installation you will need to install the following RPMs:

MySQL-3.22.25-1.i586.rpm
MySQL-client-3.22.25-1.i586.rpm
MySQL-bench-3.22.25-1.i586.rpm
MySQL-devel-3.22.25-1.i586.rpm
DBI-perl-bin-0.93-1.i386.rpm
mysql-DBI-perl-bin-1.825-1.i386.rpm


Also... the MySQL-bench RPM requires MySQL-DBI-perl-bin (not mysql-DBI-perl-bin). As it works fine when installed with nodeps I think there may be a problem with "case" in the src.rpm used to build the binaries. The functionality appears to be correct regardless.

[root@ntbox /root]# rpm -Uvh MySQL-3.22.25-1.i586.rpm
MySQL ##################################################
Creating db table
Creating host table
Creating user table
Creating func table
Creating tables_priv table
Creating columns_priv table


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.

The latest information about MySQL is available on the web at http://www.mysql.com

Starting MySQL daemon with databases from /var/lib/mysql
[root@ntbox /root]# /usr/bin/mysqladmin -u root xxxxx 'xxxxxxxx'
/usr/bin/mysqladmin: Unknown command: 'chasm1'
[root@ntbox /root]# /usr/bin/mysqladmin -u root password 'xxxxxxxx'

So, at this point you've setup the "root" user password for MySQL. There is a disconnect between the docs and the MySQL RPM because the documentation encourages the execution of a script called /usr/bin/mysqlinstalldb. This script is unnecessary because it is executed at the end of the RPM installation. The script mysqlinstalldb creates six tables (user, db, host, tables_priv, columns_priv and func) in the MySQL database.

The script also does the following things:

The MySQL root user is created as a superuser who can do anything. Connections must be made from the local host. Note: The initial root password is empty, so anyone can connect as root without a password and be granted all privileges.
An anonymous user is created that can do anything with databases that have a name of 'test' or starting with 'test_'. Connections must be made from the local host. This means any local user can connect and be treated as the anonymous user.
Other privileges are denied. For example, normal users can't use mysqladmin shutdown or mysqladmin processlist.
So... the warning given by the script:

AGAIN REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
This is done with:
/usr/bin/mysqladmin -u root password 'new-password'

NOTE: DO NOT MESS THIS UP. IF YOU DO MAKE A MISTAKE ISSUE AN "rpm -e MySQL" FOLLOWED BY "rm -Rf /var/lib/mysql" AND THEN REINSTALL MySQL.

The installation, all the way to a working set of "demo" tables, is complete after the mysqlinstalldb script has run for the first time, so essentially, for MySQL you install the RPMs and as long as they don't die on install you're done.

Your database should now working.