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.
In order to see which MySQL version your system is running, execute the following command:
$ mysqld --version
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.