Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [phpmyadmin]

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

PMA is best known as a GUI for managing not only the data within a database, but the table structures as well. Because and other MySQL forks are similar enough they can also be administrated with this tool.

https://www.phpmyadmin.net/

phpMyAdmin is a free software tool written in PHP, intended to handle the administration of MySQL over the Web. phpMyAdmin supports a wide range of operations on MySQL and MariaDB. Frequently used operations (managing databases, tables, columns, relations, indexes, users, permissions, etc) can be performed via the user interface, while you still have the ability to directly execute any SQL statement.

Questions about this tool should be focused on the problems with setting it up and not using it to manage the database.

217 questions
1
vote
1 answer

Best Practice: What user should own "phpmyadmin" files/directories, and what should be the permission settings?

So I've searched for this answer, and can't seem to come up with anything relevant. So here goes: What is the best practice for ownership/permissions of the PHPMyAdmin files on a server? Thanks to all in advance.
Lee Fuller
  • 127
  • 6
1
vote
0 answers

"Deny from all" not working

I have made following configuration on httpd.conf. But, any IP still can access PHPMyAdmin URLs/aliases. What have I missed? Is this related with "Alias" directive? Alias /phpmyadmin /usr/share/phpmyadmin Alias /phpMyAdmin…
Mrxlazuardin
  • 11
  • 2
1
vote
2 answers

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 connect to the database server using the mysql…
Putnik
  • 2,217
  • 4
  • 27
  • 43
1
vote
1 answer

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.11.3-2.el5 installed However, if I…
TuK
  • 237
  • 1
  • 3
  • 9
1
vote
1 answer

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 MAMP.
Met
  • 19
  • 1
  • 3
1
vote
3 answers

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 = 0; // The $cfg['Servers'] array starts with…
tirenweb
  • 203
  • 1
  • 3
  • 11
1
vote
1 answer

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 warning saying that the SSL connection is unsafe…
John Doe
  • 323
  • 3
  • 16
1
vote
1 answer

Enabling PHPMYADMIN Logging & Fail2ban Default Filter

I am on Debian 10.5 LAMP with ISPConfig, running PHPMYADMIN 4.9.0.1. I installed phpmyadmin following this tutorial I can only guess that somehow ISPConfig may be interrupting something. In any case, I am trying to setup the default…
Maestro223
  • 203
  • 2
  • 13
1
vote
0 answers

Not permitted to view my newly installed phpMyAdmin

I'm using Google Compute Engine to host a couple applications under one .dev domain so SSL is required. I have Apache installed based from this guide and my /var/www/ directory looks like: - domain.dev/ (currently in use - WordPress site) - html/ …
dokgu
  • 139
  • 7
1
vote
0 answers

nginx does not find phpMyAdmin

nginx is searching for phpMyAdmin in the wrong location my nginx config: server { listen 80; listen [::]:80; access_log /var/log/nginx/reverse-access.log; error_log /var/log/nginx/reverse-error.log; root…
Vlad
  • 11
  • 1
1
vote
2 answers

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 .htaccess file to phpmyadmin path located at…
user1884295
  • 11
  • 3
1
vote
1 answer

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: server { listen 80; server_name…
Carol.Kar
  • 117
  • 6
1
vote
1 answer

How to add multiple path on same port VirtualHost

I want to add multiple paths like "localhost:8080/phpmyadmin" and "localhost:8080/index.php" but it doesn't want to work I create a phpmyadmin.conf in conf-availables with # phpMyAdmin default Apache configuration Alias…
rmarquet21
  • 11
  • 1
1
vote
1 answer

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:127.0.0.1:3306 root@example.com -N -v It works,…
Francesco Galgani
  • 143
  • 8
1
vote
1 answer

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 following errors are shown on the login page: Cannot log in…
cieG4eamide8
  • 11
  • 3
1 2 3
…
14 15