MariaDB and phpMyAdmin

Coduva uses MariaDB 11.8 LTS as its database server (a single version). Applications connect to MariaDB with the MySQL drivers (mysqli, pdo_mysql); WordPress and Laravel need no extra configuration.

Connection details

Field	Value
Server	127.0.0.1
Port	3306 (can be changed in Settings)
User	root
Password	Empty
Character set	utf8mb4, collation utf8mb4_unicode_ci

127.0.0.1 instead of localhost

Enter 127.0.0.1 as the server name in connections. MariaDB listens only on this address and runs with skip-name-resolve.

Why is there no password?

MariaDB listens only on 127.0.0.1, so it cannot be reached from outside this computer. A passwordless root lets new projects connect without any configuration.

Do not change the root password

When stopping MariaDB and when performing database operations, Coduva connects as root without a password. If you set a password, Coduva cannot shut the service down cleanly, the Database screen stops working, and the logs show an "Access denied for user" error. If you need separate permissions, create a new user for the project.

First start and data directory

When MariaDB is started for the first time and no data directory exists, Coduva creates one with mariadb-install-db. This event is recorded in the Recent events log as "MariaDB data directory created".

Item	Path
Data directory	C:\Coduva\data\mariadb
Configuration	C:\Coduva\etc\mariadb\my.ini
Error log	C:\Coduva\logs\mariadb-error.log

When stopping, Coduva first tries a clean shutdown with mariadb-admin shutdown. If that does not work, the process is terminated and the event log records "Service did not shut down cleanly; process terminated".

Do not copy the data directory by hand

Copying or moving the data\mariadb folder while MariaDB is running produces an inconsistent copy. For a backup, use Export.

Database operations

Operations on the Database screen are performed with MariaDB's own tools (mariadb.exe, mariadb-dump.exe); the connection details are read from the [client] section of the my.ini file.

Naming rules

• Letters, digits and underscores; up to 64 characters
• System databases (mysql, information_schema, performance_schema, sys) cannot be created or deleted and do not appear in the list
• Project databases are derived from the project name: musteri-sitesi → musteri_sitesi

Export

Export writes the database to this file:

C:\Coduva\backups\db\<name>-<time>.sql

The dump is taken with --single-transaction, --routines, --triggers, --events and utf8mb4. The file contains no CREATE DATABASE or USE line, so it can be imported into a database with any name. The Backups folder button opens this folder.

Import

Import asks you to choose a .sql file and imports it into the selected database. If the database does not exist, it is created first. If an error occurs, the last lines of MariaDB's error output are shown.

Delete

Delete cannot be undone. The confirmation window requires the database name to be typed exactly. Removing a project from Coduva does not delete its database; a database is deleted only with this button.

phpMyAdmin

phpMyAdmin 5.2.3 is installed with the default components and opens at this address:

http://localhost/phpmyadmin/

If Nginx runs on a port other than 80, the address changes accordingly, for example http://localhost:8080/phpmyadmin/.

• Automatic sign-in: phpMyAdmin signs in as root automatically; no password is asked for.
• Local only: Nginx listens only on 127.0.0.1, so phpMyAdmin cannot be reached from another device.
• Language: The default interface language is Turkish.
• Version checks and error report submission are disabled.
• Nginx must be running for it to work.

phpMyAdmin is reached from the phpMyAdmin button on the Database screen (enabled only while MariaDB is running), from the Open phpMyAdmin command in the Ctrl+K command palette, or from the tray's left-click menu. Its configuration is generated in C:\Coduva\apps\phpmyadmin\config.inc.php and is rewritten together with the Nginx configuration (when the service starts, when a project or PHP setting changes, and on the first launch after Coduva moves to a new version).

Connecting with another tool

You can connect with desktop tools such as HeidiSQL, DBeaver, TablePlus or VS Code extensions, using the connection details above. From the command line:

& "C:\Coduva\bin\mariadb\11.8.9\bin\mariadb.exe" -h 127.0.0.1 -P 3306 -u root