phpMyAdmin

To run the phpMyAdmin web tool using Unit:

1. Install Unit with a PHP language module.

2. Install and configure phpMyAdmin’s prerequisites

3. Install phpMyAdmin’s core files. Here we install them at /path/to/app; use a real path in your configuration.

   Make sure to create the config.inc.php file manually or using the setup script.

4. Change ownership:

   Run the following command (as root) so Unit can access the application directory (If the application uses several directories, run the command for each one):

   Copy

   # chown -R unit:unit /path/to/app/ # User and group that Unit's router runs as by default 

   The unit:unit user-group pair is available only with official packages , Docker images, and some third-party repos. Otherwise, account names may differ; run the ps aux | grep unitd command to be sure.

   For further details, including permissions, see the security checklist.

5. Next, prepare the phpMyAdmin configuration for Unit (use real values for share and root):

   Copy

   {  "listeners": {  "*:80": {  "pass": "routes"  }  },   "routes": [  {  "match": {  "uri": "~\\.(css|gif|html?|ico|jpg|js(on)?|png|svg|ttf|woff2?)$"  },  "_comment_match": "Enables access to static content only",  "action": {  "share": "/path/to/app$uri"  },  "_comment_action": "Serves matching static files"  },  {  "action": {  "pass": "applications/phpmyadmin"  }  }  ],   "applications": {  "phpmyadmin": {  "type": "php",  "root": "/path/to/app/"  },  "_comment_root": "Path to the application directory; use a real path in your configuration"  } }

6. Upload the updated configuration.

   Assuming the JSON above was added to config.json. Run the following command as root:

   Copy

   # curl -X PUT --data-binary @config.json --unix-socket \  /path/to/control.unit.sock \ # Path to Unit's control socket in your installation  http://localhost/config/ # Path to the config section in Unit's control API 

   The control socket path may vary; run unitd -h or see Startup and shutdown for details.

   After a successful update, phpMyAdmin should be available on the listener’s IP address and port: