MariaDB Configuration: Difference between revisions

From NovaOrdis Knowledge Base
Jump to navigation Jump to search
No edit summary
No edit summary
Line 5: Line 5:


=Post-Install=
=Post-Install=
==Secure==


<pre>
<pre>
Line 23: Line 25:
Reload privilege tables now? [Y/n] Y
Reload privilege tables now? [Y/n] Y
...
...
</pre>
==Test==
<pre>
cd /usr
/usr/bin/mysqld_safe --datadir='/var/lib/mysql'
/usr/mysql-test; perl mysql-test-run.pl
</pre>
</pre>



Revision as of 04:04, 7 January 2016

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'
/usr/mysql-test; perl mysql-test-run.pl

Start at Boot

systemctl enable mariadb
systemctl start mariadb