MariaDB Configuration

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

Internal

Post-Install

mysql_secure_installation
Enter current password for root (enter for none): 
...
Set root password? [Y/n] Y
...
Remove anonymous users? [Y/n] Y
...
Disallow root login remotely? [Y/n] Y
...
Remove test database and access to it? [Y/n] Y
...
Reload privilege tables now? [Y/n] Y
...

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/