phpMyAdmin Setup Guide - ajgillis04/GillisDockerDepot GitHub Wiki

phpMyAdmin Setup Guide

Introduction

phpMyAdmin is a free and open-source administration tool for MySQL and MariaDB. It provides a user-friendly web interface for managing your databases.

Prerequisites

  • Docker installed
  • phpMyAdmin container running in your Docker stack
  • MySQL or MariaDB configured and running

Configuration Steps

Step 1: Accessing the phpMyAdmin UI

  1. Open your browser and navigate to http://<your-ip-address>:8080.
  2. Log in with your MySQL or MariaDB credentials.

Step 2: Initial Setup

  1. After logging in, you will be directed to the phpMyAdmin dashboard.
  2. Familiarize yourself with the interface, including the sidebar for navigating databases and tables.

Step 3: Creating a New Database

  1. Click on the Databases tab.
  2. Enter a name for your new database in the Create database field.
  3. Select the collation for your database.
  4. Click Create.

Step 4: Creating a New User

  1. Navigate to the User accounts tab.
  2. Click Add user account.
  3. Enter the user details (username, host, password).
  4. Under Database for user account, select Create database with same name and grant all privileges.
  5. Click Go.

Step 5: Importing Data

  1. Navigate to the Import tab.
  2. Click Choose File and select the SQL file you want to import.
  3. Configure any additional import settings if necessary.
  4. Click Go to start the import process.

Step 6: Exporting Data

  1. Navigate to the Export tab.
  2. Select the export method (e.g., Quick or Custom).
  3. Configure the export settings if necessary.
  4. Click Go to download the SQL file.

Step 7: Managing Tables

  1. Select a database from the sidebar.
  2. Click on a table to view and manage its structure and data.
  3. Use the Structure, SQL, Search, Insert, Export, and Import tabs to manage the table.

Notes

  • Ensure all paths and environment variables are updated in the phpmyadmin.yaml file.
  • Regularly backup your databases to prevent data loss.

Troubleshooting

  • Common Issues: List common issues and solutions.
  • Logs: Check phpMyAdmin logs for error messages.
  • Support: Link to the phpMyAdmin community and support resources.