15.10. Appendix J: Granting Database Privileges

MySQL controls access to database privileges via a combination of username, password[13], and host. By default, the MySQL “root” user on the host where the MySQL server is running has full privileges to create, drop and alter databases on the server.

It is necessary to manually grant database privileges on the EKM database server to the EKM server when an existing or default MySQL database server is used.

The connection information that the EKM server needs to connect to the EKM database server is provided during installation, and includes the hostname of the EKM database server, the port number to connect on, and the MySQL username and password that the EKM server will use when connecting to the EKM database server.

The EKM database server must grant full database privileges to each EKM cluster node. Client connections are defined by username/password/host, and privileges are granted to client connections based on entries in an internal MySQL database that defines the privileges granted to matching client connections.

On the cluster database server, for each cluster node, grant full database permissions for client connections matching:

To grant full database privileges, follow the instructions below:

  1. On the EKM database server, start a MySQL client session on the MySQL database server.

    For an EKM database server set up using the ANSYS EKM Server product installation, a MySQL client session can be started by running the control script: EKMDB_ROOT/bin/mysql.(cmd|sh)

  2. Grant full database privileges to the connections specified in the instructions above. The example below demonstrates granting full database privileges to connections matching:

    username=root, password=root123, and hostname=hostname.yourdomain.com

    mysql> use mysql;
    Database changed
    
    mysql> GRANT ALL PRIVILEGES ON *.* TO root@hostname.yourdomain.com
      IDENTIFIED BY 'root123' WITH GRANT OPTION; 
    Query OK, 0 rows affected (0.00 sec) 
    
    mysql> flush privileges; 
    Query OK, 0 rows affected (0.00 sec)
    

    After executing all the necessary GRANT statements, you should execute the flush privileges statement once to enable the new privileges.

  3. Exit the MySQL client session.

Consult the MySQL Server documentation for more information about granting database privileges, including use of the wildcards.



[13] These usernames and passwords are MySQL account credentials, NOT operating system or network account credentials.


Release 18.2 - © ANSYS, Inc. All rights reserved.