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
0
votes
1 answer

Install PhpMyAdmin on nginx - on every domain?

I installed nginx with php and mysql. The problem is that I have no default domain site/file in "sites-available". I want to configure /phpmyadmin to be accessible from every domain. After the installation though, I see the error 404, how can I fix…
Кристиян Кацаров
  • 99
  • 3
0
votes
1 answer

Weird connect to remote mysql database issue

I can connect to my mysql database through command line when specifying the exact IP: mysql -u root -p -h 172.31.110.55 I am on aws, but when I try to connect using the DNS, I get this error: $ mysql -u root -p -h…
justadev
  • 393
  • 2
  • 4
  • 20
0
votes
1 answer

completely remove phpmyadmin centos

I removed phpmyadmin on my CentOS server by typing yum erase phpmyadmin Then I checked if it's still in the server by locate and it displayed…
Agent366
  • 11
  • 1
  • 1
  • 1
0
votes
1 answer

How can I export a database from phpMyAdmin when the "Export" tab is missing?

My Webhost has disappeared, possibly because the company has gone out of business. I no longer have access to cloud-based backups which my host created on a daily basis, however I still have access to phpMyAdmin (version 3.5.4). Within phpMyAdmin,…
user1468810
  • 101
0
votes
1 answer

error “The json extension is missing. Please check your PHP configuration.” displayed after installng phpmyadmin

Installed phpmyadmin and tried to access http://www.example.com/phpmyadmin, but error displayed in my browser error : " The json extension is missing. Please check your PHP configuration." My configuration: PHP 7.0.7 (cli) Apache/2.4.6 Red Hat…
chiju melveettil
  • 17
  • 1
  • 3
0
votes
0 answers

phpMyAdmin asks for BasicAuth

When accessing the phpMyAdmin link (mydomain.com/phpMyAdmin/), I am being prompted with a BasicAuth pop-up. The phpMyAdmin/config.inc.php does not overwrite any defaults, therefore the config.default.php is used, which has auth_type set as…
Chris Dev
  • 117
  • 6
0
votes
1 answer

Replacing mysql with MariaDB

phpMyAdmin shows this version ! I am new to Linux and servers. I was using mysql 5.5 (was installed using third party repositories) as my DBMS and then I decided to replace it with the latest version of MariaDB. I executed following commands to stop…
BlackBrain
  • 117
  • 4
0
votes
1 answer

phpMyAdmin on CentOS 7 with NGINX returns blank page

I have installed CentOS 7 in Virtual Machine with NGINX. PHP, MariaDB and everything else is installed and working fine. However, when I access the http://localhost/phpMyAdmin it shows blank page. Anyone knows why? My nginx.conf is as follows: user…
Ghazanfar Mir
  • 103
  • 1
  • 6
0
votes
1 answer

Restricting IP address not working in phpmyadmin

In the default configuration of phpmyadmin with ISPconfig-3 on Ubuntu. Strange thing happens, "Order Deny,Allow" & "Deny from All" works for sub-directories (blocks all requests) but not for the root of them. /usr/share/phpmyadmin (Not…
EmadFathy
  • 1
  • 3
0
votes
0 answers

Plesk + PhpMyAdmin: Allow a user to see all their databases

Initially each user on a domain could access all their databases on phpmyadmin, but now when you click on the "phpmyadmin" button, it only shows the database you opened instead of all the databases that the user has access to. For example, we have…
Marco Batista
  • 101
  • 2
0
votes
3 answers

phpmyadmin fail2ban failed login log

I have a Debian server with phpmyadmin. I want to use fail2ban to block brute force attack. I have questions: How can I log the failed login attempts to log? Where to set that? I can only find the log in /var/log/apache2/access.log even it is…
hatted
  • 180
  • 1
  • 2
  • 12
0
votes
0 answers

phpmyadmin can't login with non-root users

I just started learning to manage Linux web hosting. After installed webmin/virtualmin on Ubunto 14.04, I used the install script of virtualmin to install phpmyadmin. The problem is, I can only use root to login phpmyadmin, in the database, I can…
shenkwen
  • 199
  • 2
  • 14
0
votes
3 answers

phpMyAdmin - 403 permission denied - Centos7

I have installed phpMyAdmin on my server running apache 2.4.6 on Centos7, I am getting error as You don't have permission to access /phpmyadmin on this server. my server ip is 62.210.xx.xx I am browsing 62.210.xx.xx/phpmyadmin/ remotely from another…
Tall boY
  • 221
  • 1
  • 3
  • 13
0
votes
4 answers

#1932 table 'phpmyadmin.pma_tracking' doesn't exist in engine

My box is Scientific Linux 7.1 x64 and xampp 5.6.14-3 x64. After installing xampp, I opened phpmyadmin and created databases and users, then I got this error message everytime: #1932 table 'phpmyadmin.pma_tracking' doesn't exist in engine Any…
WindStory
  • 59
  • 3
  • 3
  • 7
0
votes
1 answer

Nginx & PhpMyAdmin standard practices

I'm currently migrating a small dev server from Apache to Nginx and I'm wondering about the "standard" way to manage PhpMyAdmin : I've simply symlinked the phpmyadmin folder to my nginx site root folder. I've also seen a lot of posts saying to…
Lery
  • 111
  • 5
1 2 3
…
14 15