MariaDB Configuration: Difference between revisions
(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/