- Home
- Database
MariaDB and phpMyAdmin
The database ships empty, with credentials that work out of the box, and phpMyAdmin opens inside the dashboard instead of looking like a different application from a different decade.
Empty, and ready
No tables, no rows, nobody else's data. The database in the full stack is created during packaging rather than copied from the machine that built it, which matters more than it sounds, because InnoDB keeps every table in one shared file and copying the folder would have carried everything with it.
⚠️ These suit a machine only you can reach. If the installation is ever exposed beyond your own computer, change them before it is.
Connecting from a project
Use 127.0.0.1 rather than localhost. They are not
interchangeable here: localhost makes most clients try a Unix
socket, whose path differs between installations, while the address goes
over TCP and simply works.
DB_HOST=127.0.0.1
DB_PORT=3306
DB_USERNAME=root
DB_PASSWORD=root
If the database stops answering
The usual cause is skip-networking in my.cnf, left
behind by the security check. MySQL then accepts Unix sockets only, and
every project using the address above fails. Comment the line out and
restart MySQL from the app. The file is protected and asks for your Mac
administrator password:
sudo nano /Applications/VXOST/vxostfiles/etc/my.cnf
(Ctrl+O then Return to save, Ctrl+X to leave).
What the app shows you about MySQL does not come from a connection: it
watches the process and probes the port, which is why it can tell you
MySQL is running even when your credentials are wrong. The operations
you ask for are another matter, and those do connect, through the
mysql client inside the package: creating the database of
a new project, changing the root password, checking that a password
works at all.
Which MariaDB
Version 10.4, a prebuilt binary that comes with the stack. It speaks MySQL: the same
client, the same drivers, the same tools, and the great majority of SQL
written for MySQL runs against it as it is. Which is why everyone still
says MySQL while running this.
⚠️ Identical it is not. MariaDB documents where it parts ways with
MySQL 8, and a project that leans on recent MySQL-only features is
worth importing into a copy first rather than assuming.
MariaDB documentation
A clean database, from the first launch
Nothing to configure, nobody else's data.