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

Can't login to phpMyAdmin on Centos, Google Cloud

In my MySQL database, I've created two users, one regular user (who has privileges for one database) and one superuser. When I want to login via any of these accounts to phpMyAdmin I get a "Cannot log in to the MySQL server" error. (I'm accessing…
LosmiNCL
  • 33
  • 3
  • 11
0
votes
0 answers

Mysql remote connect CentOS

i have problem with mysql remote connect. In my.cnf have: bind-address = 0.0.0.0 and #skip-networking. In users mysql have special user remote@% And still not working. If i try: nmap -p 3306 remote.ip.com Output is: PORT STATE …
ondravirag
  • 1
0
votes
1 answer

ModSecurity 403, COMODO WAF detects XSS while trying to access phpMyAdmin

I have a copy of phpMyAdmin in one of my server in a subdomain 'pma' and inside a directory in it named 'app' (manual installed from zip archive, not via yum), which I use for DB related management and it was working ok for couple of months. A…
Nishu Ali
  • 1
  • 2
0
votes
1 answer

Can't connect to mysql docker when using phpmyadmin docker

I'm just getting started in docker and maybe I'm starting of a little big but I found an article that explained out to get a coldfusion install (run by commandbox) up with mysql. This docker compose works just fine. I had the idea of adding in…
weggie
  • 101
  • 1
  • 1
0
votes
1 answer

Ubuntu 18.04: PHP stopped working after I tried to fix phpmyadmin

I have a problem with a Ubuntu 18.04.6 Ubuntu server. I was trying to fix a problem with phpMyAdmin (a lot of errors appearing on screen, and preventing me to use it, pointing to some authorization error). What I did is: I tried to reinstall…
simonelippolis
  • 53
  • 6
0
votes
1 answer

How to diagnose/fix CloudFormation/autoscaling SSL errors on file download

I have an autoscaling group that was created by AWS CloudFormation. It runs on Amazon Linux 2. Last week, it was working fine. Now, new instances throw a "certificate has expired" error when trying to download phpMyAdmin. It appears cfn-init is…
philolegein
  • 409
  • 4
  • 12
0
votes
2 answers

Browser downloads the file instead of opening php files

So, I'm posting an answer, because after the twice clean-reinstall, I have set things a but differently (to my point of view). Like I said above, I face a dilemma, since none of the config I have is the same as to any other answers I could find. For…
Kl3m Michard
  • 3
  • 1
  • 3
0
votes
1 answer

Accidentically remove grant privileges for root MySQL

I accidentically removed grant from the user_accounts tab (privileges) for root account I have this extra account backend_dev_team Now edit privileges clickable link is missing can I undo it? UPDATE GRANT ALL PRIVILEGES ON * . * TO…
Pablo
  • 255
  • 1
  • 4
  • 11
0
votes
1 answer

Apache: phpmyadmin on sub-domain "503 Service Unavailable": php7.4-fpm

I'm having a tough time trying to fix a major problem getting phpmyadmin working again (it used to work on ubuntu 16.04). I upgraded Ubuntu 16.04 to 20.04 yesterday and got the following versions of stuff: MySQL 8.0.23-0ubuntu0.20.04.1 for Linux on…
peppy
  • 73
  • 2
  • 10
0
votes
1 answer

file size exceeded the maximum size permitted phpmyadmin

I am getting following error while uploading file to phpmyadmin: No data was received to import. Either no file name was submitted, or the file size exceeded the maximum size permitted by your PHP configuration. See I am using nginx as web…
Hello World
  • 109
  • 1
  • 4
0
votes
1 answer

phpmyadmin error 502 Bad Gateway on nginex

i just installed phpmyadmin on my ubuntu 20.04 server but when I try to go to the site I have a 502 bad gateway error ... here is what I have in my LOG file : 2021/02/05 14:43:33 [crit] 662288#662288: *1 connect() to unix:/run/php/php-fpm.pid failed…
hari
  • 1
  • 1
0
votes
1 answer

phpmyadmin refresh does not refresh sometimes

I make an update using sqlalchemy #todo use update conn = engine.connect() metadata=MetaData() user = Table('user', metadata, autoload=True, autoload_with=engine) stmt = user.update().where(user.columns.id==user_id).\ values(age=age,…
seizouki
  • 15
  • 4
0
votes
1 answer

Change password length for MariaDB

I'm currently working with mariadb and phpmyadmin on my debian 10 server. For some reason mariadb only allows passwords with a maximum length of 79 characters. If I specify a password that is longer than 79 characters I can easily login to…
Torge Stehr
  • 5
  • 4
0
votes
1 answer

How to get phpmyadmin to work with both a reverse proxy and a plain IP:PMA_PORT connection?

I have a kubernetes cluster configured as follows: nginx+wp[:5050] <-- redirect 307 /wp nginx[:80:443] /pma rev_proxy --> nginx+pma[:5000] All services share a common external metallb IP. I have a couple of problems with this…
Alexander Chetverkin
  • 1
  • 1
  • 3
0
votes
1 answer

Xampp/PHPMyAdmin login issues

i know there are many topics and i read at least 40 of it, but none solved my Problem.. I can login to PHPMyAdmin only from the machine its running on... On others there is just an "Access denied". I created a new User with Hostname "%". And i can…
Schesam
  • 101
  • 2
1 2 3
…
14 15