...
...
Database configuration file
Location: /batm/config/database
...
Mandatory entries with default values
Code Block |
---|
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.
...
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 https://dev.mysql.com/doc/refman/5.7/en/option-files.html to use Global options to define your custom parameters.
Available options: https://dev.mysql.com/doc/refman/5.7/en/connection-options.html
...
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:
Code Block |
---|
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:
Code Block |
---|
mysql -u root -p -e "ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'rootpass'; FLUSH PRIVILEGES;" |
...
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:
...
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:
Code Block |
---|
mysql -u root -p |
...