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
2 answers

After Ubuntu 14.04 -> 16.04 upgrade, pypMyAdmin retuns 502 error on nginx

So I just upgraded my VPS from 14.04 to 16.04, the upgrade went well for most parts, but MySQL failed to update. I needed to manually remove mariadb-client first, and then I was able to install MySQL again, and everything on my website is now…
LBandy
  • 9
  • 2
0
votes
1 answer

Apache connections stuck on "sending reply" and high mysql load

Apache on my dedicated server constantly hangs due to connections being stuck in a state of "sending reply": Apache status: connections stuck in "Sending Reply" This happens at least several times a day - sometimes it won't happen for 2 or 3 hours,…
user548654
  • 81
  • 1
  • 1
  • 3
0
votes
1 answer

Configure Multiple Domains and an IP Address with NGINX

I've asked on the forums before but didn't get answer so I'm going to try again. I'm trying to setup NGINX with PHPMyAdmin and I want to access the site via two subdomains and an IP address. The following URLs all lead to the same root…
willowen100
  • 31
  • 2
  • 10
0
votes
1 answer

phpMyAdmin tunnel to mySQL

How can I connect local phpMyAdmin via SSH tunnel to a remote mySQL dockerized container (example.com)? This is the local phpMyadmin in docker compose: pma: image: phpmyadmin/phpmyadmin container_name: pma environment: - PMA_ARBITRARY=1 …
Jumpa
  • 111
  • 1
  • 6
0
votes
0 answers

phpmyadmin - root has rights but can't create a database

My problem is that I'm logged into phpmyadmin as root user and in "Users Accounts" he has "ALL PRIVILEGES" but nevertheless I cannot create a new database or create a new User.. User accounts - root: Trying to create new database: I do not know…
Traijan
  • 1
0
votes
0 answers

docker phpmyadmin container exporting DBs as html instead of sql

My phpmyadmin container is exporting sql databases as html files when explicitly set to export as a sql file. I've already updated the php.ini file to max_input_vars = 10000 and max_allowed_packet=500M in my.cnf
user532391
0
votes
2 answers

UFW is blocking mailserver traffic (dovecot, postfix, MariaDB, Rspamd)

As described in the title, I am running a dovecot/postfix/Rspamd Mailservercombo with a MariaDB behind it. I noticed how, in the last days, I couldn't receive/send any mail from my e-mail clients anymore. Thunderbird noticed too: It is not possible…
Art3mis
  • 1
  • 4
0
votes
0 answers

How to reset 2FA on the phpmyadmin software?

I have been using 2FA (2 factor authentication) to log in into the admin panel but I recently resettled my phone which has the 2FA code due to certain problems. I tried reading through the phpmyadmin documentation but it only show the method to…
joseph222
  • 1
0
votes
0 answers

WAMP Server: Apache PHPMyAdmin login screen not showing

I have recently setup a WAMP server (Windows, Apache, MySQL, PHP) and i'm having trouble setting up PHPMyAdmin. I didnt use XAMPP for any of this, i installed the services directly onto the server. I followed a video tutorial, in which i've been…
David Aeberhard
  • 1
  • 1
0
votes
0 answers

phpmyadmin - Out of memory (allocated 1008730112) (tried to allocate 377483264 bytes)

I have phpmyadmin on a local PC that is not exposed to the Internet, for development purposes only. I have edited php.ini to allow unlimited size files, unlimited processing time, set Memorylimit to 1 GB or unlimited in config.inc.php etc'. Every…
User6655
  • 11
  • 1
  • 5
0
votes
2 answers

Nginx reverse proxy to PHPMyAdmin returns 404

On my network I have two servers: One proxy-server (ip: 192.168.1.10) using nginx to handle all incoming HTTP requests. One web-server (ip: 192.168.1.33) running Apache2 and PHPMyAdmin I want the proxy server to handle certain requests like…
oleter
  • 3
  • 1
  • 4
0
votes
1 answer

NGINX + php7.0-fpm + phpmyadmin

Disclaimer: I've tried tips listed in probably every google result on the first 2 pages. None of them worked for me. This is not a duplicate. I'm running Debian 9 in LXC container that had LAMP installed, today I wanted to replace apache2 with…
Kristi
  • 91
  • 2
  • 10
0
votes
0 answers

htpasswd keeps asking for password - phpmyadmin

I am using Ubuntu 18.04 LTS Desktop to host an apache2 webserver. I installed phpmyadmin and wanted to secure it using htpasswd. There for I edited the /etc/apache2/conf-available/phpmyadmin.conf, adding AllowOverride All and restarted apache2. I…
mathmaniac88
  • 111
  • 1
  • 1
  • 8
0
votes
1 answer

504 Gateway Time-out after executing SQL query

I executed a SQL query via phpmyadmin, to delete all tables of my test database, after a failed import. First there was a pop-up saying "Loading" in the middle of the screen, but I was getting sceptical after it stayed for >1 hour, so I closed the…
Black
  • 461
  • 1
  • 8
  • 20
0
votes
1 answer

Phpmyadmin fails to import sql files

I exported all tables from my database with the option "Export tables as separate files". This worked perfectly, the tables were packed to a zip file: However, If I try to import them, I get this: and nothing is imported: I also tried to remove…
Black
  • 461
  • 1
  • 8
  • 20
1 2 3
…
14 15