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
3
votes
0 answers

Why do I get an OpenSSL Error when connecting PHPMyAdmin through SSL?

I'm running PHP 5.6.11 on Apache 2.2 with OpenSSL 1.0.1 on Ubuntu 12. I've sucessfully setup SSL in Apache and MySQL. Now I want to set up a PHPMyAdmin and connect it through SSL. I don't really need it on localhost, but I dont have another way to…
Riemu
  • 113
  • 2
  • 2
  • 7
3
votes
3 answers

phpmyadmin won't connect to remote MySQL instance

I have a LAMP stack box (CentOS 6) and another CentOS 6 box running mysql server. I've installed phpmyadmin on the LAMP box but I can not get it to talk to my SQL box at all. I have configured the following in config.inc.php /* Servers configuration…
wimnat
  • 61
  • 1
  • 5
2
votes
1 answer

How to fix phpMyAdmin with PHP 7.2 on RHEL7?

I've upgraded PHP from 5.4 to PHP 7.2 on a vanilla web server running RHEL7. The source of the PHP7.2 is RHSC using yum. I've also installed the standard supporting libraries for this version, including rh-php72-php-fpm, and started it as a…
Free Radical
  • 131
  • 9
2
votes
3 answers

Getting Error 404 running phpmyadmin as a sub-directory using Nginx

I have spent almost the entire day debugging this issue with my phpmyadmin installation getting error 404 when I run it using Nginx. I have Googled several pages online, but no solution has worked. However, when I run phpmyadmin as a domain, it…
David Okwii
  • 324
  • 1
  • 5
  • 13
2
votes
1 answer

Automated export of phpMyAdmin SQL download with wget

I'm using the following script to attempt to download an SQL export from a phpMyAdmin installation (adapted from this Stackoverflow question) read -p "Username: " USERNAME read -p "Password: "…
Jaap Joris Vens
  • 601
  • 3
  • 8
  • 20
2
votes
1 answer

Unable to log-in to phpMyAdmin after switching to php-fpm

I have a CentOS 7 server, running Apache 2.4. I use phpMyAdmin on it to connect to remote MySQL database instances (on Rackspace). MySQL is not running on the server. The phpMyAdmin config.inc.php has details of the remote Rackspace hostname. When…
Pete Coward
  • 51
  • 1
  • 5
2
votes
3 answers

On Which port phpMyAdmin connect to remote database

My centos 7 phpMyAdmin unable to connect to remote database as i think the security policy is not allowing it (port may be disabled by firewall). As i checked the same configuration on wamp phpmyadmin its able to connect with same entry in…
antoniomerlin
  • 121
  • 1
  • 1
  • 4
2
votes
1 answer

Setting up phpmyadmin to only connect to remote server

I've been stuck on this for a while, and was hoping you could provide some insight into what I'm doing wrong. I have a fresh amazon EC2 (Ubuntu 16.04) instance connected to an RDS (mysql) database, and am trying to install phpmyadmin on the amazon…
Justin Huffman
  • 23
  • 2
2
votes
1 answer

How to fix UI errors after installing phpMyAdmin on Ubuntu ServerPilot app

I'm following these instructions, but I'm using FileZilla on Mac OS instead of Cyberduck. I opted for installing it in my app's /public/ directory because I couldn't figure out how to access it if I installed it as its own app. I downloaded the…
intcreator
  • 123
  • 5
2
votes
2 answers

Centos 6; phpMyAdmin 'Cannot log in to the MySQL server' after moving mysql.sock

I recently moved my mysql datadir from /var/lib/mysql to a new directory /home/mysql mounted on a new hard drive. For neatness sake I thought it'd be nice to place the tmpdir and socket on this new hard drive. Everything works as planned, until I…
Arth
  • 365
  • 1
  • 5
  • 15
2
votes
1 answer

phpMyAdmin Multi Server Setup Issue - Server Choice Never Displayed

I have a phpMyAdmin installed in my Ubuntu-14.04 LTS server. I want to manage other MySQL databases in different servers (all Ubuntu) across my VPC. I have enabled access to the servers using the AWS security policy and opened the port 3306 over the…
arvind_mv
  • 21
  • 1
  • 2
2
votes
2 answers

Running phpMyAdmin and php-7 at the same time?

After upgrading php5 to php7, I get this error when I want to apt-get install phpmyadmin The following packages have unmet dependencies: phpmyadmin : Depends: libapache2-mod-php5 but it is not going to be installed or …
bytecode77
  • 253
  • 4
  • 11
2
votes
2 answers

Win7 apache2.4.9 phpmyadmin4.5.0.2 - an not connect for LAN

Everything is working fine - hosting a couple of my own sites, but would like to be able to maintain them from other PC's on the LAN. Works fine, except for phpmyadmin. Everything is set up to be able to do so. On other PC's I get a 403 error…
Birger Sørensen
  • 21
  • 1
2
votes
1 answer

phpMyAdmin server description instead of hostname

I installed phpMyAdmin 4.4.8 (latest version) and I configured some MySQL host I can connect to. Servers are listed with the $cfg['Servers'][$i]['host'] value in the server list and I cannot find out a way to configure a "description string" in the…
Mat
  • 1,873
  • 7
  • 25
  • 41
2
votes
2 answers

phpMyAdmin missing php-xml

I have an instance on AWS (Amazon Linux 2). I installed lamp on the server and access the phpMyAdmin. And I get this error: Composer detected issues in your platform: Your Composer dependencies require the following PHP extensions to be installed:…
CHOO YJ
  • 131
  • 6
1
2
3
…
14 15