Install MySQL on Linux

Install CA Executive Insight › Performance Sizing › Install MySQL on Linux

Install MySQL on Linux

CA Executive Insight stores its data in a MySQL database. MySQL must be installed before you can install the product. You can install MySQL on the same system as CA Executive Insight or on a remote system.

Note: This procedure is only required for a new installation, not an upgrade installation.

Note: Before you install MySQL, uninstall any existing installations of MySQL and delete any existing files.

Follow these steps:

Log in as root.
To list the MySQL packages that are installed on your system, enter the following command:
```
rpm -qa | grep -i mysql
```
If the results of this command show that you have an existing installation of MySQL, remove the MySQL packages:
1. To remove the installed packages, enter the following command:
```
rpm -e packagename
```
  packagename
  
  Specifies the name of the package that you want to remove.
  
  Run the command for each package that is installed on your system.
  
  Note: You can forcefully remove a package by typing the following command:
```
rpm -e --allmatches packagename --nodeps
```
2. Remove the MySQL system schema files, which are located in the /var/lib/mysql/mysql directory. Delete this directory.
3. Remove the MySQL configuration file, which is located in the /etc/my.cnf (or other location that the user created).
To install the MySQL server, enter the following command:
```
rpm -i MySQL-server-advanced-5.5.8-1.rhel5.x86_64.rpm
```
To install the MySQL client, enter the following command:
```
rpm -i MySQL-client-advanced-5.5.8-1.rhel5.x86_64.rpm
```
To start the MySQL database, enter the following command:
```
/etc/init.d/mysql start
```
To create a password, enter the following command:
```
mysqladmin -u root password
```
You are prompted to enter a password.
Enter your password.
The password is masked.
To log in to the database with the new password, enter the following command:
```
mysql -h localhost -u root -p
```
You are prompted to enter a password.
Enter your password.
The password is masked.

Note: After you have installed MySQL, and based on the number of business indicators, decide whether to update or add to the MySQL default configuration. See Performance Sizing for sizing considerations.