Linux User Accounts

Not Oracle Cloud Infrastructure This topic does not apply to Oracle Cloud Infrastructure.

This section provides information about Linux user accounts that are provisioned on a MySQL Cloud Service deployment.

The MySQL Cloud Service compute node is provisioned with the following operating system user accounts.

User Description

opc

The system administrator account you use with the sudo command to perform operations that require root-user access.

oracle

The database administrator account you use to access the system and perform non-root, database administration tasks. A home directory, /u01/app/oracle/tools/home/oracle, is created for this user. This user cannot use the sudo command to perform operations that require root-user access.

Note:

MySQL Server, and all associated processes, run under the oracle user. To run the mysql command line, mysqladmin, and so on, you must be logged in as the oracle user.

root

The root administrator for the system. You do not have direct access to this account. To perform operations that require root-user access, use the sudo command as the opc user.

The following environment variables are created for the opc and oracle users.

Variable Description

HOME

The home directory of the user, either /home/opc or /u01/app/oracle/tools/home/oracle.

HOSTNAME

The host name of the compute node.

MYSQL_HOME

The MySQL Server home directory: /u01/bin/mysql. Set for the oracle user, only.

PATH

The paths to search for executables; set to include:

  • /sbin

  • /usr/sbin

  • /bin

  • /usr/bin

  • $MYSQL_HOME/bin

  • $HOME/bin

mysqladmin and mysql.server are available to the oracle user. To invoke the mysql command line, enter mysql on the command line as the oracle user. The oracle user is automatically logged in to the server.

SHELL

The default shell, /bin/bash.

USER

The user name, either opc or oracle.