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

learn more… | top users | synonyms

1
vote
0answers
897 views

Log in successful in MySQL but fail in phpMyAdmin

I'm having a problem with my MySQL / phpMyAdmin couple. I can log in MySQL but when I try to log in phpMyAdmin the error returned is "#2000 Cannot log in to the MySQL Server" . I'm running Windows ...
1
vote
1answer
1k views

PHPMyAdmin is being attacked

I am running a Debian server with PHP5, Apache 2.2.16 and PHPMyAdmin (I don't know how to check the version number), Logcheck and some other programs. Today Logcheck begin to attach multiple lines ...
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 ...
0
votes
1answer
855 views

Apache config, why it's always says The Requested operation has failed, I can not run apache?

I'm already tired, I can not start apache, I'm reinstalled it a few times, but it doesn't work, was a different situations, such as firewall or whatever, but now I can not run apache ordinary cause it ...
1
vote
1answer
343 views

phpMyAdmin sends me to login page when clicking on Privileges tab

I had wanted to change the root mysql passwords so I went into the privileges tab and changed all of the passwords with the user name root (not smart with not knowing what I was doing I know). I went ...
0
votes
1answer
364 views

Receiving an error when moving table from one server to the other

I am trying to move a Wordpress table from my old server to my new one and I am receiving this error: SQL query: -- -- Database: `username_film` -- -- ...
1
vote
2answers
103 views

New users with only SELECT privileges can DROP tables

I created a new user in mysql using phpmyadmin that only has the SELECT privilege. However, this user can DROP tables, delete records, change data (INSERT, UPDATE). I have flushed the privileges, ...
2
votes
2answers
495 views

Centos Suphp , How do I get Alias with Phpmyadmin working

I have configured my CentOS installation with Apache with suPHP. It works very well. But when I install PHPMyAdmin I get a permissions problem. Because PHPMyAdmin is located under ...
0
votes
1answer
1k views

CentOS can not enter phpmyadmin

I am useing CentOS 5.5, mysql 5.1, php 5.3, phpmyadmin 3.4.5, I have set my mysql password with >mysql update mysql.user Password="mypassword" where User="root" And in ...
1
vote
1answer
874 views

Fail to dump large size sql in phpmyadmin. Where to set PHP Timeout Limit? (CentOS with cPanel)

My server: CentOS 5.x, cPanel/WHM, PHP 5.3.6. I am trying to import a large size of mysql data into a db with phpMyAdmin, the progress is terminated. It says: Below, it also mentions that: So ...
0
votes
1answer
262 views

SUSE linux nginx and phpmyadmin 404 errors

I've installed nginx and phpmyadmin etc and most things work fine. I'm getting random problems though... e.g. when I click drop I get a message on the screen to say its updating and then the page ...
0
votes
2answers
172 views

Installing phpMyAdmin installs Apache

When I install phpMyAdmin it automatically installs Apache. That happens even though I do not select Apache in the installation process of phpMyAdmin and choose not to install via db-config. How do I ...
0
votes
1answer
533 views

Install phpmyadmin on centos vps hosting

I'm trying to install phpmyadmin on centos vps hosting. I have uploaded all the phpmyadmin files in /usr/share/phpmyadmin as it was said in a tutorial but now when I enter http://mysite.com/phpmyadmin ...
0
votes
1answer
3k views

PHPMyAdmin - Error 500

Have scoured the board but can't seem to find anything that's helped yet. If I go to http://localhost/ it's fine, if I go to http://localhost/phpmyadmin I get an 'Error 500: Internal Server Error' ...
0
votes
1answer
297 views

tbl_replace forbidden in phpmyadmin

On CentOS 5 I updated phpMyAdmin to the latest release. I can access and browse tables and records but when I try to insert a new record I receive the following error: Forbidden You don't have ...
0
votes
2answers
63 views

How would I set up mysql db hosting

I have a VPS and have set up vhosts so I cant host websites, im wanting to give each user the ability to create there own db within mysql, I have phpmyadmin installed so can login to that to view the ...
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 ...
1
vote
3answers
9k views

How to upgrade phpMyAdmin?

We have a server (apparently Apache/2.2.3 Red Hat) that has an old version of phpMyAdmin (2.x) and needs upgrading to the latest version but I have no idea how to go about doing that. I don't really ...
0
votes
1answer
135 views

How to upgrade phpMyAdmin on Linux server

We have a server that has an old version of phpMyAdmin (2.x) and needs upgrading to the latest version but I have no idea how to go about doing that. I don't really know much command line stuff. I ...
0
votes
1answer
340 views

PHPMyAdmin Setup Prompts for PHP 5.2+ after Install of PHP 5.3.8 on RHEL 5

I have a fresh RHEL 5 dedicated server that has just been updated with PHP 5.3.8. When I browse http://my.ip.addy/setup to start the PHPMyAdmin setup, I receive a message stating PHP 5.2+ is ...
2
votes
1answer
2k views

MySQLi Extension with phpMyAdmin

I just unpacked the latest phpMyAdmin into /var/www/html/phpMyAdmin and it is giving me "The mysqli extension is missing." - how do I install this? I'm on Centos. I checked php.ini and it seems to be ...
0
votes
2answers
2k views

Installing phpMyAdmin error

su - yum install phpMyadmin gets me: Error: php53-common conflicts with php-common You could try using --skip broken to work around the problem You could try running: package-cleanup --problems ...
1
vote
3answers
541 views

Login with phpmyadmin only works under Firefox, no error messages generated

I've setup a phpmyadmin site protected by an htaccess file. The site is also set up to force an SSL connection. The problem is that everything works fine under Firefox but not other browsers (Opera, ...
0
votes
2answers
6k views

How to connect MySQL database of local server in NetBeans 7.0.1 ( windows)? [closed]

I am using NetBeans IDE 7.0.1 on Windows 7 very first time for my php. Actually in my company there is a local server ( 192.168.1.99) where all projects resides and we access phpmyadmin of ...
0
votes
2answers
1k views

nginx phpmyadmin 404

I am trying to install phpmyadmin on my nginx web server. I installed phpmyadmin without a problem. I created subdomain for it. For security reasons I didnt call my subdomain "phpmyadmin" i used a ...
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
4answers
1k views

Should I install PhpMyAdmin on a production server, or on a different server, accessing the production DB over the wire?

(This question is related to but different from Would you install phpmyadmin on a production web server?) I want to use PhpMyAdmin to access my production database. I'd rather not have it installed ...
0
votes
1answer
2k views

Auto backup mysql database in phpmyadmin

Can i backup the mysql database automatically every week like scheduled job in local Phpmyadmin. if possible i would like to take the each database separate file.Is this possible ! Thanks
0
votes
2answers
285 views

EC2 phpMyAdmin User Security

I just set up the Ubuntu EC2 instance, ami-028f7b6b. Everything is working great but I am having trouble figuring out how to secure phpMyAdmin. I have phpMyAdmin public and, as the instructions for ...
1
vote
3answers
302 views

Reset MySQL Password [duplicate]

Ok, so I changed my password through phpMyAdmin and it's completely locked out my access to the root mysql user. There are various articles about this online, but none of them seem to work. Here's ...
0
votes
3answers
2k views

5GB DB backup too large for phpmyadmin any solutions?

I have a Virtual Private Server with a Plesk control panel and Ubuntu installed in the back end. Over the last year it grew very large beyond my expectations and I do not have any backups. I am quite ...
-3
votes
2answers
921 views

phpmyadmin on ubuntu 11.10

Building dependency tree Reading state information... Done E: Unable to locate package phpmyadmin In ubuntu 11.04 it installed easily. I formatted my computer and installed ubuntu 11.10 after ...
0
votes
1answer
237 views

phpMyAdmin Setup GUI

i have just installed apache,php5,mysql and phpmyadmin in order, on a box with Freebsd-8.2. If I'm right, if i access the phpmyadmin on http://domain.com/phpmyadmin, it should show the phpMyAdmin ...
0
votes
1answer
2k views

How to setup phpMyAdmin with Nginx?

I created an entry in virtuals.conf for phpMyAdmin and restarted Nginx, but I can not get it to actually server phpMyAdmin. PHP is installed and configured with Nginx for fast-cgi, the virtuals.conf ...
1
vote
2answers
129 views

for security is it best to have phpmyadmin locally or in cloud

Our site is going live soon and I am thinking about security. We have a typical layout of nginx, apache and mysql at back. Ideally the only machines exposed to the net would be the nginx servers but ...
-1
votes
2answers
788 views

PHPMyAdmin throws an open_basedir error when using eaccelerator

I guess the PHPMyAdmin code is getting confused by eaccelerator. This is the error I get: Warning: Unknown: open_basedir restriction in effect. File() is not within the allowed path(s): ...
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?
0
votes
2answers
111 views

Don't list the databases which don't belong to the user

Using MySQL and PHPMyAdmin I want to give some users all the permissions to create databases and delete their own. Basically a user should only see his created databases and could do everything he ...
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 ...
1
vote
1answer
65 views

phpmyadmin - login issues

I have recently set up an installation of phpmyadmin, using the root username /password. I have created a new user with the following: User Host Password Global privileges Grant Action ...
1
vote
1answer
2k views

Install phpmyadmin on nginx

I try to install phpmyadmin to work with nginx in my archilnux box but I seem have some problem. The steps below is exactly what I've done : sudo pacman -S phpmyadmin Then I create a symbolic link ...
1
vote
0answers
789 views

Cannot load mcrypt extension in Debian

I used the following command to install phpmyadmin in Debian 6 32bit, apt-get install phpmyadmin After doing some settings, phpmyadmin page is up, but there is an error says "Cannot load mcrypt ...
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 ...
1
vote
2answers
339 views

Can't login to phpMyAdmin

I am unable to log into phpMyAdmin after installation. Here is my config.inc.php file. Am I doing something obviously wrong? I'm sorry, this is the first time I'm dealing with PHP, MySQL, etc. Thanks ...
0
votes
1answer
666 views

Upgrading phpmyadmin 2.11.11.3 to 3.x on CentOS 5.6

With php 5.4 coming out, and the mysql extension being depreciated (and possibly becoming obsolete in php 6) I want to make sure I upgrade phpmyadmin, so my error logs aren't filled with depreciation ...
0
votes
2answers
2k views

Enabling phpMyAdmin Designer Mode

I've been trying for hours to enable phpMyAdmin Designer Mode on a CentOS cPanel dedicated server with no luck... here's the steps I followed, perhaps I'm missing something? I created the pma user ...
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, ...
0
votes
1answer
77 views

Ubuntu 10.10 Server phpMyAdmin install via apt disallows correct username and password

I'm running a ubuntu 10.10 server, and have installed phpmyadmin via apt so that I can easily keep it up to date. The install went well, and I can access the site, however when I try to log in I get ...