Skip to main content
Bearsampp bundles four database engines that cover the most common needs in local web development: MySQL and MariaDB for relational SQL workloads, PostgreSQL for object-relational projects, and Memcached for in-memory caching. Each database runs as a separate Windows service and can be started, stopped, and configured independently from the system tray.
MySQL and MariaDB cannot both listen on the same port at the same time. By default, MySQL uses port 3306 and MariaDB uses port 3307. If you change either port, make sure no two database services share the same port number.

​
MySQL

MySQL is an open-source relational database management system and one of the most widely used databases in web development. Bearsampp runs it as a Windows service and provides phpMyAdmin for browser-based management.

​
Default settings

PropertyValue
Default port3306
Service namebearsamppmysql
Config filebin/mysql/mysqlX.X.X/my.ini
Web adminhttp://localhost/phpmyadmin

​
Tray menu options

Right-click the tray icon → MySQL to access:

Start / Stop service

Start or stop the MySQL Windows service.

Change port

Switch MySQL to a different port. Bearsampp updates my.ini and restarts the service.

Change root password

Update the MySQL root user password through a guided dialog.

Logs / Error logs

Open the MySQL log file to diagnose connection and startup issues.

​
phpMyAdmin

phpMyAdmin is available at http://localhost/phpmyadmin whenever Apache and MySQL are both running. Log in with username root and the root password you configured (empty by default).

​
MariaDB

MariaDB is a community-developed fork of MySQL that is fully compatible with MySQL’s SQL dialect and client tools. It runs alongside MySQL in Bearsampp — you can enable both at the same time on different ports.

​
Default settings

PropertyValue
Default port3307
Service namebearsamppmariadb
Config filebin/mariadb/mariadbX.X.X/my.ini
Web adminhttp://localhost/phpmyadmin

​
Tray menu options

Right-click the tray icon → MariaDB to access:

Start / Stop service

Start or stop the MariaDB Windows service.

Change port

Switch MariaDB to a different port.

Change root password

Update the MariaDB root user password.

Logs / Error logs

Open the MariaDB log file.

​
phpMyAdmin

phpMyAdmin can manage both MySQL and MariaDB. To connect to MariaDB specifically, update the phpMyAdmin connection settings to point to port 3307 (or whichever port MariaDB is configured to use).

​
PostgreSQL

PostgreSQL is an advanced object-relational database with strong support for complex queries, JSON, full-text search, and ACID compliance. Bearsampp runs it as a Windows service and includes phpPgAdmin for browser-based management.

​
Default settings

PropertyValue
Default port5432
Service namebearsampppostgresql
Config dirbin/postgresql/postgresqlX.X.X/
Web adminhttp://localhost/phppgadmin

​
Tray menu options

Right-click the tray icon → PostgreSQL to access start/stop controls, port management, and log access — the same pattern as MySQL and MariaDB.

​
phpPgAdmin

phpPgAdmin is available at http://localhost/phppgadmin whenever Apache and PostgreSQL are both running. Use it to create databases, run queries, and manage users.

​
Memcached

Memcached is a distributed in-memory object caching system. It is commonly used to reduce database load by caching query results, session data, and computed values in RAM.

​
Default settings

PropertyValue
Default port11211
Service namebearsamppmemcached
Memcached does not have a configuration file or a web-based admin UI. Start and stop it from the tray menu (Memcached → Start / Stop service).
To use Memcached with PHP, enable the memcached or memcache PHP extension from the tray menu (tray → PHP → Extensions).