MariaDB Configuration: Difference between revisions

From NovaOrdis Knowledge Base
Jump to navigation Jump to search
No edit summary
Line 25: 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
cd /usr/mysql-test; perl mysql-test-run.pl
</pre>
</pre>



Revision as of 04:31, 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
...

Start at Boot

systemctl enable mariadb
systemctl start mariadb