Questions tagged [phpmyadmin]

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

Filter by
Sorted by
Tagged with
0
votes
0answers
6 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
23 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
32 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 ...
0
votes
2answers
100 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
17 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 ...
0
votes
0answers
47 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
37 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
53 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
60 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
59 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
60 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
77 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
0answers
23 views

Can't find phpmyadmin.conf to add in fail2ban jail

I have installed webmin and virtualmin on Debian 9.11 (stretch). I installed phpmyadmin from "Virtualmin/Install Scripts", then i move phpmyadmin folder to /home/site/public_html/phpmyadmin I want to ...
0
votes
2answers
35 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
137 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
76 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
721 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
46 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
253 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
70 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: ...
0
votes
0answers
99 views

phpMyAdmin not working with lamp stack on Centos 7

I'm running: Centos 7 PHP version 7.3 Apache/2.4.39 mysqlnd 5.0.12 phpMyAdmin-4.4.15.10-3.el7.noarch My issue is after installing phpMyAdmin and changing the config file to this: Alias /phpMyAdmin /...
0
votes
0answers
342 views

laravel 404 not found

`I installed laravel on centos 7 .Laravel's home page works fine but when I try to connect myipaddres/phpmyadmin ,I am getting 404 not found error.I don't know what error message I have to show you to ...
0
votes
0answers
42 views

phpmyadmin shows plain source-code but php is working

First of all: Apache 2.4.25, Debian 9, PHP 7.2 I know - my problem isn't new and there are a lot of threads on the web which deal with it. Unfortunately there's no solution for me. I've a subdomain ...
1
vote
1answer
546 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
39 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
296 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
134 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
42 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
370 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. ...
-1
votes
1answer
189 views

Can't install phpMyAdmin due to package dependency issue

When I run the command sudo yum --enablerepo=epel install phpmyadmin it returns the following package dependency error: Error: Package: php-mcrypt-5.3.3-5.el6.x86_64 (epel) Requires: ...
-1
votes
2answers
421 views

Having Trouble Setting Subdomains On NGINX

I'm currently setting up OpenMediaVault on my Rock64 Single Board PC which is based off Debian and is configured through the web GUI running from NGINX on port 80. I'm currently trying to install ...
0
votes
0answers
158 views

How to add a location for PHPMyAdmin in NGINX?

I have a webserver running on port 4567 and my website running on port 80 & 443 (SSL) so I moved from Apache to Nginx to support load balancing. Everything is working fine with the below script ...
0
votes
0answers
832 views

Receiving “Failed to store CSRF token in session! Probably sessions are not working properly” when trying to open phpMyAdmin on IIS

I'm trying to run phpMyAdmin for the first time on a sever running 2019 windows sever, however when I try to open localhost/phpMyAdmin I receive this error displayed on the web page "Failed to store ...
0
votes
0answers
99 views

phpmyadmin - Out of memory (allocated 1008730112) (tried to allocate 377483264 bytes)

I have phpmyadmin on a local PC that is not exposed to the Internet, for development purposes only. I have edited php.ini to allow unlimited size files, unlimited processing time, set Memorylimit to ...
2
votes
1answer
638 views

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

phpmyadmin database getting deleted automatically [closed]

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

Apache Start Fails due to missing mpm module

I originally posted this question on StackOverflow. Before it was taken down as off topic, the answer and comments were leading to MPM not being loaded I tried sudo apt-get install apache-mpm-prefork ...
1
vote
1answer
236 views

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

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

Nginx reverse proxy to PHPMyAdmin returns 404

On my network I have two servers: One proxy-server (ip: 192.168.1.10) using nginx to handle all incoming HTTP requests. One web-server (ip: 192.168.1.33) running Apache2 and PHPMyAdmin I want the ...
0
votes
1answer
851 views

NGINX + php7.0-fpm + phpmyadmin

Disclaimer: I've tried tips listed in probably every google result on the first 2 pages. None of them worked for me. This is not a duplicate. I'm running Debian 9 in LXC container that had LAMP ...
1
vote
1answer
2k views

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

htpasswd keeps asking for password - phpmyadmin

I am using Ubuntu 18.04 LTS Desktop to host an apache2 webserver. I installed phpmyadmin and wanted to secure it using htpasswd. There for I edited the /etc/apache2/conf-available/phpmyadmin.conf, ...
1
vote
2answers
3k views

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

504 Gateway Time-out after executing SQL query

I executed a SQL query via phpmyadmin, to delete all tables of my test database, after a failed import. First there was a pop-up saying "Loading" in the middle of the screen, but I was getting ...
1
vote
1answer
491 views

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

How to point phpmyadmin to same databases used in MySQL [closed]

I installed mysql-server on Ubuntu 18.04 and then installed phpmyadmin. The issue I have now is when I do show databases in mysql, I get a different set of databases from what is shown in phpmyadmin. ...
0
votes
1answer
2k views

Phpmyadmin fails to import sql files

I exported all tables from my database with the option "Export tables as separate files". This worked perfectly, the tables were packed to a zip file: However, If I try to import them, I get this: ...
-1
votes
1answer
142 views

accessing phpmyadmin and web pages on cloned server [closed]

I created a clone of my server and would like to use phpmyadmin to trim down the mySQL databases on the clone. Can't figure out how to access it. On my live server, the URL is: http://mydomain/db12/...
0
votes
1answer
945 views

Unable to Install PHPMyAdmin on CentOS 6

I am attempting to update all my software on my CentOS 6 Server. I have updated from PHP 5.6 to PHP 7.2 and now trying to install PHPMyAdmin 4.8 but I am getting an error when running the yum command. ...