- Start the mariadb server using
devbox services up
- Create a database using
"mysql -u root < setup_db.sql"
- You can now connect to the database from the command line by running
devbox run connect_db
- mariadb
Use devbox services start|stop [service]
to interact with services
- MYSQL_BASEDIR=//.devbox/nix/profile/default
- MYSQL_HOME=//.devbox/virtenv/mariadb/run
- MYSQL_DATADIR=//.devbox/virtenv/mariadb/data
- MYSQL_UNIX_PORT=//.devbox/virtenv/mariadb/run/mysql.sock
- MYSQL_PID_FILE=//.devbox/virtenv/mariadb/run/mysql.pid
To show this information, run devbox info mariadb
Note that the .sock
filepath can only be maximum 100 characters long. You can point to a different path by setting the MYSQL_UNIX_PORT
env variable in your devbox.json
as follows:
"env": {
"MYSQL_UNIX_PORT": "/<some-other-path>/mysql.sock"
}