12
votes
Accepted
blank page example.com/phpmyadmin with errors in browser's console
PHP-FPM in nginx: the buffer of fastcgi is not big enough.
Try adding this to your config:
fastcgi_buffers 8 512k;
fastcgi_buffer_size 256k;
fastcgi_send_timeout 5m;
fastcgi_read_timeout 5m;
...
- 358
8
votes
phpmyadmin forbidden in Nginx although permited
When you symlink a directory, you are telling nginx that "when you need to use /var/www/html/phpmyadmin, you should instead look at /usr/share/phpmyadmin/. And that directory is not under your webroot ...
- 28.1k
7
votes
PHPMyAdmin "#2006 - MySQL server has gone away" during login
Change config ssl to false like so:
$cfg['Servers'][$i]['ssl'] = false;
7
votes
How to export result of a MySQL query using phpMyAdmin 3.4.3?
On some query it's not possible in a direct way.
You must write the query result to a table through the create table as syntax
And then you can follow the normal export instructions: https://...
- 207
5
votes
completely remove phpmyadmin centos
You do realise that locate looks at a database cache with filenames (created nightly/manually with the updatedb command) and not at your live file system.
locate does not reflect the actual state of ...
- 80.3k
5
votes
Accepted
Nginx location blocks don't apply to .php files inside them?
In most PHP configurations, there is one location ~ \.php$ block that processes any URI that ends with .php, so adding restrictions to other location blocks will only affect the static files involved. ...
- 13.3k
5
votes
Unknown IP trying to sign in to my phpmyadmin
Part of having a public-facing server is that massive number of infected machines are constantly trying a huge number of possible resources in the hope of exploiting something. They'll try a lot of ...
- 353
4
votes
Accepted
Unable to Install PHPMyAdmin on CentOS 6
You have multiple issues here:
First, the repo ius is not compatible with remi repositories. Since you are using PHP from remi, you should disable and remove the IUS repo(s) (and find other sources ...
- 248k
3
votes
Accepted
#1146 - table doesn't exist but showing in sidebar in phpmyadmin
After Googling a lot I found the answer.
Restart your mysql
sudo mysql stop
sudo mysql start
Refresh the phpmyadmin page
- 181
3
votes
phpMyAdmin and Apache - Query string - 404 Error
This is completely normal, because a URL has these components with exactly these delimiters:
scheme://host:port/path?query
This means that the following URLs are completely different:
https://...
- 49.8k
3
votes
On Which port phpMyAdmin connect to remote database
The default port for MySQL is 3306.
A database server (such as MySQL) is the one actually running databases and queries. phpMyAdmin is simply a utility to manage the server. Make sure the service is ...
3
votes
Accepted
phpMyAdmin on CentOS 7 with NGINX returns blank page
I think the session folder is not writable by the web service
try to change permission
chmod -R 777 /var/lib/php/session
- 1,718
3
votes
Accepted
Can't install phpMyAdmin due to package dependency issue
EPEL is not compatible with Amazon Linux, despite Amazon's bizarre insistence on advising people to add it to their Amazon Linux instances. It cannot be made compatible, and even if by some miracle ...
- 248k
3
votes
Accepted
Error Phpmyadmin
I found a fix (also Ubuntu 18.04), I downgraded the package php-symfony-polyfill-apcu back to 1.6.0-2. It appears the version that was upgraded no longer includes all the same files, including the '...
- 46
2
votes
phpMyAdmin tries to install Apache
I'm kinda using your same stack (so no apache involve). What i like to use is
apt-get --no-install-recommends install phpmyadmin
And this will only install phpmyadmin withou apache
- 302
2
votes
Accepted
Centos 6; phpMyAdmin 'Cannot log in to the MySQL server' after moving mysql.sock
Unless you use the built-in default location PHP also needs to be explicitly configured with the location of the MySQL socket file in the php.ini file or in the connection string...
pdo_mysql....
- 80.3k
2
votes
nginx shows 200 ok status but doesn't load page
With the exception of the phpmyadmin addition, typically your /etc/nginx/sites-available/default file should look like so in order for it to process PHP:
# Add index.php to the list if you are using ...
- 229
2
votes
Accepted
Accessing phpmyadmin in Nginx directly from IP address (without a subdomain)
The server_name should contain the name(s) used to access the server. To access a server by IP address, it should contain the IP address.
For example:
server_name 192.0.2.1;
See this document for ...
- 13.3k
2
votes
phpmyadmin forbidden in Nginx although permited
The message
directory index of "/var/www/html/phpmyadmin/" is forbidden
indicates that nginx can't find the configured index document, so it tries to list the files (which is forbidden).
Check ...
- 25k
2
votes
Accepted
How to point phpmyadmin to same databases used in MySQL
Then you're either using different credentials and/or logging onto different Mysql servers, check with the mysql query select @@HOSTNAME; and/or select USER(); and update either you PHPMyAdmin config ...
- 80.3k
2
votes
Accepted
phpMyAdmin not working after upgrade from Ubuntu 16.04 to 18.04
It looks like the location of your PHP gettext directory changed with the upgrade, and you are using open_basedir to restrict which directories PHP files are loaded from.
To resolve the problem, ...
- 248k
2
votes
phpmyadmin database getting deleted automatically
Thoroughly read Making MySQL Secure Against Attackers and implement the recommendations.
Restrict access to the EC2 through Security Group
Only permit access to the database (port 3306) from the IP ...
- 25.5k
2
votes
Accepted
Phpmyadmin error in Ubuntu 18.04
Ubuntu repositories have an old phpmyadmin, not fully compatible with default PHP release (7.2 in Ubuntu 18.04 distribuiton).
To get rid of this error just install a newer phpmyadmin from https://...
- 1,709
2
votes
Accepted
Can't access phpmyadmin, because of a faulty DNS entry
you may set your desired "A" record in your localhost.
so if your client is Windows,then edit the following file and input the IP address of your web server as below:
for Windows OS:
C:\...
- 763
2
votes
Accepted
Why mysql server ignore cancel while deleting user
There is no "Cancel" feature in MySQL. MySQL only executes SQL queries written in SQL language.
PHPMyAdmin is a convenience tool to execute SQL queries on MySQL server. When you perform an ...
- 37.6k
2
votes
phpmyadmin error 502 Bad Gateway on nginex
You should not use the .pid file as backend contact point.
You need to use the .sock socket file for it.
- 37.6k
2
votes
Accepted
PhpMyAdmin Error 500 on table strucure page
Solution found! As I mentionned on https://github.com/phpmyadmin/phpmyadmin/issues/16620
I followed this Symfony bug solution https://github.com/symfony/symfony/commit/...
- 141
2
votes
phpMyAdmin in a seperate domain in centos 7
First of all, consider not installing phpMyAdmin:
phpMyAdmin is a completely unnecessary and insecure software that has already collected 252 CVE registered vulnerabilities over its lifetime.
If for ...
- 5,521
2
votes
file size exceeded the maximum size permitted phpmyadmin
PHP also has a post_max_size which can override upload_max_filesize as per the documentation. Set this value to be slightly higher than your upload value to cover other fields in that POST request.
...
- 31
2
votes
Accepted
phpMyAdmin: change bind address of MySQL on phpmyadmin
You can't.
You need to edit the configuration file of your MySQLd (usually in /etc/mysql).
- 25k
Only top scored, non community-wiki answers of a minimum length are eligible