A Database Management System (DBMS) serves as an interface for working with databases, providing tools to create, manage, organize, and retrieve data; while SQL (Structured Query Language) acts as the language used for interacting with the DBMS. This article also covers the connection details you’ll need to work with your database directly, such as the port and socket path.
Which Database Management System is used at Hostinger?
At Hostinger, our Web and Cloud hosting plans use MariaDB, an open-source relational database management system, across all our Web and Cloud hosting plans. MariaDB offers the same fundamental functionality as MySQL while enhancing query optimization, security, and overall performance. Plus, you have access to the user-friendly phpMyAdmin graphical interface, simplifying database management even more!
MariaDB features high compatibility with MySQL, ensuring seamless operation for most applications. Check the official documentation for more details: MariaDB – MySQL comparison.
If you’re interested in using a different database management system like PostgreSQL, MongoDB, or SQLite, the alternative is a virtual private server (VPS).
NOTE
-
Since all our servers are Linux-based, SQL Server is not supported. If you wish to use SQL Server, you can install Microsoft SQL server on a VPS running Ubuntu
What is the database socket path at Hostinger?
A database socket is a communication endpoint that allows programs to connect to a database server over a network. Whenever an application wants to interact with a database, it can use a socket to establish a connection, send requests, and receive responses.
The database socket path refers to the location of the socket file within the server.
The default socket file location on Unix-like systems, including Linux, is the following:
/var/lib/mysql/mysql.sockOn VPS hosting, the socket path might differ depending on the operating system you have installed.
What MySQL port is used at Hostinger?
A MySQL port is a network communication endpoint used by the MySQL database management system to establish connections with clients or other servers.
By default, MySQL uses port 3306, which is the port used at Hostinger for all of our Web and Cloud hosting plans – make sure to use this port when connecting to your databases remotely.
For local connections, such as in website’s configuration file, you can use localhost as hostname and in that case, the port does not need to be added.
If you need full control to manage which ports to open or close on your hosting, you can consider a VPS plan.