📦 Installation Command
apt install mariadb-server mariadb-client
MariaDB Default Port & Configuration Guide
mariadb-server systemctl: mariadbMySQL fork by original MySQL developers. Drop-in MySQL replacement with additional features.
🔌 Default Port
3306
tcp
MySQL protocol
⚙️ Configuration Files
/etc/mysql/mariadb.conf.d/50-server.cnf/etc/mysql/my.cnf/etc/mysql/mariadb.cnf/etc/mysql/conf.d/
📂 Default Directories
- config:
/etc/mysql - data:
/var/lib/mysql - logs:
/var/log/mysql - socket:
/var/run/mysqld/mysqld.sock
🔐 Default Credentials
Username:root
Password:N/A (unix_socket by default)
💡 Uses unix_socket auth - login via sudo mariadb. Run mariadb-secure-installation to configure.
📌 Dependencies
⚠️ Conflicts
✅ Works With
🛡️ Security Notes
Run mariadb-secure-installation, disable remote root, use SSL, configure Galera for clustering if needed
❓ Frequently Asked Questions
What port does MariaDB use?
MariaDB uses port 3306, same as MySQL since it's a drop-in replacement.
Is MariaDB compatible with MySQL?
Yes, MariaDB is fully compatible with MySQL clients and protocols.
MariaDB vs MySQL which to choose?
MariaDB offers better performance and is fully open-source. MySQL has Oracle backing.