MariaDB Configuration

From NovaOrdis Knowledge Base
Revision as of 03:45, 7 January 2016 by Ovidiu (talk | contribs)
Jump to navigation Jump to search

Internal

Start at Boot

systemctl enable mariadb
systemctl start mariadb


Jan 6 19:37:13 now510 mariadb-prepare-db-dir: PLEASE REMEMBER TO SET A PASSWORD FOR THE MariaDB root USER ! Jan 6 19:37:13 now510 mariadb-prepare-db-dir: To do so, start the server, then issue the following commands: Jan 6 19:37:13 now510 mariadb-prepare-db-dir: '/usr/bin/mysqladmin' -u root password 'new-password' Jan 6 19:37:13 now510 mariadb-prepare-db-dir: '/usr/bin/mysqladmin' -u root -h now510.local password 'new-password' Jan 6 19:37:13 now510 mariadb-prepare-db-dir: Alternatively you can run: Jan 6 19:37:13 now510 mariadb-prepare-db-dir: '/usr/bin/mysql_secure_installation' Jan 6 19:37:13 now510 mariadb-prepare-db-dir: which will also give you the option of removing the test Jan 6 19:37:13 now510 mariadb-prepare-db-dir: databases and anonymous user created by default. This is Jan 6 19:37:13 now510 mariadb-prepare-db-dir: strongly recommended for production servers. Jan 6 19:37:13 now510 mariadb-prepare-db-dir: See the MariaDB Knowledgebase at http://mariadb.com/kb or the Jan 6 19:37:13 now510 mariadb-prepare-db-dir: MySQL manual for more instructions. Jan 6 19:37:13 now510 mariadb-prepare-db-dir: You can start the MariaDB daemon with: Jan 6 19:37:13 now510 mariadb-prepare-db-dir: cd '/usr' ; /usr/bin/mysqld_safe --datadir='/var/lib/mysql' Jan 6 19:37:13 now510 mariadb-prepare-db-dir: You can test the MariaDB daemon with mysql-test-run.pl Jan 6 19:37:13 now510 mariadb-prepare-db-dir: cd '/usr/mysql-test' ; perl mysql-test-run.pl Jan 6 19:37:13 now510 mariadb-prepare-db-dir: Please report any problems at http://mariadb.org/jira Jan 6 19:37:13 now510 mariadb-prepare-db-dir: The latest information about MariaDB is available at http://mariadb.org/. Jan 6 19:37:13 now510 mariadb-prepare-db-dir: You can find additional information about the MySQL part at: Jan 6 19:37:13 now510 mariadb-prepare-db-dir: http://dev.mysql.com Jan 6 19:37:13 now510 mariadb-prepare-db-dir: Support MariaDB development by buying support/new features from MariaDB Jan 6 19:37:13 now510 mariadb-prepare-db-dir: Corporation Ab. You can contact us about this at sales@mariadb.com. Jan 6 19:37:13 now510 mariadb-prepare-db-dir: Alternatively consider joining our community based development effort: Jan 6 19:37:13 now510 mariadb-prepare-db-dir: http://mariadb.com/kb/en/contributing-to-the-mariadb-project/