Questions tagged [phpmyadmin]
phpMyAdmin is a popular tool for administrating MySQL (and similar) databases
189
questions
0
votes
1answer
39 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
44 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
71 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
50 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
74 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
44 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
1k 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
106 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
168 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
31 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
247 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
1k 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
53 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
52 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
240 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
33 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
61 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
52 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
103 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
152 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
101 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
1answer
1k 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
393 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
47 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
661 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
62 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
260 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
526 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
340 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
277 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
48 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
213 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
136 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
59 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
406 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
1k 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
949 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
242 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 ...
1
vote
0answers
49 views
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 ...
0
votes
0answers
529 views
WAMP Server: Apache PHPMyAdmin login screen not showing
I have recently setup a WAMP server (Windows, Apache, MySQL, PHP) and i'm having trouble setting up PHPMyAdmin.
I didnt use XAMPP for any of this, i installed the services directly onto the server.
...
