database Configuration File
Database configuration file
Location: /batm/config/database
Mandatory entries with default values
db_name=batm
db_username=batm
db_password=batm
db_host=127.0.0.1
db_port=3306
Optional DB query entries with default values
Available from 20210808 release.
Note: the two entries below are different for Master and Admin (CAS GUI)
db_connection_params_master=useUnicode=true&characterEncoding=UTF-8&characterSetResults=UTF-8&autoReconnect=true&useSSL=false
db_connection_params_admin=useUnicode=true&characterEncoding=UTF-8&characterSetResults=UTF-8&autoReconnect=true&serverTimezone=UTC&useCursorFetch=true&enabledTLSProtocols=TLSv1,TLSv1.1,TLSv1.2,TLSv1.3
You can specify these entries when you need to provide different or additional query (connection URL) parameters (e.g. SSL settings).
Don’t change the value in standalone.xml
’s <connection-url>
tag, use this config file instead.
MySQL Command Line Options
When in a need to customize mysql
command line options (e.g. in batm-manage backup/restore command) please refer to MySQL :: MySQL 5.7 Reference Manual :: 4.2.2.2 Using Option Files to use Global options to define your custom parameters.
Available options: MySQL :: MySQL 5.7 Reference Manual :: 4.2.3 Command Options for Connecting to the Server
Root passwords
The MySQL root password is required for database restores. Ubuntu (by default) doesn’t set a password for the MySQL “root” user during installation. The schema used by MySQL is not as insecure as you might think, but it could still be hardened nonetheless. A missing root password may cause issues during restores, depending upon the version you use.
The MySQL “root” user and your Ubuntu “root” user passwords are not the same thing.
Creating a root password is recommended for improved security.
If you currently don’t have a root password:
mysql -u root -e "ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'rootpass'; FLUSH PRIVILEGES;"
replace
rootpass
with any memorable root password.
If you have a root password and wish to change it:
replace
rootpass
with any memorable root password, thenenter the old password when requested.
If you’ve lost or forgotten your old root password, please refer to this excellent article from Digital Ocean:
How To Reset Your MySQL or MariaDB Root Password on Ubuntu 20.04 | DigitalOcean
remember, you are using MySQL (not MariaDB). Follow the correct instructions.
How to examine your password configuration:
To test if you have a MySQL password set, use:
This is an example of an unset (or improperly set) password:
the insecure authorization plugin is using “auth_socket” (which is native to newer Ubuntu versions and the default on DO droplets).
This is what should happen:
Enter the (now required) password, and then type (at the mysql prompt):
Perfect.
Copyright © 2020-2024 General Bytes USA LLC