phpmyadmin is a web-based mySQL administrator front end, written in php

learn more… | top users | synonyms

26
votes
7answers
5k views

How can I block hacking attempts targeting phpMyAdmin?

My website gets thousands of hits daily from different IPs trying to access: /php-myadmin/ /myadmin/ /mysql/ ...and thousands of other variations. None of these directories exist, I don't even have ...
14
votes
8answers
15k views

MySQL cannot connect via “localhost”, only 127.0.0.1

this is somewhat of a mystery to me. The only way I can connect to MySQL is if I call it via "127.0.0.1" ... for example, my PHP connect script will NOT work with localhost I'm running Mac OS X Lion, ...
13
votes
9answers
40k views

phpMyAdmin: The additional features for working with linked tables have been deactivated

I'm getting this error in the main page of phpMyAdmin verson: 3.2.1deb1 The additional features for working with linked tables have been deactivated. To find out why click here. When I click the link ...
9
votes
8answers
9k views

How to secure phpmyadmin?

I checked out my apache logs, and, whooooaaa, there are a lot of bots trying to exploit phpmyadmin. The first thing i did was to change the directory name to something more obscure. But, are there ...
6
votes
4answers
30k views

PhpMyAdmin (on ubuntu lamp): Login without a password is forbidden by configuration (see AllowNoPassword)

My mysql password = '' i try to login to PhpMyAdmin (on Ubuntu 10.04 lamp) and get error: Login without a password is forbidden by configuration (see AllowNoPassword) What should i do for enter to ...
6
votes
3answers
13k views

How Export Result of MySQL Query on PHPMyAdmin 3.4.3?

1) I've got a 30K row table. 2) When I run a long, 50-line query on that table, a GROUP function reduces the number of rows to 7K. 3) I want to export the grouped 7K rows as a new table, or save them ...
6
votes
2answers
15k views

Can't create/write to file '/tmp/#sql_xxxx.MYI' (Errcode: 13)

I have installed Debian Lenny, PHPmyadmin and postfix. When using PHPmyadmin GUI and access any table with data i get: Can't create/write to file '/tmp/#sql_xxxx.MYI' (Errcode: 13) doing perror ...
6
votes
2answers
4k views

Running phpmyadmin and suphp

I have a Debian Lenny web server. It is running apache2 with libapache2-mod-suphp. Unfortunately, suphp makes impossible to use phpmyadmin, as phpmyadmin is installed in /usr/share/phpmyadmin and ...
5
votes
2answers
4k views

What is the difference between Replication and Synchronization?

In phpMyAdmin there is a tab for configuring Replication and one for Synchronization. What is the difference between Replication and Synchronization? When do you should use the one or the other? ...
5
votes
2answers
4k views

Which MySQL users have access to a database?

How can I tell which MySQL users have access to a database and what privileges they have? I seem to be able to get this information from phpMyAdmin when I click "Privileges". . . ...
4
votes
2answers
12k views

How to upgrade to latest PHP, MySQL, and phpmyadmin on CentOS 5.8 (32bit)?

I have searched around on the internet and cannot find a reliable source for installing the latest versions of PHP, MySQL, and phpmyadmin on CentOS 5.8 32bit with apache. I have tried a couple times, ...
4
votes
1answer
557 views

Where do I set administrator password for phpmyadmin?

I'm trying to install phpMyAdmin on my Ubuntu 10.04 server, by doing 'apt-get install phpmyadmin'. Installer asks me for MySQL administrator password and for phpMyAdmin database user password, but not ...
4
votes
4answers
8k views

How to thwart PHPMyAdmin attacks?

We see a lot of requests for non-existent setup.php files in our access logs (see below). For some of our clients that use rewrite rules each of these requests will cause a PHP script to be executed, ...
3
votes
2answers
561 views

How to open port 555 on Linux / Debian

I want that phpmyadmin to work at mysite.com:555 (555 port) # phpMyAdmin default Apache configuration <VirtualHost *:555> Alias /phpmyadmin /usr/share/phpmyadmin <Directory ...
3
votes
2answers
5k views

Setting up phpmyadmin, got a MySQL syntax error

I tried installing phpmyadmin on Debian Squeeze with a nginx and mysql-server installed. I ran sudo apt-get install phpmyadmin, and all appeared to be going well until setup threw me this: An error ...
3
votes
2answers
1k views

Transfer database data from xampp on Windows to Ubuntu [closed]

Which is the fastest way to transfer mysql databases from xampp on Windows to a MySql server on Ubuntu?
3
votes
2answers
2k 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?
3
votes
3answers
5k views

phpmyadmin connecting to a remote server [closed]

I have two servers (ubuntu 10.04 amd 64). one i plan on the webserver, the other i plan on being the database server. The webserver is the only server with access to the outside world. I installed a ...
3
votes
4answers
4k views

Running PHPmyAdmin on Nginx, port 8080 passed to varnish not working well!

I installed Nginx, Varnish and PHP-fpm. Then I installed PHPmyAdmin and made a virtual host for it: server{ listen 8080; server_name phpmyadmin.Domain.com; access_log ...
3
votes
1answer
434 views

Suspicious activity in access logs - someone trying to find phpmyadmin dir - should I worry?

I was looking over the access logs for a server that we are running on Amazon Web Services. I noticed that someone was obviously trying to find the phpmyadmin directory - they (or a bot) were trying ...
3
votes
2answers
3k views

(Ubuntu - Lamp) phpmyadmin install error 404 not found

I install apache, mysql, php and then phpmyadmin on ubuntu desktop 10.04 version I test apache: localhost with browser and its works. I test mysql with console and its works. I test phpmyadmin ...
3
votes
2answers
2k views

How to setup phpmyadmin with nginx and access it from http://vps-ip/phpmyadmin

The phpmyadmin files are located here /usr/share/phpmyadmin/ And I have this server block code that allows me to access phpmyadmin only from http://vps-ip/: server { listen 80; ## listen for ...
3
votes
1answer
208 views

Cannot login to phpMyAdmin

phpMyAdmin always annoyingly makes me login every 4000 seconds so I went to the "Users" part and removed the password for the "root" account which is what I was logged into (I changed it to "No ...
3
votes
2answers
404 views

Changing phpmyadmin root password

I'm trying to figure out how to change the root password for phpmyadmin. I've tried doing this a few times using this: $ mysql -u root -p use mysql; update user set password=PASSWORD("NEWPASSWORD") ...
2
votes
5answers
16k views

I accidentally dropped my MySQL database in PhpMyAdmin, is there a possibility to recover my database?

I accidentally dropped my MySQL database in PhpMyAdmin, is there a possibility to recover my database?
2
votes
6answers
1k views

Would you install phpmyadmin on a production web server?

I have been playing around with phpMyAdmin and I do think that it is a good tool, but I have read a lot on the internet about security holes. Would you recomend installing/using phpMyAdmin on a ...
2
votes
2answers
3k views

Allow access to PhpMyadmin only on a specified virtualhost

I'm working on a multiple virtualhost Environment. I've installed PhpMyadmin for Mysql Remote Control. Environment is configurate as below: one.domain.com two.domain.com onlyphpmyadmin.domain.com ...
2
votes
1answer
1k views

Firefox can't find the file at http://localhost/phpmyadmin/export.php

I have a huge 1.6 GB MYSQL database on my wamp local server. I want to shift this database to another computer, so in phpmyadmin, when I export the database and click GO for download the sql file, ...
2
votes
4answers
19k views

#1130 - Host 'localhost' is not allowed to connect to this MySQL server

I issued a command of DROP USER 'root'@'localhost'; GRANT ALL PRIVILEGES ON . TO 'root'@'%';in PhpMyAdmin, immediately after the execution, I was forced out PhpMyAdmin,I got an error #1130 - Host ...
2
votes
1answer
3k views

Nginx appends the path given in the URI

I'm trying to configure phpMyAdmin so I've set the flowing location in Nginx however it apends the "pma" to the root directory: 2012/08/14 13:59:49 [error] 10151#0: *2 ...
2
votes
1answer
7k views

Trying to install phpmyadmin on centos - mysqli missing

Here is the error I get when trying to open my phpmyadmin directory: phpMyAdmin - Error The mysqli extension is missing. Please check your PHP configuration. I have done the steps in the following ...
2
votes
1answer
179 views

How rare is a man in the middle attack?

I was wondering if I should set up a secure connection for the db administration application (phpmyadmin) for my sites. They don't store credit cards nor anything that could be valuable for a hacker. ...
2
votes
1answer
834 views

how to disable phpmyadmin on a centos server?

is there a way to disable phpMyAdmin from being accessed on my server while still keeping the install in case it is needed later?
2
votes
1answer
332 views

phpmyadmin forbidden through ssh tunnel

I have configured PHPMyAdmin on an Ubuntu Server to be accessible only from 127.0.0.1. I am then trying to access it through an SSH tunnel, but I still obtain the Forbidden error. When using SSH on ...
2
votes
3answers
62 views

Accessing mysql DB remotely

I became in charge of a legacy website, which was written by someone else that is now not available, and has no CMS - just pure php and html. It's not written very well, but that's my problem... Some ...
2
votes
3answers
90 views

Innodb statistics

We're running InnoDB as a MySQL engine and using phpMyadmin to administer our database. Under Status -> Query statistics, phpMyadmin gives us the following: We would like to know where these ...
2
votes
1answer
1k views

disable/delete phpmyadmin aws ec2 lamp

i am pretty new to dedicated hosting and aws cloud. i was able to setup my instance with a lamp stack and installed phpmyadmin, moved it away from the 'www' directory and gave it an alias in my ...
2
votes
1answer
66 views

How to Properly Migrate SQL

If I am changing servers, I usually migrate my wordpress database by going to phpmyadmin and doing an SQL Export on one server and doing an Import on the other server. I notice that in this process, ...
2
votes
2answers
210 views

phpmyadmin not opening

I have a Centos VPS 512 MB RAM 30 GB hard disk, When I goto to my phpmyadmin, the login page comes, when I enter my username and password, and hit enter, the same page comes, again the same login ...
2
votes
2answers
4k views

How to make phpMyAdmin ask for my username and password

I am using rhel 5 and php 5 with mysql 5. My server is already configured and running all applications smoothly. I am accessing mysql as root and supplying my password. However, when I access ...
2
votes
1answer
1k views

InnoDb Overhead?

I just converted several large tables from MyISAM to InnoDB. When I view the tables in phpMyAdmin, they are showing a significant amount of overhead (One table has 6.8GB). Optimizing the tables ...
2
votes
1answer
2k views

Can't login to remote MariaDB server with phpMyAdmin, but works in shell

I recently configured two servers. The first to use Apache and phpMyAdmin. On the other server I have a maria-DB server correctly configured. phpMyAdmin it's reading the config file, but I can't ...
2
votes
1answer
1k views

localhost/phpmyadmin pulls blank page

When I tried configuring local machine as a Internet Gateway with website development capabilities over it and I installed all required software into it. I also had disable the selinux into it. But ...
2
votes
1answer
60 views

Running phpmyadmin on one cloud server and trying to access mysql on another cloud server

Just curious, if you have mysql on one server, and phpmyadmin on another server, mysql doesn't have to be running for PMA to get data from the remote mysql database right? (don't hate me if this is a ...
2
votes
2answers
2k views

Trying to connect phpMyAdmin to remote mySQL server ( 2002: can't connect )

Trying to get phpMyAdmin to talk to a remote mySQL server. The config is below and there is already a user set up in mySQL DB to be able to log in from the specified host that PMA sits on. Hosting is ...
2
votes
1answer
312 views

phpmyadmin and import of an existing database

I have just installed phpmyadmin on a Windows 2008 Sever with IIS installed and I want to important a database which I have created on my own machine onto this server within phpmyadmin. When I try do ...
2
votes
3answers
15k views

MySQL + phpMyAdmin: The server is not responding (or the local MySQL server's socket is not correctly configured) [closed]

My phpmyadmin works only when I'm connected to the internet.(it even works if i'm just connected to Lan) otherwise, it gives below error: Error MySQL said: #2002 - The server is not responding ...
2
votes
2answers
8k views

Alias using Nginx causing phpMyAdmin login endless loop

Recently I've been trying to set up a web server using Nginx (I normally use Apache). However I've ran into a problem trying to set phpMyAdmin up on an alias. The alias correctly takes you too the ...
2
votes
5answers
405 views

How to install wordpress without a web browser

What I am trying to do is to automate wordpress website creation for the company I am working on. We have lots of information in our database for our customers and we want to create a wordpress ...
2
votes
2answers
2k views

myPHPAdmin standalone to access seperate database?

First time here on SF, (love SO), so hope I can get the terms right, not really a server person but here goes... Trying to set up access to a mysql database for a separate user. Of course that's not ...