Questions tagged [phpmyadmin]
phpMyAdmin is a popular tool for administrating MySQL (and similar) databases
169
questions
-2
votes
0answers
61 views
The mysqli extension is missing. Please check your PHP configuration [closed]
I have this error. I don't know what to do.Until today it worked fine.
-1
votes
0answers
12 views
How can I solve issues with PHPmyadm access denied [closed]
I tried to access the phpmyadm and there was some error #1045 - Access denied for user 'username'@'localhost' (using password: YES). How could I solve this problem?
thank you
0
votes
1answer
31 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
16 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
46 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
36 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
49 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
54 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
58 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
69 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
22 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
699 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
45 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
96 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
329 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
528 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
287 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
133 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
367 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
183 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
417 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
153 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
814 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
98 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
627 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
235 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
1k 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
841 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
563 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
348 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
488 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
191 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
941 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.
...
