MariaDB Configuration: Difference between revisions

From NovaOrdis Knowledge Base
Jump to navigation Jump to search
No edit summary
No edit summary
Line 30: Line 30:
systemctl enable mariadb
systemctl enable mariadb
systemctl start mariadb
systemctl start mariadb
</pre>
<pre>
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/
</pre>
</pre>

Revision as of 04:02, 7 January 2016

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
Retrieved from "https://kb.novaordis.com/index.php?title=MariaDB_Configuration&oldid=788"