Installing MariaDB/MySQL system tables in '/var/lib/mysql/' ... OK To start mariadbd at boot time you have to copy support-files/mariadb.service to the right place for your system Two all-privilege accounts were created. One is root@localhost, it has no password, but you need to be system 'root' user to connect. Use, for example, sudo mariadb The second is root@localhost, it has no password either, but you need to be the system 'root' user to connect. After connecting you can set the password, if you would need to be able to connect as any of these users with a password and without sudo See the MariaDB Knowledgebase at https://mariadb.com/kb You can start the MariaDB daemon with: cd '/usr' ; /usr/bin/mariadbd-safe --datadir='/var/lib/mysql/' You can test the MariaDB daemon with mariadb-test-run.pl cd '/usr/share/mariadb/mariadb-test' ; perl mariadb-test-run.pl Please report any problems at https://mariadb.org/jira The latest information about MariaDB is available at https://mariadb.org/. Consider joining MariaDB's strong and vibrant community: https://mariadb.org/get-involved/ ++ TIMEOUT=120 ++ [[ ! -S /var/lib/mysql/mysql.sock ]] ++ [[ ! -S /var/run/mysqld/mysqld.sock ]] ++ [[ 120 -gt 0 ]] ++ let TIMEOUT-=1 ++ sleep 1 ++ mariadbd-safe --wsrep-new-cluster --skip-networking --wsrep-on=OFF --pid-file=/var/lib/mysql/mariadb.pid 260804 08:55:48 mysqld_safe Logging to '/var/log/kolla/mariadb/mariadb.log'. 260804 08:55:48 mysqld_safe Starting mariadbd daemon with databases from /var/lib/mysql/ ++ [[ ! -S /var/lib/mysql/mysql.sock ]] ++ [[ ! -S /var/run/mysqld/mysqld.sock ]] ++ [[ ! -f /var/lib/mysql/mariadb.pid ]] ++ sudo -E kolla_security_reset spawn mariadb-secure-installation NOTE: MariaDB is secure by default in Debian. Running this script is useless at best, and misleading at worst. This script will be removed in a future MariaDB release in Debian. Please read /usr/share/doc/mariadb-server/README.Debian.gz for details. Enter root user password or leave blank: Enter current password for root (enter for none): OK, successfully used password, moving on... Setting the root password or using the unix_socket ensures that nobody can log into the MariaDB root user without the proper authorisation. You already have your root account protected, so you can safely answer 'n'. Switch to unix_socket authentication [Y/n] n ... skipping. You already have your root account protected, so you can safely answer 'n'. Change the root password? [Y/n] y New password: Re-enter new password: Password updated successfully! Reloading privilege tables.. ... Success! By default, a MariaDB installation has an anonymous user, allowing anyone to log into MariaDB without having to have a user account created for them. This is intended only for testing, and to make the installation go a bit smoother. You should remove them before moving into a production environment. Remove anonymous users? [Y/n] y SQL executed without errors! The operation might have been successful, or it might have not done anything. Normally, root should only be allowed to connect from 'localhost'. This ensures that someone cannot guess at the root password from the network. Disallow root login remotely? [Y/n] n ... skipping. By default, MariaDB comes with a database named 'test' that anyone can access. This is also intended only for testing, and should be removed before moving into a production environment. Remove test database and access to it? [Y/n] y - Dropping test database... SQL executed without errors! The operation might have been successful, or it might have not done anything. - Removing privileges on test database... SQL executed without errors! The operation might have been successful, or it might have not done anything. Reloading the privilege tables will ensure that all changes made so far will take effect immediately. Reload privilege tables now? [Y/n] y ... Success! Cleaning up... All done! If you've completed all of the above steps, your MariaDB installation should now be secure. Thanks for using MariaDB! ++ set +o xtrace