Questions tagged [phpmyadmin]
phpMyAdmin is a popular tool for administrating MySQL (and similar) databases
215
questions
0
votes
0
answers
32
views
phpmyadmin unable to login
Over the past couple of days I have usually not been able to login to phpMyadmin, but once I was able to. Either I get a blank screen of this message: This page isn’t working xx.xxx.xxx.xxx is ...
0
votes
0
answers
25
views
How to handle scaling upto 3k concurrent connections [duplicate]
So here's our use case:
We have firmware that connects to server (simple php file - that takes post request) and add the data (350-500 bytes per request) to database.
Now here's a issue we have 3k ...
0
votes
0
answers
49
views
Configure xenforo 1.2.9 Using phpmyadmin 4.x with php 5.6.4 on IIS 10, Windows Server 2019
Versions/Programs:
xenforo 1.2.9, phpmyadmin 4.x, php 5.6.4, MySQL 8.0.32 IIS 10, Windows Server 2019
I am trying to host a local server for tinkering on an old computer I have. This server will be ...
- 1
0
votes
0
answers
150
views
WampServer and error 404
Having just installed Wampserver on my system in order to test a PHP form I have created via Dreamweaver, I'm continually getting the Error 404 message on my screen despite following the installation ...
0
votes
1
answer
292
views
Unable to connect to server following phpMyAdmin upgrade from 5.1 to 5.2
Not sure to post on the right StackExchange forum. If not, let me know!
Working environment:
OpenSUSE Leap 15.4
MariaDB : mariadb Ver 15.1 Distrib 10.7.7-MariaDB
PHP 8.0.25 (cli) (built: Oct 31 2022 ...
- 75
0
votes
1
answer
208
views
How to upgrade a MariaDB database to utf8mb4_unicode_ci?
I have a Drupal 9.4.8 website a MariaDB database and phpMyAdmin.
My website is already active with data in its 220 MB database.
How to upgrade a MariaDB database to utf8mb4_unicode_ci ?
Here is my ...
- 1
0
votes
0
answers
54
views
phpmyadmin Mysql frozen in time
i got a remote mysql database connection to work on my on ubuntu 22.04. I see on the website that i setup that data gets into the database as users are active in the website but when i check ...
0
votes
0
answers
109
views
Error in Processing Request Error code: 403 Error text: Forbidden Apache2
Error in Processing Request Error code: 403 Error text: Forbidden
This kind of error pops up when i am trying to do anything that requires ajax in phpmyadmin.[enter image description here][1]
0
votes
0
answers
153
views
phpmyadmin install on Debian 10 fails. [proxy_fcgi:error]: error parsing URL //: Invalid host/port
I am trying to upgrade a phpmyadmin install on a (remote, VM) Debian 10 without success.
I followed install instructions at computingforgeeks.com, and at first - when i tried to access http://path.tld/...
- 101
0
votes
0
answers
88
views
Nginx for web server on raspberry pi, I want my sub folder to connect on web server
server {
listen 80 default_server;
listen [::]:80 default_server;
root /var/www/html;
index index.php index.html index.htm;
server_name _;
location / {
try_files $uri/ /...
0
votes
0
answers
512
views
Phpmyadmin not working after update
My phpmyadmin installation stopped working correctly, this is the error.log
[Fri Aug 12 20:11:10.749656 2022] [php:warn] [pid 2213] [client 181.161.145.134:58094] PHP Warning: require_once(PhpMyAdmin/...
- 101
-1
votes
2
answers
315
views
Unable to access phpMyAdmin
Anyone can help me
unable to access phpMyAdmin → http://34.100.189.79/phpmyadmin/
Regards
0
votes
1
answer
395
views
Copy large-size JSON content and paste it into MySQL column
I have a column with the data type "JSON" in the MySQL table(I have MySQL 8).
I have a 20 MB JSON file created by my BE code and I would like to copy and paste the contents of the JSON file ...
- 171
1
vote
1
answer
446
views
Is a valid SSL certificate important when accessing a localhost URL via SSH tunnel?
I've got a PHPMyAdmin installation set up, but accessible only via localhost. This means that to access the URL, I need to set up an SSH tunnel before I access the URL.
When I do so, however, I get a ...
- 311
0
votes
1
answer
286
views
Single Signon best practice for phpMyAdmin across multiple servers
I run a small web development company and we run multiple production servers, each with their own MySQL database server. I'm trying to figure out the best way of giving access to these separate MySQL ...
- 101
0
votes
1
answer
589
views
How to serve phpMyAdmin to localhost/phpMyAdmin instead of localhost:8080 using nginx in docker
In my project, I am using Django and nginx, but I want to manage my cloud databases through phpmyadmin.
Django is working fine but I can't do the same with phpmyadmin because it is running in apache ...
0
votes
1
answer
554
views
phpMyAdmin: change bind address of MySQL on phpmyadmin
How do I change the bind address of a mysql databse through phpmyadmin?
I am new at this and really dont know what I am doing.
- 3
0
votes
1
answer
373
views
phpMyAdmin with cloudflare ssl certificartes
I have 3 wordpress sites, 1 moodle site and 1 owncloud site, all with same apache configuration in my vps, and all of them works fine
But I'm not able to make phpMyAdmin work with cloudflare's origin ...
- 389
0
votes
1
answer
307
views
Can't login to phpMyAdmin on Centos, Google Cloud
In my MySQL database, I've created two users, one regular user (who has privileges for one database) and one superuser.
When I want to login via any of these accounts to phpMyAdmin I get a "...
google-cloud-platform
0
votes
0
answers
254
views
Mysql remote connect CentOS
i have problem with mysql remote connect.
In my.cnf have: bind-address = 0.0.0.0 and #skip-networking.
In users mysql have special user remote@%
And still not working.
If i try: nmap -p 3306 remote.ip....
0
votes
1
answer
344
views
ModSecurity 403, COMODO WAF detects XSS while trying to access phpMyAdmin
I have a copy of phpMyAdmin in one of my server in a subdomain 'pma' and inside a directory in it named 'app' (manual installed from zip archive, not via yum), which I use for DB related management ...
1
vote
1
answer
566
views
Enabling PHPMYADMIN Logging & Fail2ban Default Filter
I am on Debian 10.5 LAMP with ISPConfig, running PHPMYADMIN 4.9.0.1.
I installed phpmyadmin following this tutorial I can only guess that somehow ISPConfig may be interrupting something.
In any case, ...
- 193
1
vote
2
answers
382
views
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 ...
- 121
0
votes
1
answer
3k
views
Can't connect to mysql docker when using phpmyadmin docker
I'm just getting started in docker and maybe I'm starting of a little big but I found an article that explained out to get a coldfusion install (run by commandbox) up with mysql. This docker compose ...
- 101
0
votes
1
answer
591
views
Ubuntu 18.04: PHP stopped working after I tried to fix phpmyadmin
I have a problem with a Ubuntu 18.04.6 Ubuntu server.
I was trying to fix a problem with phpMyAdmin (a lot of errors appearing on screen, and preventing me to use it, pointing to some authorization ...
0
votes
1
answer
289
views
How to diagnose/fix CloudFormation/autoscaling SSL errors on file download
I have an autoscaling group that was created by AWS CloudFormation. It runs on Amazon Linux 2. Last week, it was working fine. Now, new instances throw a "certificate has expired" error when ...
- 389
0
votes
2
answers
3k
views
Browser downloads the file instead of opening php files
So, I'm posting an answer, because after the twice clean-reinstall, I have set things a but differently (to my point of view).
Like I said above, I face a dilemma, since none of the config I have is ...
1
vote
0
answers
70
views
Not permitted to view my newly installed phpMyAdmin
I'm using Google Compute Engine to host a couple applications under one .dev domain so SSL is required.
I have Apache installed based from this guide and my /var/www/ directory looks like:
- domain....
- 139
1
vote
0
answers
193
views
nginx does not find phpMyAdmin
nginx is searching for phpMyAdmin in the wrong location
my nginx config:
server {
listen 80;
listen [::]:80;
access_log /var/log/nginx/reverse-access.log;
error_log /...
- 11
0
votes
1
answer
438
views
Accidentically remove grant privileges for root MySQL
I accidentically removed grant from the user_accounts tab (privileges) for root account
I have this extra account backend_dev_team
Now edit privileges clickable link is missing can I undo it?
UPDATE
...
- 255
-1
votes
2
answers
77
views
How I can stop the DNS server to transfer directly to my website when access phpmyadmin
I have 4 web servers on the same domain and when I access 51.32.xx.xx/phpmyadmin It is directly changed to mydomain.com/phpmyadmin how I can stop it to change because I cannot access To another MySQL ...
- 23
1
vote
2
answers
596
views
After removing .htaccess can no longer access phpmyadmin
Raspbian running on raspberrypi 3+ apache 2.4
I was trying to secure my server a little better and I enabled .htaccess by changing apache2.conf line AllowOverride None to AllowOverride All and added a ...
- 11
0
votes
1
answer
783
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 ...
- 73
0
votes
1
answer
7k
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
...
- 109
1
vote
1
answer
384
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:
...
- 117
2
votes
1
answer
1k
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
2
answers
205
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 ...
- 23
2
votes
2
answers
8k
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 !
...
- 141
0
votes
1
answer
976
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: ...
- 1
2
votes
2
answers
583
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
1
answer
325
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....
- 15
0
votes
1
answer
1k
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
1
answer
3k
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 ...
1
vote
1
answer
493
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
# ...
- 11
0
votes
1
answer
144
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&...
- 101
0
votes
1
answer
116
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 ...
- 101
0
votes
0
answers
31
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
0
answers
293
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
1
answer
513
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
0
answers
37
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 ...
- 1