Database Management Account and Connection Information

When using ServBay for database management, understanding how to obtain and use database connection information is crucial. This article provides detailed information about the management accounts and connection information for MySQL, MariaDB, PostgreSQL, MongoDB, and Redis bundled with ServBay.

Obtaining Database Connection Information

The connection information for ServBay's MySQL, MariaDB, and PostgreSQL databases can be found in the settings of the ServBay management panel. The specific steps are as follows:

1. Open the ServBay management panel.
2. Navigate to Database - MySQL (or another database type you need to view).
3. Select the database version you want to view, such as MySQL 8.4.
4. On the right side of the page, you can see the username and password.
5. Click the eye icon next to the password input box to view the password.

On this page, you'll be able to view connection information for MySQL, MariaDB, and PostgreSQL, including the username, password, host address, and port.

MySQL Database Default Connection Information

• Username: Retrieved from the management panel
• Password: Retrieved from the management panel
• Host Address: localhost
• Port: 3306 (default port)
• Socket: /Applications/ServBay/tmp/mysql-<version>.sock

MariaDB Database Default Connection Information

• Username: Retrieved from the management panel
• Password: Retrieved from the management panel
• Host Address: localhost
• Port: 3306 (default port)
• Socket: /Applications/ServBay/tmp/mariadb-<version>.sock

PostgreSQL Database Default Connection Information

• Username: Retrieved from the management panel
• Password: Retrieved from the management panel
• Host Address: localhost
• Port: 5432 (default port)
• Socket: /Applications/ServBay/tmp/.s.PGSQL.<port>

Redis Database Default Connection Information

• Host Address: 127.0.0.1
• Port: 6379 (default port)
• Password: No password by default

Using Socket Connection

If users choose to connect to the database using sockets, ServBay provides the appropriate socket file paths.

MySQL Socket Connection

• Default Socket File: /Applications/ServBay/tmp/mysql.sock
• MySQL Socket File: /Applications/ServBay/tmp/mysql-server.sock
• Specific Version Socket File: /Applications/ServBay/tmp/mysql-<version>.sock

Connection Example:

mysql -u your_username -p -S /Applications/ServBay/tmp/mysql.sock

MariaDB Socket Connection

• Socket File: /Applications/ServBay/tmp/mysql.sock
• MariaDB Socket File: /Applications/ServBay/tmp/mariadb-server.sock
• Specific Version Socket File: /Applications/ServBay/tmp/mariadb-<version>.sock

Connection Example:

mysql -u your_username -p -S /Applications/ServBay/tmp/mysql.sock

PostgreSQL Socket Connection

• Socket File: /Applications/ServBay/tmp/.s.PGSQL.5432
• Specific Port Socket File: /Applications/ServBay/tmp/.s.PGSQL.<version>

Connection Example:

psql -U your_username -h /Applications/ServBay/tmp -d your_database

Sample Connection Commands

Here are some sample commands for connecting to the MySQL, MariaDB, PostgreSQL, and Redis databases bundled with ServBay.

Connecting to MySQL

1. Using TCP/IP:

   mysql -u your_username -p -h localhost -P 3306

2. Using Socket:

   mysql -u your_username -p -S /Applications/ServBay/tmp/mysql.sock

Connecting to MariaDB

1. Using TCP/IP:

   mysql -u your_username -p -h localhost -P 3306

2. Using Socket:

   mysql -u your_username -p -S /Applications/ServBay/tmp/mysql.sock

Connecting to PostgreSQL

1. Using TCP/IP:

   psql -U your_username -h localhost -d your_database -p 5432

2. Using Socket:

   psql -U your_username -h /Applications/ServBay/tmp -d your_database

Connecting to Redis

1. Using TCP/IP:

   redis-cli -h 127.0.0.1 -p 6379

2. Using Socket:

Currently, using sockets to connect to Redis is not supported.

Summary

Understanding and obtaining the connection information for MariaDB, PostgreSQL, and Redis provided by ServBay is an important step in database management. Through the ServBay management panel, you can easily obtain the connection information for MariaDB and PostgreSQL. Redis requires no default password and uses the default port. For socket connections, ServBay provides the appropriate socket file paths, making it convenient for users to connect locally.