2.4 Get a User Account and Required Privileges

By default, the DB System provides only one user account for the DB System administrator. To use the additional features of MySQL HeatWave Cluster for different purposes, you might to ask your DB System administrator to create a new user account for you.

Some privileges are granted to all user accounts by default, whereas for some features, you need to ask the DB System administrator to grant you the required additional privileges.

This topic provides links to relevant documentation to help you learn about the available and required privileges for using MySQL HeatWave and its features.

Before You Begin

1. Create a MySQL HeatWave DB System.

2. Provision a MySQL HeatWave Cluster.

Review the Available and Required Privileges

To learn about the available privileges, see Privileges Provided by MySQL and Default MySQL Privileges.

To review the privileges required to use the additional components of MySQL HeatWave that are included with MySQL HeatWave Cluster, see the following topics:

• Section 4.3.3, “MySQL HeatWave Lakehouse Privileges”

• Section 6.3, “MySQL HeatWave AutoML Privileges”

• Section 7.3, “MySQL HeatWave GenAI Roles and Privileges”

Create a User Account and Grant Privileges

To create a new user account, the DB System administrator can use the following statement:

mysql> CREATE USER Username IDENTIFIED BY 'Password';

For example:

mysql> CREATE USER appuser1 IDENTIFIED BY 'Pa$$w0rd';

This creates a new user account named appuser1 with the password Pa$$w0rd.

To grant a privilege, the DB System administrator can use the following command:

• To grant privileges on a particular schema:

  mysql> GRANT List_Of_Privileges ON DB_Name.* TO 'Username';

  For example:

  mysql> GRANT ALL ON demo_db.* TO 'appuser1';

  This grants all available privileges on the schema demo_db to the user account appuser1.

• To grant privileges on all schemas:

  mysql> GRANT List_Of_Privileges ON *.* TO 'Username';

  For example:

  mysql> GRANT SELECT, ALTER ON *.* TO 'appuser1';

  This grants the specified privileges, SELECT and ALTER, on all schemas to the user account appuser1.

What's Next

• Learn more about connecting to the MySQL HeatWave DB System.