How to install MySQL on Linux using the RPM file:

[ryan Member Find all posts View Profile Close ryan]

How to install MySQL on Linux using the RPM file:


1. Login to your Shell command prompt with super access.
2. Change to the directory that has the RPM download.
3. Type the following command at the prompt:
4. rpm -ivh "mysql_file_name.rpm"
RPMs if you've downloaded them.
Alternatively, you can install the RPMs through GnoRPM.
5. Now setting a password for the root user. Issue the following at the prompt.
mysqladmin -u root password mysqldata
where mysqldata is the password for the root. (Change this to anything you like).
6. Testing the program. Typing the following at the prompt starts the mysql client program.
mysql -u root -p
The system asks for the the password. Type the root password (mysqldata).
If you don't get the prompt for password, it might be because MySQL Server is not running. To start the server, change to /etc/rc.d/init.d/ directory and issue the command ./mysql start (or mysql start depending on the value of the PATH variable on your system). Now invoke mysql client program.
7. Once MySQL client is running, you should get the mysql> prompt. Type the following at this prompt:
show databases;
You should now get a display similar to:
+----------------+
| Database |
+----------------+
| mysql |
| test |
+----------------+
2 rows in set (0.00 sec)

[kilter Member Find all posts View Profile Close kilter]

Re: How to install MySQL on Linux using the RPM file:

First I would say to thankyou because the information you provide is very usefull for me and others. And I hope you will continue sharing now in coming days. In my openion Its good to see the MySQL 5x install procedure using RPMs. But I have a specific requirement to be implemented and I can’t see how to do that. (There's a different RPM covering a particular part of funcitonality: server, testsuite, client, libraries and headers etcetera. You can decide for yourself what suits you best.) Instead of the default “mysql” user and group we need to create a client specific user who owns the mysql installation. How can I specify that, assuming that I create the user and group before starting installation with the RPM.

Thanks