MySQL reserve user account details

book

Article ID: 100054076

calendar_today

Updated On:

Description

Additional reserved accounts information for MySQL

 During the MySQL installation and initialization process, MySQL creates user accounts that should be considered reserved.

 

Reserved Accounts for MySQL 5.7.x

  • 'root'@'localhost: Used for administrative purposes. This account has all the privileges and can perform any operation. This account name is not reserved, 

  • 'mysql.sys'@'localhost': Use of the mysql.sys account avoids problems that occur if a DBA renames or removes the root account. This account is locked so that it cannot be used for client connections.

  • 'mysql.session'@'localhost': mysql.session use internally by plugins to access the server. This account is locked so that it cannot be used for client connections.

 

Reserved Accounts for MySQL 8.0.x

  • 'root'@'localhost: Used for administrative purposes. This account has all the privileges, is a system account, and can perform any operation.

  • 'mysql.sys'@'localhost': Use of the mysql.sys account avoids problems that occur if a DBA renames or removes the root account. This account is locked so that it cannot be used for client connections.

  • 'mysql.session'@'localhost': mysql.session is used internally by plugins to access the server. This account is locked so that it cannot be used for client connections. The account is a system account.

  • 'mysql.infoschema'@'localhost': Use of the mysql.infoschema account avoids problems that occur if a DBA renames or removes the root account. This account is locked so that it cannot be used for client connections.

 

Issue/Introduction

MySQL reserve user account details