Install MySQL on Linux

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

Install MySQL on Linux

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

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

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

Follow these steps:

Log in as root.
Enter the following command to list the MySQL packages installed on your system:
```
rpm -qa | grep -i mysql
```
If the results of this command show you have an existing installation of MySQL, remove the MySQL packages:
1. Enter the following command to remove the installed packages:
```
rpm -e packagename
```
  packagename
  
  Specifies the name of the package that you want to remove.
  
  Run the command for each package listed in Step 2.
  
  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).
Enter the following command to install the MySQL server:
```
rpm -i MySQL-server-advanced-5.5.8-1.rhel5.x86_64.rpm
```
Enter the following command to install the MySQL client:
```
rpm -i MySQL-client-advanced-5.5.8-1.rhel5.x86_64.rpm
```
Enter the following command to start the MySQL database:
```
/etc/init.d/mysql start
```
Enter the following command to create a password:
```
mysqladmin -u root password
```
You are prompted to enter a password.
Enter your password.
The password is masked.
Enter the following command to log in to the database with the new password:
```
mysql -h localhost -u root -p
```
You are prompted to enter a password.
Enter your password.
The password is masked.

Important! After installing the MySQL, and based on the number of business indicators; decide whether the MySQL default configuration needs to be updated or added. See Critical CA Executive Insight Sizing Information for sizing considerations.