Understand the default MySQL configuration

Default MySQL user accounts and privileges

The grant tables define the initial MySQL user accounts and their access privileges. The default configuration consists of:

  • A privileged account with a username of root. The root user has remote access to the database.
  • An anonymous user without remote access to the database server. This user can only connect from the local machine and it is only intended for testing.
  • A test database only intended for testing.

Check our recommendations for a production server.

MySQL version

In order to see which MySQL version your system is running, execute the following command:

$ mysqld --version

MySQL port

The default port for MySQL is 3306.

MySQL configuration file

The MySQL configuration file is located at /opt/bitnami/mysql/conf/my.cnf, on the MySQL database server host.

The MySQL official documentation has more details about how to configure the MySQL database.

MySQL log file

The log-error file contains information indicating when mysqld was started and stopped and also any critical errors that occur while the server is running. If mysqld notices a table that needs to be automatically checked or repaired, it writes a message to the error log.

Find it at /opt/bitnami/mysql/logs/mysqld.log, on the MySQL database server host.

Last modification February 9, 2023