D.2. How to Create a Privileged Database Administrator

Oracle VDI requires the credentials of a privileged database administrator in order to create the Oracle VDI database on a remote database.

The following procedure describes how to create a privileged administrator.

For more information about MySQL user account management, refer to the MySQL Server Administration chapter of the MySQL Reference Manual.

  1. Use the MySQL command line tool to enter the MySQL interactive mode as root.

    # ./mysql --user=root
  2. Use the MySQL GRANT statement to create the privileged administrator.

    In the following example, a user is granted all privileges.

    mysql> GRANT ALL PRIVILEGES ON *.* TO '<user>'@'localhost' IDENTIFIED BY ' /
    <password>' WITH GRANT OPTION;
    mysql> GRANT ALL PRIVILEGES ON *.* TO '<user>'@'%' IDENTIFIED BY ' /
    <password>' WITH GRANT OPTION;
    mysql> GRANT ALL PRIVILEGES ON *.* TO '<user>'@'<localhost DNS name> /
    ' IDENTIFIED BY '<password>' WITH GRANT OPTION;

    In the following example, a user is granted a limited set of privileges that are sufficient to create the Oracle VDI database.

    mysql> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,ALTER ON *.* TO ' /
    <user>'@'%' IDENTIFIED BY '<password>' WITH GRANT OPTION;
    mysql> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,ALTER ON *.* TO '<user>'@' /
    <db-host-dns>' IDENTIFIED BY '<password>' WITH GRANT OPTION;

    Where <user> and <password> are the user name and password of the user account.