MariaDB Configuration

From NovaOrdis Knowledge Base
Revision as of 04:30, 7 January 2016 by Ovidiu (talk | contribs) (→‎Test)
Jump to navigation Jump to search

Internal

Post-Install

Secure

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
...

Test

cd /usr
/usr/bin/mysqld_safe --datadir=/var/lib/mysql
cd /usr/mysql-test; perl mysql-test-run.pl

Start at Boot

systemctl enable mariadb
systemctl start mariadb