MariaDB Configuration: Difference between revisions

From NovaOrdis Knowledge Base
Jump to navigation Jump to search
(Created page with "=Internal= * MariaDB =Start at Boot= <pre> systemctl enable mariadb systemctl start mariadb </pre>")
 
No edit summary
Line 9: Line 9:
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/

Revision as of 03:45, 7 January 2016

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/