KBEC-00427 - MariaDB. Ways to Login. Backup and Restore.

Summary

MariaDB strives to be the logical choice for database professionals looking for a robust, scalable, and reliable SQL server. To accomplish this, the MariaDB Foundation work closely and cooperatively with the larger community of users and developers in the true spirit of Free and open source software, and release software in a manner that balances predictability with reliability.

ElectricFlow ships with build-in MariaDB database. Running ElectricFlow on a single machine with the demo license is currently not recommended for a production environment.

Note: The Built-in (MariaDB) option is supported only for the built-in database that is installed by ElectricFlow. Any other MariaDB database is not supported; that is, you cannot install another MariaDB instance and use it with ElectricFlow. 

How to login

Default credentials are:

Login: root

Password: changeme

1. In order to log in with console, you should use following command:

/opt/electriccloud/electriccommander/mariadb/bin/mysql --defaults-file=/opt/electriccloud/electriccommander/conf/mariadb/mariadb.conf -u root -pchangeme

2. You can connect to MariaDB using third-party tools (e.g. Database Workbench):

a) In order to connect, you need to edit:

/opt/electriccloud/electriccommander/conf/mariadb/mariadb.conf 

Find the following line:

bind-address = 127.0.0.1

And change ip address to "0.0.0.0" or just comment the line with "#"

b) Log in with console and grant priveleges to user (e.g.):

MariaDB> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'changeme' WITH GRANT OPTION;
MariaDB> FLUSH PRIVILEGES;

c) Then you can register server and connect with Workbench (e.g.):

4124124124214.png

Backup and Restore

mysqldump performs a logical backup. It is the most flexible way to perform a backup and restore, and a good choice when the data size is relatively small. For large datasets, the backup file can be large, and the restore time lengthy.

Examples:

Backing up a single database:

mysqldump db_name > backup-file.sql

Restoring or loading the database:

mysql db_name < backup-file.sql

More details and options can be found at mysqldump page (mariadb.com)

Have more questions?

0 Comments

Please sign in to leave a comment.