The Ultimate Guide to High Availability with MariaDB

Comments - Security of Mariadb root account

6 years, 6 months ago Paul Reed
Re: Security of Mariadb root account 
pi@raspberrypi:~ $ sudo mysql
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 1587
Server version: 10.1.23-MariaDB-9+deb9u1 Raspbian 9.0

Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]>
 
6 years, 6 months ago Brian Evans
Re: Security of Mariadb root account [Answer]

This is a Debian decision to:

  1. Not require a password with sudo
  2. Utilize the unix_socket plugin by default

The latter is set in the Debian install scripts. You can override this by removing the plugin for 'root'@'localhost' as long as you understand that Debian scripts may be looking for their default.

 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.