Install CA Executive Insight on Linux › Install CA Executive Insight on Linux › Install MySQL on Linux › Configure MySQL on a Remote System

Configure MySQL on a Remote System

MySQL is typically expected to be installed on the same system where CA Executive Insight is installed. However, CA Executive Insight can connect to a remote MySQL installation. Configure the remote system before proceeding with the product installation.

Follow these steps:

On the remote system where MySQL is installed:

1. Open a command prompt or shell terminal.
2. Type

   mysql -uroot -p
   

   Provide the root password when prompted.

3. At the mysql> command prompt, execute the following commands:

   mysql> create user ‘<mysql_admin_user>’@'<ei_hostname>' identified by '< mysql_admin_password>';
   

   <mysql_admin_user>

   Specifies the administrator user; typically ‘root’, but it can be any other named user.

   <ei_hostname>

   Specifies the fully qualified host name or IP address of the system where the product is installed.

   < mysql_admin_password>

   Specified the password for this user.

   mysql> grant Grant option, Select, Insert, Update, Delete, Create, Drop, Reload, References, Index, Alter, Show Databases, Create Temporary Tables, Lock Tables, Execute, Create View, Show View, Create Routine, Alter Routine, Create User, Event, Trigger, Create Tablespace on *.* to ‘<mysql_admin_user>’@'<ei_hostname>'  with grant option;
   mysql> flush privileges;
   

When installing the product, give the above user and password when prompted for the MySQL credentials.