Questions tagged [phpmyadmin]

phpMyAdmin is a popular tool for administrating MySQL (and similar) databases

Filter by
Sorted by
Tagged with
0
votes
1answer
24 views

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 ...
1
vote
0answers
29 views

403 Forbidden Error when accessing PHPMyAdmin

I was using PHPMyAdmin with apache and everything was working fine. but then I stopped apache and set up Nginx on Linux mint. So I wanted to run my PHPmyadmin on Nginx and I run sudo ln -s /usr/share/...
-1
votes
1answer
49 views

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 ...
1
vote
1answer
49 views

Only certain countries can access particular route

I am using nginx/1.18.0 (Ubuntu) on an Ubuntu 20.04.1 LTS machine. I have a laravel project and phpmyadmin running. My /etc/nginx/sites-enabled/example-application file looks like the following: ...
1
vote
1answer
56 views

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 ...
-1
votes
2answers
39 views

phpMyAdmin in a seperate domain in centos 7 [closed]

The issue right now is that I want to maintain a database and I have planned to manage that with phpmyadmin and i have configured it but right now what it looks like is mydomain.com/phpmyadmin What ...
2
votes
2answers
543 views

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 ! ...
0
votes
1answer
59 views

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: ...
2
votes
2answers
166 views

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 ...
0
votes
0answers
28 views

What's the reason behind phpmyadmin .htaccess http login basic auth disappearing?

I apologize in advance if my English is not perfect, I'm totally new also in this environment, I'm using as web server apache 2.4, as per title I installed phpmyadmin for database access, the problem ...
0
votes
1answer
167 views

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....
0
votes
1answer
208 views

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 ...
0
votes
1answer
938 views

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 ...
0
votes
0answers
37 views

Modifications for securing the phpMyAdmin are not visible on the mywebsite.com/phpmyadmin

I want to secure www.mywebsite.com/myPhpAdmin link with extra security check and eventually allowing just an IP to have access to it. I have in /etc/httpd/conf.d/ 2 files. One file phpMyAdmin.conf ...
0
votes
0answers
47 views

EC2 Linux 2 Nginx with PhpMyAdmin

I installed NGINX in my EC2, and succefully I added two websites creating a .conf under /etc/nginx/conf.d/ and they are reachable. Now I'm trying to install phpmyadmin using this guide https://docs....
1
vote
1answer
38 views

How to add multiple path on same port VirtualHost

I want to add multiple paths like "localhost:8080/phpmyadmin" and "localhost:8080/index.php" but it doesn't want to work I create a phpmyadmin.conf in conf-availables with # ...
0
votes
1answer
51 views

Xampp/PHPMyAdmin login issues [closed]

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&...
0
votes
0answers
192 views

Having problems setting up reverse proxy with phpmyadmin:php-fpm

I'm trying to install phpmyadmin, using the docker image phpmyadmin/phpmyadmin:fpm-alpine, below the docker-compose.yml section of it: pma: container_name: "www-pma" restart: ...
0
votes
1answer
32 views

Is there “another” way of getting log information on SFTP activity?

I'm administrating a debian server since last week. It used to have another administrator. I presume it's been hacked: files might have been read via SFTP to obtain information about a site that's ...
0
votes
0answers
22 views

CDN SSL Authentication reliablity

I was having SSL on my main domain. which is let say , "example.com" & it only showed lock/HTTPS icon on "example.com" not any subdomain eg. abc.example.com , xyz.example.com ...
0
votes
0answers
58 views

PHPMYADMIN You're speaking plain HTTP to an SSL-enabled server port

/etc/apache2/sites-available/phpmyadmin: <VirtualHost *:133> ServerName phpmyadmin DocumentRoot /var/www-133 </VirtualHost> /etc/apache2/ports....
0
votes
1answer
49 views

Server is downloading phpmyadmin php file

It seems that when I try to access phpmyadmin, the index file is downloaded. I don't understand the reason. I have installed php and also have configured it in the configuration. # Expires map map $...
0
votes
0answers
17 views

Import path when using import on remote server

As many others I have a db that is too large and bigdump does not seem to work, the page script appears all garbled with code, so I go for the command but cant find the correct path to my database. I ...
0
votes
0answers
97 views

Running on 404 with PHP pages on Nginx

I'm fairly new to servers and am setting up my first web server with Nginx to use PHPMyadmin (as well as SSL, and Wordpress). The OS I'm working on is a Debian 10 Docker image. I'm following this ...
0
votes
2answers
132 views

LIGHTTPD PHPMYADMIN How can I configure PhpMyAdmin to only work on a specific Subdomain

So I have a small server with Lighttpd and I have installed PhpMyAdmin on it. This is the default configuration. The Computer is accessible from the Internet on Port 80. How can I make phpMyAdmin to ...
1
vote
1answer
92 views

Slowness of an ssh tunnel to use phpmyadmin

I installed phpmyadmin locally (on Linux Mint 19), with which I manage mysql 5.7 databases on a remote VPS (running Ubuntu 18.04), via ssh tunnel. I create the tunnel with this command: ssh -L 3307:...
-1
votes
1answer
71 views

Why mysql server ignore cancel while deleting user [closed]

I created user called "Try" where global privileges I set it to all privileges and once I checked it and delete it with "Drop the databases that have the same names as the users." ...
0
votes
0answers
109 views

How to export Query result from PHPMyAdmin into a CSV file

I want to export query result into CSV file from PHPMyAdmin How to do that? I have selected data from 5 different tables here is my query SELECT n.id , n.gazette_notice_id , n.notice_code ...
0
votes
0answers
126 views

How to host a site using apache2 on Ubuntu 20.04 with ip_adress/phpmyadmin accessible

I have a VPS setup with Ubuntu 20.04 and LAMP installed. I could access phpmyadmin then via <ip_address>/phpmyadmin. Later I enabled a virtualhost at /etc/apache2/sites-available/ by adding ....
0
votes
1answer
973 views

Blocking phpmyadmin from internet, allow only from lan in nginx

I'm running 2 websites on a LEMP stack with nginx configured as a reverse proxy server. I have successfully installed phpmyadmin in the root folder of one of my sites root directories. When I go to ...
1
vote
3answers
327 views

Unknown IP trying to sign in to my phpmyadmin

I am very worried. I have a little web server hosting a PhpMyAdmin page (in which they are some important databases). Yesterday, I posted a full new webpage on my server (but a very simple HTML and ...
0
votes
1answer
46 views

Unable to access the phpmyadmin on xamp server

occurred: Tried to change the privilege on database. issue one : i don't know what i did on Privilege window after that i con't able to run mysql on xamp so i tried to find a solution on internet so ...
1
vote
1answer
599 views

phpmyadmin: SSL is used without certification authority

How to get rid of 'SSL is used without certification authority' in the phpMyAdmin UI? When I add this line to config.inc.php: $cfg['Servers'][$i]['ssl_ca'] = '/path/to/ca.pem' ... then the ...
-2
votes
1answer
59 views

MySQL , sysadmin, root access [closed]

When enter to terminal: MySQL -u root -p I get answer: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)bash: Cd: /path/to/directory : No such file or directory ...
0
votes
0answers
229 views

Cannot access phpMyAdmin through VPN

External Machine cannot access phpmyadmin through VPN on USG. I get the FORBIDDEN You Dont' have permission to access /phpmyadmin on this server." Internal Machine has no issue. I have whitelisted ...
0
votes
2answers
481 views

phpmyadmin not displaying picture from database

I have a phpmyadmin setup and all is fine and well but I can't seem to get the interface to display the pictures from the database, What could be the issue ? I've enabled the gd2 extension in php , ...
0
votes
2answers
292 views

How to import/upload a WordPress database without access to Cpanel

I finished a WordPress project. I already uploaded all the files through FTP, now I have to import the database, but the client doesn't want to give me access to Cpanel. How can I import / upload the ...
0
votes
2answers
63 views

WordPress - phpMyAdmin - Database has been wiped [closed]

This morning I got a message from an editor of a WordPress site on a domain that I manage. The wordpress site had reset to default. I logged into the Plesk panel and the media content is still there ...
0
votes
1answer
259 views

Difficulties with Fail2Ban on PhpMyAdmin on CentOS

I am Brazilian and I still try to adapt with the English language. I'm having a hard time getting Fail2Ban to work on phpmyadmin. I'm using CentOS 8.1.1911 and fail2ban 0.10.5-2. My PhpMyAdmin is ...
0
votes
2answers
46 views

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 ...
0
votes
1answer
202 views

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 ...
0
votes
1answer
126 views

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 ...
1
vote
2answers
2k views

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 ...
1
vote
1answer
57 views

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

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 ...
0
votes
1answer
384 views

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 ...
0
votes
0answers
86 views

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: ...
1
vote
1answer
976 views

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....
0
votes
0answers
62 views

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=...
0
votes
2answers
887 views

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 ...
0
votes
0answers
236 views

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 ...