Percona Live: Open Source Database Performance Conference - Amsterdam 2016 Logo

October 3-5, 2016

Amsterdam, Netherlands

Less passwords, more security: mass administration of MariaDB servers with socket authentication

Less passwords, more security: mass administration of MariaDB servers with socket authentication

 5 October 2:10 PM - 2:35 PM @ Zürich 2
Experience level: 
25 minutes conference
Data in the Cloud


This talk explains how socket authentication in MariaDB/MySQL works and how it makes the life of system administrators easier when they can do all the maintenance as root, without the need for additional passwords. Life without extra passwords is also more secure, as there is less to leak or loose. Passwordless operation solves many devops problems in the Docker/Ansible/configuration management world. Socket authentication in MariaDB is by default enabled in Debian and something at least all Debian/Ubuntu DBAs are going to learn to work with. Knowing this technique is a widely useful for any DBA as all MariaDB/MySQL instances always need access control.


Otto Kekäläinen's picture

Otto Kekäläinen

CEO, MariaDB Foundation


Otto Kekäläinen is the CEO of the MariaDB Foundation, CEO of Seravo Oy (open source business in Finland) and the chairman of the FUUG Foundation (open source funding in Finland). Otto has been using Linux and other open source technologies for over 15 years, and has been advocating open source for almost as long. The list of projects and organizations Otto has been involved in is long, with the most prominent ones being the Center for Open Source Solutions in Finland ( and Free Software Foundation Europe ( As a software developer Otto has insight into the technical side of open source, and as a CEO and entrepreneur he also knows how to use open source in business successfully. Otto likes to share his experiences on how to use open source to its full potential and how the world can keep increasing the benefits of open source software and the its methodologies.

Share this talk