MariaDB Configuration: Difference between revisions

From NovaOrdis Knowledge Base
Jump to navigation Jump to search
No edit summary
Line 31: Line 31:
<pre>
<pre>
cd /usr
cd /usr
/usr/bin/mysqld_safe --datadir='/var/lib/mysql'
/usr/bin/mysqld_safe --datadir=/var/lib/mysql
/usr/mysql-test; perl mysql-test-run.pl
/usr/mysql-test; perl mysql-test-run.pl
</pre>
</pre>

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