Home Assistant Community Add-on: phpMyAdmin

This add-on is provided by the Home Assistant Community Add-ons project.

GitHub Release GitLab CI Project Stage Project Maintenance

Supports armhf Architecture Supports armv7 Architecture Supports aarch64 Architecture Supports amd64 Architecture Supports i386 Architecture

A web interface for the official MariaDB add-on.

About


phpMyAdmin is a database administration tool for MySQL & MariaDB. Frequently used operations (managing databases, tables, columns, relations, indexes, users, permissions, etc) can be performed via the user interface, while you still have the ability to directly execute any SQL statement.

This add-on was specifically designed to manage the official Home Assistant MariaDB add-on.

Installation


The installation of this add-on is pretty straightforward and not different in comparison to installing any other Home Assistant add-on.

  1. Search for the “phpMyAdmin” add-on store.
  2. Install the “phpMyAdmin” add-on.
  3. Start the “phpMyAdmin” add-on.
  4. Enjoy the add-on!

:books: Please read the documentation for more information about the use and configuration of this add-on.

Support


You can always try to get support from the community here at the Home Assistant community forums, join the conversation!

Questions? You have several options to get them answered:

You could also open an issue on GitHub, in case you ran into a bug, or maybe you have an idea on improving the addon:

:information_source: At this moment our Home Assistant Community Add-ons Discord chat server and GitHub are our only official support channels. All others rely on community effort.

Repository on GitHub


Looking for more add-ons?


The primary goal of our add-ons project is to provide you (as a Home Assistant user) with additional, high quality, add-ons that allow you to take your automated home to the next level.

Check out some of our other add-ons in our Home Assistant Community Add-ons project.

5 Likes

About the author of this add-on

Hi there!

I am Franck Nijhof, and I have 30 years of programming experience, in many languages. I am using this experience to work on the Home Assistant project by giving back my knowledge and time to the open source community.

The add-on you are currently looking at right now was developed/packaged by me. It is not the only add-on I have created; there are many many more :wink:

However, I have a problem… I am an addict. A :coffee: addict that is. Lucky for you, I turn that C8H10N4O2 (caffeine molecule) into code (and add-ons)!

If you want to show your appreciation, consider supporting me for buying a cup of high octane wakey juice via one of the platforms below! :heart:

Sponsor Frenck via GitHub Sponsors

Support Frenck on Patreon

Enjoy your add-on, while I enjoy the brain juice. :coffee:

Thanks for all the :two_hearts:

…/Frenck

Join our Discord server Follow me on Twitter Flollow me on Instragram Follow me on GitHub Follow me on YouTube Follow me on Twitch patreon-icon

P.S.: In case you want to ask me a question: AMA (Ask Me Anything). Most of the time I am online at the Discord chat. (I go by @Frenck in there as well).

1 Like

Whoop!! This is awesome. Now an apache add-on and I can host websites from HA and manage xD!

1 Like

Geweldig, really super!!
Working ok

+1
I also vote for this.

Great addition, btw. Thanks!

Hi, this seems very interesting but as a total noob to databases and phpmyadmin i don’t really understand what this is used for. I am in now way criticizing your work i’m more just curious about what you can do with this and why it’s a big thing?
// Jakob

:tada: Release v0.1.1

Full Changelog

This is a general maintenance release.

:hammer: Changes

  • :sparkles: Add php7-curl (#5)
  • :fire: Disable version check (#7)
  • :arrow_up: Upgrades add-on base image to v7.0.2
  • :arrow_up: Upgrades php7 to 7.3.15-r0
  • :ambulance: Set a valid temporary dictory

Questions? Join our Discord server! https://discord.me/hassioaddons
Enjoying my add-ons? Consider supporting my work:
https://github.com/sponsors/frenck or https://patreon.com/frenck

I need to change the upload size for import files but I can’t find the php.ini for this add-on. Where can I change this?

Is it possible to point PHPmyAdmin to a different server?
Perhaps inherit the RECORDER setting from configuration.yaml ?

Hi @frenck

I’m having same issue as in this thread

I’m on version 0.112 and I have installed the MariaDB addon, working fine.

What can I check?

Thanks

2 Likes

Same happens to setup, any solution

1 Like

Can someone please help with me with the formatting for the settings as hitting default does not populate any dummy data?

[EDIT] Disregard. Rebooted and now it’s working.

The installation of this add-on is pretty straightforward and not different in comparison to installing any other Home Assistant add-on.
Search for the “phpMyadmin” add-on in the Supervisor add-on store.
Install the “phpMyadmin” add-on.

Can’t find it…
image

You can find it in the Home Assistant Community Add-ons

I checked everywhere but I can’t find it

It looks like you’re searching for integrations, not add-ons.

Go to your add-ons, then at the bottom right, click ‘Add-On Store’. Then at the top right, click the 3 dots and then ‘Repositories’. Once you’re there, add this: https://github.com/hassio-addons/repository

Once it’s added, you should be able to see it with all the other addons

1 Like

Thanks, I had to re-add the repo you linked, then phpMyAdmin showed up. Not sure why it wasn’t there anymore as I had already added it a long time ago (and installed other addons from it)

Hi! I know this is an older topic, but is there any way to change the max_input_vars configuration for the addon?

Hi I have HS supervised in docker updated to Jan 2023.
I have just installed phpmyadmin from home assistant community repository add-on.
It does not start… It shows only a blank/white page with nothing inside.
Logs are showing absolutely nothing.
Is there something I have missed?
thank you.
Ignazio

I set log in trace mode and this is what i obtain:

                if (.password == []) then
                    empty
                else
                    .password[]
                end
            elif (.password | type == "object") then
                if (.password == {}) then
                    empty
                else
                    .password
                end
            else
                .password
            end
[11:07:38] TRACE: bashio::services mysql port
[11:07:38] TRACE: bashio::cache.exists: service.info.mysql
[11:07:38] TRACE: bashio::fs.file_exists: /tmp/.bashio/service.info.mysql.cache
[11:07:38] TRACE: bashio::cache.get: service.info.mysql
[11:07:38] TRACE: bashio::cache.exists: service.info.mysql
[11:07:38] TRACE: bashio::fs.file_exists: /tmp/.bashio/service.info.mysql.cache
[11:07:38] TRACE: bashio::var.has_value: port
[11:07:38] TRACE: bashio::jq: {"host":"core-mariadb","port":3306,"username":"service","password":"ooJi6eiwi9thoof1ohthooboh9iatieju5xooT6uteeShushiapohneejuu4wiBo","addon":"core_mariadb"} if (.port == null) then
                null
            elif (.port | type == "string") then
                .port // empty
            elif (.port | type == "boolean") then
                .port // false
            elif (.port | type == "array") then
                if (.port == []) then
                    empty
                else
                    .port[]
                end
            elif (.port | type == "object") then
                if (.port == {}) then
                    empty
                else
                    .port
                end
            else
                .port
            end
[11:07:38] TRACE: bashio::services mysql username
[11:07:38] TRACE: bashio::cache.exists: service.info.mysql
[11:07:38] TRACE: bashio::fs.file_exists: /tmp/.bashio/service.info.mysql.cache
[11:07:38] TRACE: bashio::cache.get: service.info.mysql
[11:07:38] TRACE: bashio::cache.exists: service.info.mysql
[11:07:38] TRACE: bashio::fs.file_exists: /tmp/.bashio/service.info.mysql.cache
[11:07:38] TRACE: bashio::var.has_value: username
[11:07:38] TRACE: bashio::jq: {"host":"core-mariadb","port":3306,"username":"service","password":"ooJi6eiwi9thoof1ohthooboh9iatieju5xooT6uteeShushiapohneejuu4wiBo","addon":"core_mariadb"} if (.username == null) then
                null
            elif (.username | type == "string") then
                .username // empty
            elif (.username | type == "boolean") then
                .username // false
            elif (.username | type == "array") then
                if (.username == []) then
                    empty
                else
                    .username[]
                end
            elif (.username | type == "object") then
                if (.username == {}) then
                    empty
                else
                    .username
                end
            else
                .username
            end
[11:07:38] TRACE: bashio::config.has_value: upload_limit
[11:07:38] TRACE: bashio::config: upload_limit
[11:07:38] TRACE: bashio::addon.config
[11:07:38] TRACE: bashio::cache.exists: addons.self.options.config
[11:07:38] TRACE: bashio::fs.file_exists: /tmp/.bashio/addons.self.options.config.cache
[11:07:38] TRACE: bashio::cache.get: addons.self.options.config
[11:07:38] TRACE: bashio::cache.exists: addons.self.options.config
[11:07:38] TRACE: bashio::fs.file_exists: /tmp/.bashio/addons.self.options.config.cache
[11:07:38] TRACE: bashio::jq: {"log_level":"trace"} if (.upload_limit == null) then
            null
        elif (.upload_limit | type == "string") then
            .upload_limit // empty
        elif (.upload_limit | type == "boolean") then
            .upload_limit // false
        elif (.upload_limit | type == "array") then
            if (.upload_limit == []) then
                empty
            else
                .upload_limit[]
            end
        elif (.upload_limit | type == "object") then
            if (.upload_limit == {}) then
                empty
            else
                .upload_limit
            end
        else
            .upload_limit
        end
[11:07:38] INFO: Starting NGinx....