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
2
votes
1 answer

Getting 502 error while trying to run SQL query in SQL tab of phpmyadmin

However I am trying to run SQL request in SQL tab I receive 502 error, but same query in SEARCH tab works fine. I was using php-7.2 and phpmyadmin-5.0.2 when error appeared for the first time. I've read a lot of posts that issue happens due to low…
2
votes
2 answers

PhpMyAdmin Error 500 on table strucure page

I'm using PhpMyAdmin for a while on my Debian VPS but recently it started to make Error 500 when accessing the "Structure" tab for the tables (tbl_structure.php page)... and only this ! Error in processing request Error code: 500 Error text:…
E_D
  • 141
  • 1
  • 4
2
votes
2 answers

Error Phpmyadmin

i have this problem after updating ubuntu. It asked me if I wanted to update the configuration that it already had, and I said no. phpmyadmin was working correctly before the upgrade. If anyone knows the error, and how to solve it, I would…
1
vote
2 answers

Dependency error when Install PHPMyAdmin

I have a small VPS that managed via ISPCONFIG3 and CENTOS, recently I try to update its PHP version from 5.4 to 5.6 and 7.2 for Wordpress installation. I had a lot of errors but finally done. after that, my PHPMYADMIN didn't work. so I try to…
1
vote
1 answer

Can't access phpmyadmin, because of a faulty DNS entry

I've crashed my domain's DNS trying to enter a DKIM entry to my control panel, now I can't access my domain, my control panel or PHPMyAdmin because they all reside on my domain. Is there a way I can edit a DB entry from FTP, or I can take out the…
DN0300
  • 121
  • 2
  • 5
1
vote
1 answer

Phpmyadmin error in Ubuntu 18.04

I recently installed Mariadb with PhpMyAdmin and it seems to be working fine except when I need to browse a database. This is the error I get when browsing a column: “Warning in ./libraries/sql.lib.php#613 count(): Parameter must be an array or an…
tom keuper
  • 13
  • 3
1
vote
0 answers

Locked out of MySQL

So, I was playing around in the settings of phpMyAdmin on my DigitalOcean server. I looked at the security settings and saw the password hashing method dropdown. Being the idiot I was, I was making a social media app, so I thought it should have the…
1
vote
1 answer

phpmyadmin database getting deleted automatically

I am using aws ec2 t2 instance. Where I created few database as per my requirement. For last few day I noticed new databases which I create getting deleted automatically. Is there any possibility of automatically getting deleted? Current I have not…
user2129623
  • 169
  • 1
  • 1
  • 8
1
vote
1 answer

Cannot load phpmyadmin with apache2

Running Debian Stretch 9.5 with apache2. After upgrading from Debian 8, I can no longer access phpmyadmin from http://localhost/phpmyadmin. I get a page not found error. Everything looks good on the apache config side: apache2.conf contains…
StevieD
  • 514
  • 8
  • 24
1
vote
0 answers

Getting an error message on while installing any packages in Ubuntu 18.04

While trying to install any packages/apt in my ubuntu terminal after installing showing some error messages. for example, I'm trying to install zip sudo apt-get install zip after execution above command, I'll get this kind of error…
Kishore
  • 221
  • 2
  • 7
1
vote
1 answer

phpMyAdmin not working after upgrade from Ubuntu 16.04 to 18.04

I have an Ubuntu server with MySQL, Apache2 and phpMyAdmin. Today I made an upgrade from Ubuntu 16.04 to 18.04. Now I have the problem, that phpMyAdmin is showing just a blank white webpage without any content. I found these entries in the apache…
1
vote
1 answer

phpmyadmin works with http but forbidden with https

I have installed a new dedicated web server, and installed phpmyadmin, and it works. I have follow a tutorial that helps to secure phpmyadmin i.e. call phpmyadmin thru a subdomain like mysql.mydomain.tld + force it to HTTPS. It was working at the…
Bruno de Goyrans
  • 101
  • 1
  • 3
  • 10
1
vote
1 answer

Is there a mysqlnd plugin to authenticate using ed25519

I setup my mariadb root user to authenticate using ed25519. Now I want to login using phpmyadmin but I'm getting the error mysqli_real_connect(): The server requested authentication method unknown to the client [client_ed25519]. After some searching…
eciii
  • 141
  • 2
1
vote
1 answer

phpMyAdmin: 403 Error when performing operations on database

The setup: I'm using phpMyAdmin on an AWS Amazon Linux AMI server, with Apache 2.4.27 and PHP 5.6.35. As of about two weeks ago, we've been unable to perform certain actions on the databases. We can reach them just fine and browse tables with no…
1
vote
1 answer

Accessing phpmyadmin in Nginx directly from IP address (without a subdomain)

In an Ubuntu 16.04 Nginx environment which has some sites working fine, I've installed phpmyadmin: cd /var/www/html wget https://www.phpmyadmin.net/downloads/phpMyAdmin-latest-all-languages.zip find ./ -type f -iname '*phpmyadmin*.zip' -exec unzip…
Arcticooling
  • 1
  • 3
  • 7
  • 22
1 2
3
14 15