Getting paid internationally?
Choose Payoneer.


Securing the MariaDB Server


An easy way to secure the MariaDB (previously MySQL) server is to run the secure setup script in the command-line.

==========

user@host: $ sudo mysql_secure_installation

Remove anonymous users? (Press y|Y for Yes, any other key for No) : y
-- The anonymous user, intended only for testing, allows anyone to log into the database.

Disallow root login remotely? (Press y|Y for Yes, any other key for No) : y
-- Allowing remote root login enables guessing of password from the network.

Remove test database and access to it? (Press y|Y for Yes, any other key for No) : y
-- The test database, also intended for testing, can be accessed by anyone.

Reload privilege tables now? (Press y|Y for Yes, any other key for No) : y
-- Reloading privileges implements the changes immediately.

==========

Comments


Getting paid internationally?
Choose Payoneer.


Get started with DigitalOcean SSD Virtual Servers  Email Newsletters & Email Marketing by YMLP.com

Popular posts from this blog

Enabling HTTPS in Home Assistant

Running Home Assistant on FreeBSD Servers

Configuring the FreeBSD Firewall with IPFW