Skip to content

database.md

Latest commit

 

History

History
52 lines (35 loc) · 1.46 KB

database.md

File metadata and controls

52 lines (35 loc) · 1.46 KB
Raw

Database

Available Versions

Altis supports MySQL version 8.4.

Interacting with the Database

You can log into MySQL and run any query in the default database (wordpress) by using:

composer server db

Pass extra arguments through to the MySQL client by separating them with --:

composer server db -- -A

Use composer server db info to retrieve MySQL info and connection details:

Root password:  wordpress

Database:       wordpress
User:           wordpress
Password:       wordpress

Host:           0.0.0.0
Port:           32809

Version:        8.4
MySQL link:     mysql://wordpress:wordpress@0.0.0.0:32809/wordpress

Use composer server db sequel to open the database in Sequel Ace. This command can only be run under MacOS and requires Sequel Ace to be installed on your computer.

Use composer server db tableplus to open the database in TablePlus. This command requires TablePlus to be installed on your computer.

Use composer server db exec -- "<command>" to execute and output the results of an arbitrary SQL command:

composer server db exec -- 'select id,post_title from wordpress.wp_posts limit 2;'

db exec is safe to run from scripts, CI, cron, and other non-interactive contexts — it does not require a controlling terminal. The interactive composer server db REPL does require a terminal and will exit with a clear message when one is not attached.