Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [phpmyadmin]

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

0
votes
0answers
79 views

mysqli_real_connect(): (HY000/2002): No such file or directory

Well i'm facing this issue which happened after i installed httpd-mpm-itk and i tried googling and i couldn't find a similar issue as my problem. Here is my config.inc.php: $cfg['Servers'][$i]['...
0
votes
0answers
25 views

phpMyAdmin - forbids updating field with the strings “|powershell” or “|PHP”

Running this query on my 10.1.34 MariaDB database works fine from the command line: UPDATE `allbooks` SET `longDesc` = '|PHP: Hello World\r\n|Powershell: Hello World\r\n' WHERE `bookId`.`id` = 1001; ...
1
vote
1answer
83 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
38 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 ...
0
votes
0answers
25 views

cannot access phpmyadmin through varnish 6 on example.com/animalute/_pa_ad

I need to use different backends for different request urls and I've got a problem when I'm trying to access phpmyadmin. /* SET THE HOST AND PORT OF WORDPRESS * *************************************...
0
votes
0answers
25 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
147 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
171 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 ...
0
votes
1answer
726 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
149 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, ...
0
votes
2answers
387 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
174 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
120 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
49 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
246 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
128 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
585 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. ...
0
votes
0answers
7k views

phpMyAdmin AuthType=config: mysqli_real_connect(): (HY000/2002): No such file or directory

When I attempt to load phpMyAdmin 4.8.0 using AuthType=config I get an error: Cannot connect: invalid settings. mysqli_real_connect(): (HY000/2002): No such file or directory phpMyAdmin tried ...
0
votes
1answer
164 views

Automated export of phpMyAdmin SQL download with wget

I'm using the following script to attempt to download an SQL export from a phpMyAdmin installation (adapted from this Stackoverflow question) read -p "Username: " USERNAME read -p "Password: " ...
0
votes
1answer
151 views

remote phpMyAdmin automatically logs out at first click

I have ssh access on two remote virtual machines running Centos 7. The first hosts Apache 2, PHP 5.4 and phpMyAdmin 4.4. The second hosts MySQL 5.5. I created a MySQL user that is allowed to remotely ...
0
votes
1answer
381 views

Debian 9 Stretch nginx phpmyadmin 404 error

I installed phpmyadmin on Debian Stretch with nginx, but get 404 when navigating to http://blah.com/phpmyadmin, no errors in the logs. Here's my default file vi /etc/nginx/sites-available/default ...
0
votes
2answers
607 views

Google reCAPTCHA breaks phpmyadmin

Adding/enabling (you name it) google captcha in phpmyadmin config makes me stuck on the login page, token appears in the URL but I don't get the "control panel", so phpmyadmin becomes kinda useless. ...
1
vote
0answers
66 views

Is there a mysqlnd plugin to authenticate using ed25519

I setup my mariadb root user to authenticate using ed25519. Now I want to login using phpmyadmin but I'm getting the error mysqli_real_connect(): The server requested authentication method unknown to ...
0
votes
3answers
157 views

Nginx global conf breaks Nginx (updated)

I've added the following global conf to the http block inside nginx.conf. The purpose is to cover all php apps (WordPress apps and PHPmyadmin) in one block of conf, instead creating multiple conf ...
1
vote
2answers
5k views

phpmyadmin forbidden in Nginx although permited

I fail to understand why entrance to PHPmyadmin is forbidden (http://my_ip/phpmyadmin). Here's what I did to install it: On a pure Ubuntu 16.04 machine (server, xenial) I've installed LEMP with php-...
0
votes
1answer
156 views

phpMyAdmin: 403 Error when performing operations on database

The setup: I'm using phpMyAdmin on an AWS Amazon Linux AMI server, with Apache 2.4.27 and PHP 5.6.35. As of about two weeks ago, we've been unable to perform certain actions on the databases. We can ...
1
vote
1answer
248 views

Accessing phpmyadmin in Nginx directly from IP address (without a subdomain)

In an Ubuntu 16.04 Nginx environment which has some sites working fine, I've installed phpmyadmin: cd /var/www/html wget https://www.phpmyadmin.net/downloads/phpMyAdmin-latest-all-languages.zip find ....
0
votes
1answer
358 views

MySQL: Suddenly connection error without making any changes

I'm running MySQL 5.6.30 - MySQL Community Server (GPL) on ubuntu-16.04-x86_64 and I'm using phpMyAdmin 4.7.7. Sometimes, without doing anything on the Server or phpMyAdmin, I'm getting this error ...
0
votes
0answers
37 views

Phpmyadmin fails to connect for one VHost yet work fine with all the others

recently had to migrate to a new server so pretty much out of the box installation of Debian9.3, with ISPConfig3 installed through this script, which also installed last MariaDB, last PHPMyAdmin, and ...
1
vote
1answer
705 views

500 internal server error, when trying to access phpMyAdmin after installing VestaCP control panel [closed]

After installing VestaCP control panel I got a 500 internal server error when trying to access phpMyAdmin (on ubuntu 16.04). For web server using Lamp stack. How can I resolve this problem? After ...
1
vote
2answers
84 views

Errors after updating phpMyAdmin

After updating phpMyAdmin to v4.7.5 on my Apache/2.4.10 (Debian) I'm getting: The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated. Find ...
2
votes
0answers
348 views

phpmyadmin setup failing due to not prompting for root password

An error occurred while installing the database: │ │ ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using │ password: NO) . Why on earth is it not prompting me for the root ...
1
vote
0answers
341 views

MySQL and phpmyadmin are giving me errors

I was following instructions all over the internet and when I configured both MySQL and phpMyAdmin. phpMyAdmin gave me some errors and when I try to connect to mywebsite.com/phpmyadmin I get these two ...
-1
votes
1answer
4k views

Configure phpMyAdmin for NGINX server [closed]

I have installed phpMyAdmin with Homebrew on MacOS. The files appear to have been installed to: /usr/local/share/phpmyadmin/. I have installed NGINX, PHP-FPM and MySQL successfully. I'm using the ...
-1
votes
2answers
156 views

NGINX + phpmyadmin

I installed NGINX / mysql-server and phpmyadmin without an error - but when I am calling http://localhost/phpmyadmin it wants to download a binary file. Why is that so? I can access the normal ...
0
votes
1answer
60 views

Restrict myphpadmin to listen on specific ethernet adapter

I want to prevent phpmyadmin being accessible from the internet. I have two ethernet adapters on my CentOS 7 box, one 'internal' and one 'external'. I would like to restrict access so that users (any ...
0
votes
0answers
95 views

Bad request with phpmyadmin on nginx with ssl (no clr)

I have a simple nginx configuration playing as a proxy to handle ssl requests. The problem is when I log on phpmyadmin on https://files.mysite.com/phpmyadmin, it redirects me on http://files.mysite....
-1
votes
1answer
616 views

http://MY_IP/phpmyadmin brings me to download a 19kb PHP file on an Nginx environment with php-fpm7

http://MY_IP/phpmyadmin brings me to download a 19kb PHP file on an Ubuntu environment with Nginx 1.10.3 and php-7-fpm. After installing Nginx with apt-get install nginx mysql-server php-fpm php-...
0
votes
2answers
829 views

phpMyAdmin and Apache - Query string - 404 Error

When phpMyAdmin tries to access URL as https://example.com/phpmyadmin/server_variables.php&filter=long_query_time, Apache throws a 404 Error. What might be the problem? The requested URL /...
0
votes
1answer
47 views

Restricted phpmyadmin to locahost doesn't work

This is my httpd-xampp.conf snippet for phpMyAdmin Alias /phpmyadmin "C:/xampp/phpMyAdmin/" <Directory "C:/xampp/phpMyAdmin"> AllowOverride AuthConfig #Require all granted Order ...
0
votes
1answer
131 views

Nginx return return GET local IP instead domain [closed]

I'm using nginx as reverse proxy for my VMs. When I try to authenticate myself in a my website, or in phpmyadmin, nginx return the reponse from the local IP when the POST is from a domain! Look: ...
0
votes
1answer
89 views

PHPMyadmin redirection issues on Apache2

A couple of days back I updated Apache on the webserver. Which seems to have broken accessing Phpmyadmin through server IP: server.ip/phpmyadmin Instead now when typing above the ip/phpmyadmin it ...
1
vote
1answer
206 views

Unable to log-in to phpMyAdmin after switching to php-fpm

I have a CentOS 7 server, running Apache 2.4. I use phpMyAdmin on it to connect to remote MySQL database instances (on Rackspace). MySQL is not running on the server. The phpMyAdmin config.inc.php has ...
0
votes
0answers
21 views

I cannot get data from the same database on different hosts with different versions of mysql-server

I have a web site that has moved to a new server. I moved the site to a web-server running apache24 and php56. It came from a server with apache24 and php55. When I use the old external (different ...
0
votes
0answers
2k views

phpmyadmin cannot display user privileges

I have installed the following Database server - Server: Localhost via UNIX socket, Server type: MySQL, Server version: 5.7.18 - MySQL Community Server (GPL), Protocol version: ...
0
votes
1answer
686 views

Dependency error updating PHPMyAdmin

I apologize for my Linux knowledge which is really basic. I'm troubleshooting since a few hours trying different approaches but I'm still failing. When I try the following instruction: yum --...
1
vote
1answer
559 views

Nginx Reverse Proxy to LAMP server : can't login to phpmyadmin

I'm quite new to apache and even newer to reverse proxy, but I ended up installing a server with nginx (as a reverse proxy) and apache, to manage websites with different technologies. A php website (...
3
votes
1answer
1k views

Nginx location blocks don't apply to .php files inside them?

So to help prevent brute force attacks against my phpmyadmin install I've configured nginx to require HTTP Basic Auth (extra username and password) and then the requests need to come from a ...
0
votes
1answer
510 views

phpmyadmin creates the config.inc.php at http://localhost and not the config folder

I have followed the tutorial here to install mysql locally on mac Sierra but the phpmyadmin seems not to care creating the config.inc.php based on the above guide in the config folder which we create ...
0
votes
1answer
284 views

PHPmyadmin doesn't work on document root after successful Varnish install

Last week I installed Varnish and my websites are now working fine with it - I can navigate and change them without error. Back when I installed it, I putted Varnish on port 80 and moved Apache to ...