Questions tagged [phpmyadmin]
phpMyAdmin is a popular tool for administrating MySQL (and similar) databases
218
questions
50
votes
5
answers
127k
views
How to export result of a MySQL query using phpMyAdmin 3.4.3?
I've got a 30K row table
When I run a long, 50-line query on that table, a GROUP function reduces the number of rows to 7K
I want to export the grouped 7K rows as a new table, or save them as a
CSV
...
- 501
23
votes
3
answers
14k
views
Is there any way to disable grouping databases in phpMyAdmin?
If you have db names like
test_db1
test_db2
phpmyadmin would create a group test. The group appears in the left side-bar with related databases displayed under it.
How can I disable this feature?
- 2,514
11
votes
1
answer
2k
views
blank page example.com/phpmyadmin with errors in browser's console
I have installed phpmyadmin and symlinked it on my LEMP server(php 7).But when i goto hostname/phpmyadmin it returns a blank page with phpmyadmin icon on titlebar.
And 3 errors in browser's console:
...
- 215
5
votes
1
answer
4k
views
phpMyAdmin uses port 80 on CloudFlare Flexible SSL
I currently have 3 websites on a dedicated server (running on one IP address).
For one of the sites, SSL is active on the server and phpMyAdmin runs fine. After you log in you are redirected to the ...
- 71
5
votes
0
answers
4k
views
Invalid key length error when trying to connect phpmyadmin to remote MySql over SSL
I get these error messages when logging in to phpmyadmin instance
Error during session start; please check your PHP and/or webserver log file and configure your PHP installation properly. Also ...
- 537
4
votes
2
answers
34k
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-...
4
votes
1
answer
3k
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 ...
user353498
4
votes
1
answer
2k
views
nginx shows 200 ok status but doesn't load page
I have installed nginx,php7.0-fpm and mysql on my ubuntu 16.04 server. Everything works fine however It doesn't load a setup page of phpmyadmin. Below is my phpmyadmin nginx block.
location /...
- 1,587
4
votes
5
answers
14k
views
phpmyadmin on apache2 reload: Unknown Authz provider: valid-user error
After standard installation of phpmyadmin on Ubuntu 14.04 I found <site>/phpmyadmin doesn't work. After googling it, I found this can be solved with adding this line
Include "/etc/apache2/...
- 913
4
votes
3
answers
2k
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 ...
- 343
3
votes
2
answers
17k
views
PHPMyAdmin "#2006 - MySQL server has gone away" during login
First: I've searched all over Google and although this looks like an infamous error, none is actually my case and hence no fix is available.
OK so today I encountered this something weird: PHPMyAdmin ...
- 171
3
votes
3
answers
7k
views
phpmyadmin won't connect to remote MySQL instance
I have a LAMP stack box (CentOS 6) and another CentOS 6 box running mysql server.
I've installed phpmyadmin on the LAMP box but I can not get it to talk to my SQL box at all.
I have configured the ...
- 61
3
votes
2
answers
10k
views
#1146 - table doesn't exist but showing in sidebar in phpmyadmin
I copy my database files from windows
wamp/bin/mysql/mysql5.6.17/data
into my ubuntu
/var/lib/mysql/
Folders of my database_name and ibdata1, ib_logfile0, ib_logfile1 files.
Now my all databases ...
- 181
3
votes
1
answer
886
views
phpMyAdmin export, half file compressed?
Okay, I have to admit, that I derped up. I've exported a database from a to-be-reinstalled server and didn't check that file.
Now, that I try to import it, I've discovered something very strange, the ...
- 33
3
votes
1
answer
4k
views
Find source of sleeping mysql connections
We have a very large number of PHP scripts running on our server that do a variety of things. Lately I've noticed that when looking in PHPMyAdmin there are a large number of connections to our MySQL ...
- 167
3
votes
1
answer
7k
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 ...
- 143
3
votes
0
answers
2k
views
Why do I get an OpenSSL Error when connecting PHPMyAdmin through SSL?
I'm running PHP 5.6.11 on Apache 2.2 with OpenSSL 1.0.1 on Ubuntu 12. I've sucessfully setup SSL in Apache and MySQL.
Now I want to set up a PHPMyAdmin and connect it through SSL. I don't really need ...
- 123
2
votes
2
answers
5k
views
Running phpMyAdmin and php-7 at the same time?
After upgrading php5 to php7, I get this error when I want to apt-get install phpmyadmin
The following packages have unmet dependencies:
phpmyadmin : Depends: libapache2-mod-php5 but it is not going ...
- 253
2
votes
2
answers
762
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 ...
2
votes
1
answer
2k
views
phpMyAdmin server description instead of hostname
I installed phpMyAdmin 4.4.8 (latest version) and I configured some MySQL host I can connect to.
Servers are listed with the $cfg['Servers'][$i]['host'] value in the server list and I cannot find out ...
- 1,913
2
votes
3
answers
64k
views
On Which port phpMyAdmin connect to remote database
My centos 7 phpMyAdmin unable to connect to remote database as i think the security policy is not allowing it (port may be disabled by firewall). As i checked the same configuration on wamp phpmyadmin ...
- 121
2
votes
2
answers
11k
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
2
votes
3
answers
16k
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. ...
- 334
2
votes
2
answers
3k
views
Centos 6; phpMyAdmin 'Cannot log in to the MySQL server' after moving mysql.sock
I recently moved my mysql datadir from /var/lib/mysql to a new directory /home/mysql mounted on a new hard drive.
For neatness sake I thought it'd be nice to place the tmpdir and socket on this new ...
- 405
2
votes
2
answers
491
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 ...
- 131
2
votes
2
answers
4k
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 ...
2
votes
1
answer
1k
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, ...
- 131
2
votes
1
answer
833
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 ...
2
votes
1
answer
1k
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 ...
- 51
2
votes
1
answer
3k
views
phpMyAdmin Multi Server Setup Issue - Server Choice Never Displayed
I have a phpMyAdmin installed in my Ubuntu-14.04 LTS server. I want to manage other MySQL databases in different servers (all Ubuntu) across my VPC. I have enabled access to the servers using the AWS ...
- 21
2
votes
1
answer
2k
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 ...
2
votes
1
answer
940
views
Setting up phpmyadmin to only connect to remote server
I've been stuck on this for a while, and was hoping you could provide some insight into what I'm doing wrong.
I have a fresh amazon EC2 (Ubuntu 16.04) instance connected to an RDS (mysql) database, ...
2
votes
1
answer
187
views
How to fix UI errors after installing phpMyAdmin on Ubuntu ServerPilot app
I'm following these instructions, but I'm using FileZilla on Mac OS instead of Cyberduck. I opted for installing it in my app's /public/ directory because I couldn't figure out how to access it if I ...
- 123
2
votes
2
answers
516
views
Win7 apache2.4.9 phpmyadmin4.5.0.2 - an not connect for LAN [closed]
Everything is working fine - hosting a couple of my own sites, but would like to be able to maintain them from other PC's on the LAN.
Works fine, except for phpmyadmin.
Everything is set up to be ...
2
votes
1
answer
781
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: " ...
- 651
1
vote
2
answers
931
views
phpMyAdmin tries to install Apache
I'm playing up with installing new environments on my server, Nginx webserver in conjunction with HHVM.
I installed both, then came to MariaDB and installed it as well. I can confirm server's working ...
- 121
1
vote
1
answer
823
views
Updating phpMyAdmin
I'm running CENTOS 5.7 I have phpMyAdmin - 2.11.11.3 installed via yum.
Trying to update to 3.5.6.
If I run:
yum list installed | grep phpMyAdmin
I get:
phpMyAdmin.noarch 2.11....
- 237
1
vote
1
answer
3k
views
How to enable displaying "Choose column to display" in phpMyAdmin?
I read here you found a solution to the question in the title:
How to enable displaying "Choose column to display" in phpMyAdmin?
Could you explain how you enabled that?
I'm using phpMyAdmin under ...
- 19
1
vote
3
answers
38k
views
phpMyAdmin: #1045 - Access denied for user 'root'@'localhost' (using password: YES).
I am getting in phpMyAdmin the famous #1045 error: Access denied for user 'root'@'localhost' (using password: YES).
This is my /etc/phpmyadmin/config.inc.php:
/**
* Server(s) configuration
*/
$i =...
- 203
1
vote
1
answer
1k
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 ...
- 365
1
vote
1
answer
331
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 ...
- 121
1
vote
1
answer
1k
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....
- 13
1
vote
1
answer
3k
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 ...
- 169
1
vote
1
answer
3k
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 ...
- 203
1
vote
1
answer
2k
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 ....
1
vote
1
answer
815
views
Why nginx alias returnes 404 on .php files?
This configutation works:
location /phpmyadmin {
root /usr/share/;
index index.php index.html index.htm;
location ~ ^/phpmyadmin/(.+\.php)$ {
try_files $uri =404;
root /...
- 166
1
vote
2
answers
19k
views
phpMyAdmin error #2002 "Cannot log in to the MySQL server", but works from console
The MySQL service on my CentOS 6.3 server works well. I'm using phpMyAdmin-3.5.8.1 from default repository. I have sites that can connect to the databases and are using them successfully.
I can also ...
- 2,347
1
vote
2
answers
895
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
1
vote
1
answer
651
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
1
vote
1
answer
454
views
Slowness of an ssh tunnel to use phpmyadmin
I installed phpmyadmin locally (on Linux Mint 19), with which I manage mysql 5.7 databases on a remote VPS (running Ubuntu 18.04), via ssh tunnel.
I create the tunnel with this command:
ssh -L 3307:...
