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

Unable to Install PHPMyAdmin on CentOS 6

I am attempting to update all my software on my CentOS 6 Server. I have updated from PHP 5.6 to PHP 7.2 and now trying to install PHPMyAdmin 4.8 but I am getting an error when running the yum command. yum --enablerepo=remi,remi-test install…
Michael Smith
  • 103
  • 3
0
votes
4 answers

phpMyAdmin AuthType=config: mysqli_real_connect(): (HY000/2002): No such file or directory

When I attempt to load phpMyAdmin 4.8.0 using AuthType=config I get an error: Cannot connect: invalid settings. mysqli_real_connect(): (HY000/2002): No such file or directory phpMyAdmin tried to connect to the MySQL server, and the server…
Hiyo
  • 1
  • 1
  • 1
  • 2
0
votes
1 answer

remote phpMyAdmin automatically logs out at first click

I have ssh access on two remote virtual machines running Centos 7. The first hosts Apache 2, PHP 5.4 and phpMyAdmin 4.4. The second hosts MySQL 5.5. I created a MySQL user that is allowed to remotely connect to the databases I've created. I can…
firion
  • 99
  • 1
  • 5
0
votes
1 answer

Debian 9 Stretch nginx phpmyadmin 404 error

I installed phpmyadmin on Debian Stretch with nginx, but get 404 when navigating to http://blah.com/phpmyadmin, no errors in the logs. Here's my default file vi /etc/nginx/sites-available/default server { listen 80 default_server; listen…
batflaps
  • 179
  • 1
  • 3
  • 10
0
votes
2 answers

Google reCAPTCHA breaks phpmyadmin

Adding/enabling (you name it) google captcha in phpmyadmin config makes me stuck on the login page, token appears in the URL but I don't get the "control panel", so phpmyadmin becomes kinda useless. Turning on php error reporting gave me nothing, no…
Kristi
  • 91
  • 2
  • 10
0
votes
3 answers

Nginx global conf breaks Nginx (updated)

I've added the following global conf to the http block inside nginx.conf. The purpose is to cover all php apps (WordPress apps and PHPmyadmin) in one block of conf, instead creating multiple conf files and their symlinks. http { …
Arcticooling
  • 1
  • 3
  • 7
  • 22
0
votes
1 answer

MySQL: Suddenly connection error without making any changes

I'm running MySQL 5.6.30 - MySQL Community Server (GPL) on ubuntu-16.04-x86_64 and I'm using phpMyAdmin 4.7.7. Sometimes, without doing anything on the Server or phpMyAdmin, I'm getting this error message on my websites: Connection failed:…
user444061
0
votes
1 answer

Restrict myphpadmin to listen on specific ethernet adapter

I want to prevent phpmyadmin being accessible from the internet. I have two ethernet adapters on my CentOS 7 box, one 'internal' and one 'external'. I would like to restrict access so that users (any IP address) from the 'internal' network can…
Nathan McClintock
  • 1
  • 1
0
votes
0 answers

Bad request with phpmyadmin on nginx with ssl (no clr)

I have a simple nginx configuration playing as a proxy to handle ssl requests. The problem is when I log on phpmyadmin on https://files.mysite.com/phpmyadmin, it redirects me on http://files.mysite.com:443 and throw a : 400 Bad request: The plain…
gogaz
  • 109
  • 4
0
votes
2 answers

phpMyAdmin and Apache - Query string - 404 Error

When phpMyAdmin tries to access URL as https://example.com/phpmyadmin/server_variables.php&filter=long_query_time, Apache throws a 404 Error. What might be the problem? The requested URL /phpmyadmin/server_variables.php&filter=long_query_time was…
devondre
  • 103
  • 7
0
votes
1 answer

Restricted phpmyadmin to locahost doesn't work

This is my httpd-xampp.conf snippet for phpMyAdmin Alias /phpmyadmin "C:/xampp/phpMyAdmin/" AllowOverride AuthConfig #Require all granted Order Deny,Allow Deny from all Allow from 127.0.0.1 …
AFwcxx
  • 125
  • 5
0
votes
1 answer

Nginx return return GET local IP instead domain

I'm using nginx as reverse proxy for my VMs. When I try to authenticate myself in a my website, or in phpmyadmin, nginx return the reponse from the local IP when the POST is from a domain! Look: Nginx return a local IP instead the domain name Here…
poka
  • 135
  • 3
  • 13
0
votes
1 answer

PHPMyadmin redirection issues on Apache2

A couple of days back I updated Apache on the webserver. Which seems to have broken accessing Phpmyadmin through server IP: server.ip/phpmyadmin Instead now when typing above the ip/phpmyadmin it redirects to the domain which is hosted on the…
ASG
  • 1
  • 2
0
votes
0 answers

I cannot get data from the same database on different hosts with different versions of mysql-server

I have a web site that has moved to a new server. I moved the site to a web-server running apache24 and php56. It came from a server with apache24 and php55. When I use the old external (different host/server) database that runs mysql57 all goes…
Lexib0y
  • 227
  • 3
  • 14
0
votes
1 answer

Dependency error updating PHPMyAdmin

I apologize for my Linux knowledge which is really basic. I'm troubleshooting since a few hours trying different approaches but I'm still failing. When I try the following instruction: yum --enablerepo=remi,remi-test install phpMyAdmin…
Revious
  • 187
  • 1
  • 12
1 2 3
…
14 15