Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [phpmyadmin]

phpMyAdmin is a popular tool for administrating MySQL (and similar) databases

PMA is best known as a GUI for managing not only the data within a database, but the table structures as well. Because and other MySQL forks are similar enough they can also be administrated with this tool.

https://www.phpmyadmin.net/

phpMyAdmin is a free software tool written in PHP, intended to handle the administration of MySQL over the Web. phpMyAdmin supports a wide range of operations on MySQL and 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.

Questions about this tool should be focused on the problems with setting it up and not using it to manage the database.

217 questions
0
votes
1 answer

PHPMyAdmin Fresh Install Error 500 Nginx

I've just done a fresh install of phpmyadmin on nginx and ubuntu 22.04, however navigating to the index page is returning HTTP 500. My error.log: 2023/06/24 22:52:55 [error] 1448200#1448200: *1 FastCGI sent in stderr: "PHP message: PHP Warning: …
Finbar
  • 101
  • 1
0
votes
0 answers

How to handle scaling upto 3k concurrent connections

So here's our use case: We have firmware that connects to server (simple php file - that takes post request) and add the data (350-500 bytes per request) to database. Now here's a issue we have 3k units in the market and non-technical manager wants…
Shamsudeen McHalwai
  • 1
0
votes
0 answers

Configure xenforo 1.2.9 Using phpmyadmin 4.x with php 5.6.4 on IIS 10, Windows Server 2019

Versions/Programs: xenforo 1.2.9, phpmyadmin 4.x, php 5.6.4, MySQL 8.0.32 IIS 10, Windows Server 2019 I am trying to host a local server for tinkering on an old computer I have. This server will be hosting a XenForo installation. However, my xenforo…
Fictor
  • 1
0
votes
0 answers

WampServer and error 404

Having just installed Wampserver on my system in order to test a PHP form I have created via Dreamweaver, I'm continually getting the Error 404 message on my screen despite following the installation instructions to the letter. My OS is Windows 10…
SimplyTheMighty
  • 1
  • 2
0
votes
1 answer

Unable to connect to server following phpMyAdmin upgrade from 5.1 to 5.2

Not sure to post on the right StackExchange forum. If not, let me know! Working environment: OpenSUSE Leap 15.4 MariaDB : mariadb Ver 15.1 Distrib 10.7.7-MariaDB PHP 8.0.25 (cli) (built: Oct 31 2022 12:00:00) ( NTS ) Based on phpinfo(), PHP ini…
wiltomap
  • 75
  • 10
0
votes
1 answer

How to upgrade a MariaDB database to utf8mb4_unicode_ci?

I have a Drupal 9.4.8 website a MariaDB database and phpMyAdmin. My website is already active with data in its 220 MB database. How to upgrade a MariaDB database to utf8mb4_unicode_ci ? Here is my website setup : enter image description here Here is…
Mathieu
  • 1
0
votes
0 answers

phpmyadmin Mysql frozen in time

i got a remote mysql database connection to work on my on ubuntu 22.04. I see on the website that i setup that data gets into the database as users are active in the website but when i check phpmyadmin the values in the database wont change, it's…
Klagor Mundavi
  • 1
  • 1
0
votes
0 answers

Error in Processing Request Error code: 403 Error text: Forbidden Apache2

Error in Processing Request Error code: 403 Error text: Forbidden This kind of error pops up when i am trying to do anything that requires ajax in phpmyadmin.[enter image description here][1]
Jean Rura
  • 1
0
votes
0 answers

phpmyadmin install on Debian 10 fails. [proxy_fcgi:error]: error parsing URL //: Invalid host/port

I am trying to upgrade a phpmyadmin install on a (remote, VM) Debian 10 without success. I followed install instructions at computingforgeeks.com, and at first - when i tried to access http://path.tld/phpmyadmin - I just got a The connection was…
mario
  • 101
  • 2
0
votes
0 answers

Phpmyadmin not working after update

My phpmyadmin installation stopped working correctly, this is the error.log [Fri Aug 12 20:11:10.749656 2022] [php:warn] [pid 2213] [client 181.161.145.134:58094] PHP Warning: require_once(PhpMyAdmin/MoTranslator/autoload.php): Failed to open…
Ricardo Mehr
  • 101
  • 1
0
votes
1 answer

Copy large-size JSON content and paste it into MySQL column

I have a column with the data type "JSON" in the MySQL table(I have MySQL 8). I have a 20 MB JSON file created by my BE code and I would like to copy and paste the contents of the JSON file into the box. But my phpMyadmin keeps freezing when I copy…
ITnewbie
  • 171
  • 2
  • 9
0
votes
1 answer

Single Signon best practice for phpMyAdmin across multiple servers

I run a small web development company and we run multiple production servers, each with their own MySQL database server. I'm trying to figure out the best way of giving access to these separate MySQL instances to my team. I've set up phpMyAdmin on…
james-geldart
  • 101
  • 2
0
votes
1 answer

How to serve phpMyAdmin to localhost/phpMyAdmin instead of localhost:8080 using nginx in docker

In my project, I am using Django and nginx, but I want to manage my cloud databases through phpmyadmin. Django is working fine but I can't do the same with phpmyadmin because it is running in apache at localhost:8080, when I want it to run in nginx…
Ram Awasthi
  • 1
0
votes
1 answer

phpMyAdmin: change bind address of MySQL on phpmyadmin

How do I change the bind address of a mysql databse through phpmyadmin? I am new at this and really dont know what I am doing.
JBC
  • 3
  • 1
0
votes
1 answer

phpMyAdmin with cloudflare ssl certificartes

I have 3 wordpress sites, 1 moodle site and 1 owncloud site, all with same apache configuration in my vps, and all of them works fine But I'm not able to make phpMyAdmin work with cloudflare's origin certificates. When I go to mysql.domain.tld it…
DiogoSaraiva
  • 409
  • 4
  • 16
1 2 3
…
14 15