Introduction
Your box comes with the following database servers:
Note: the Cakebox Commands only support MySQL at this moment.
Connection From Local Machine
To connect to the MySQL service from your local machine:
- start your local MySQL client tool
- make a connection to
10.33.10.10:3306
orcakebox:3306
- log in with user
vagrant
and passwordvagrant
Note: you might consider using Sequel Pro, MySQL Workbench or phpMyAdmin.
Connection Inside Virtual Machine
To connect to the MySQL service from within your box use the mysql
command
with either:
- the
root
user with passwordsecret
(access to all databases) - the
cakebox
user with passwordsecret
(per-database access) - the user and password specified while creating the database
Command line examples:
mysql -u root -p
mysql -u cakebox -p
mysql -u my-user -p
Installing phpMyAdmin
These instructions provide you with two easy methods to add phpMyAdmin to your box using:
- Command Line: non-persistent manual installation
- Cakebox.yaml: persistent provisioned installation
Note: just replace
cakebox.phpmyadmin
if you prefer a different url.
Command Line
- On your local machine update your hosts file to include
10.33.10.10 cakebox.phpmyadmin
- Inside your box run
cakebox package add phpmyadmin
- Inside your box run
cakebox vhost add cakebox.phpmyadmin /usr/share/phpmyadmin
- On your local machine browse to
http://cakebox.phpmyadmin
- Log in with user
root
and passwordsecret
Cakebox.yaml
Update the Cakebox.yaml file on your local machine to include:
vhosts:
- url: cakebox.phpmyadmin
webroot: /usr/share/phpmyadmin
extra:
- apt_packages:
- phpmyadmin
On your local machine:
- Update your hosts file to include
10.33.10.10 cakebox.phpmyadmin
- Apply the changes by running
vagrant reload --provision
- Browse to
http://cakebox.phpmyadmin
- Log in with user
root
and passwordsecret