Home Assistant Community Add-on: phpMyAdmin

[frenck (Franck Nijhof)]

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

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!

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:

• The Home Assistant Community Add-ons Discord chat server for add-on support and feature requests.
• The Home Assistant Discord chat server for general Home Assistant discussions and questions.
• Join the Reddit subreddit in /r/homeassistant

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:

• Open an issue for the addon: phpMyAdmin
• For general repository issues or add-on ideas open an issue here

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

---

hassio-addons/addon-phpmyadmin

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.

[frenck (Franck Nijhof)]

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

However, I have a problem… I am an addict. A 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!

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

Thanks for all the

…/Frenck

Franck Nijhof's Personal Homepage

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).

[Vasco]

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

[John_P (John)]

Geweldig, really super!!
Working ok

[JANogueira]

+1
I also vote for this.

Great addition, btw. Thanks!

[svemat01 (Jakob)]

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

[frenck (Franck Nijhof)]

Release v0.1.1

Full Changelog

This is a general maintenance release.

Changes

• Add php7-curl (#5)
• Disable version check (#7)
• Upgrades add-on base image to v7.0.2
• Upgrades php7 to 7.3.15-r0
• 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

[anon3881519]

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?

[PureeTofu (Billy)]

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

[woody4165 (Woody)]

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

[vbxlive (Vaibhavkumar)]

Same happens to setup, any solution

[xbmcnut]

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.

[Jonn87 (Jon)]

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…

[pepe59]

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

[Jonn87 (Jon)]

I checked everywhere but I can’t find it

[moto2000 (David)]

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

[Jonn87 (Jon)]

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)

[qrioniclabs]

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

[ignazio.testoni (Ignazio)]

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

[ignazio.testoni (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....