phpmyadmin is a web-based mySQL administrator front end, written in php
0
votes
2answers
562 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
4answers
9k views
MySQL + phpMyAdmin: The server is not responding (or the local MySQL server's socket is not correctly configured)
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
747 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
1k 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
187 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
236 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
795 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
701 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
155 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
1k 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
112 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 ...
0
votes
2answers
570 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
637 views
Transfer database data from xampp on Windows to Ubuntu
Which is the fastest way to transfer mysql databases from xampp on Windows to a MySql server on Ubuntu?
0
votes
2answers
101 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
511 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
54 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 ...
0
votes
0answers
163 views
trying to update phpmyadmin
I've successfully got php 5.3 working on centos and now I need to update my phpmyadmin as its throwing errors. I first tried to remove the current one using yum:
yum remove phpmyadmin
which ...
1
vote
0answers
434 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 ...
2
votes
3answers
3k 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
252 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
465 views
How can I change a batch of fields in phpmyadmin in one go? [closed]
I want to change the value of a specific column within a search result in phpmyadmin. I could do it manually but the search results gives over 800 results. What solutions are there? Please appreciate ...
0
votes
1answer
468 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
1k 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 ...
10
votes
7answers
6k 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
69 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 ...
0
votes
1answer
3k views
PHPMyAdmin Import large (70 MB) file
I am trying to import a 70 MB .sql file in PHPMYADMIN but it give me the limit error:
You probably tried to upload too large file. Please refer to documentation for ways to workaround this limit.
...
2
votes
3answers
821 views
Managing Remote MySQL DB using local phpmyadmin
is there any way to manage a remote MySQL server using a local phpMyAdmin?
I don't think they will allow me to upload a copy of phpmyadmin through ftp. For the meantime, I've been managing the remote ...
0
votes
1answer
256 views
phpMyAdmin not allowing users to log on
When the auth_type is set to cookie phpMyAdmin will not allow anyone access.
Putting the same credentials we are trying on the form into the config file works.
Does anyone have any ideas what could ...
0
votes
1answer
462 views
Internal server error after import sql dump in phpmyadmin
I have a problem with import of 20mb sql dumo by using phpMyAdmin 3.4.1 . As you can see here there are big values for max scipt's execution time. In apache log I see the following:
[Thu Jul 14 ...
2
votes
1answer
244 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 ...
0
votes
3answers
603 views
Creating a Database in phpMyAdmin - not appearing in cPanel
When creating a database through an SQL statement in phpMyAdmin, it gets created alright, but it is not appearing in my list of Databases in my cPanel.
When I create the database through cPanel ...
1
vote
1answer
352 views
Preventing phpMyAdmin access from a limited set of IP's
How can I limit the access to phpMyAdmin from only specific IP addresses ? I want phpMyAdmin, which is hosted on a data center to be accessible only from the IP range in my office. LAMP and phpMyAdmin ...
4
votes
2answers
3k views
phpmyadmin connecting to a remote server
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 ...
0
votes
1answer
637 views
phpmyadmin login redirect fails with custom ssl port
The server is running Ubuntu 10.10, Apache 2.2.16, PHP 5.3.3-1ubuntu9.3, phpMyAdmin 3.3.7deb5build0.10.10.1. Since this same server is also running Zimbra on port 443, I've configured apache to serve ...
0
votes
2answers
786 views
Guide To Setting Accessing PhpMyAdmin On NGINX, Ubuntu 11.04, EC2 Remote MySQL Instance
I have setup a domain name to run on amazon ec2 running ubuntu 11.04, nginx and php5-fpm.
The domain name works great, I have setup it's own sites-available configuration file and sym-linked it to ...
1
vote
0answers
410 views
setting up phpmyadmin with nginx within ubuntu 11.04
I have nginx and php5-fpm running on ubuntu 11.04. I have installed phpmyadmin but im having trouble accessing it. I would like to access it via http://localhost/phpmyadmin
I've used all the default ...
2
votes
0answers
92 views
lost tables in drupal site database
i have drupal site on my local server build using pressflow
i had problems with the xammp 1.7.4 server so i delete it except the mysql and htdocs folders
i installed the server again but the drupal ...
0
votes
1answer
332 views
I cannot SSH to my VPS, Cannot Access PHPmyadmin
My VPS suddenly started behaving strangely.
I cannot SSH to my VPS.. I use Tunnelier and it says "Toterm Error: Connection Attempt Failed. Reason Windows Error 10061: No connection could be made ...
0
votes
1answer
432 views
WAMP Re-install causes error: Could not execute… The service has not been started
Full error reads:
Could not execute menu item (internal error)
[Exception] Could not perform service action:
The service has not been started
After doing a bit of googling, this problem should be ...
1
vote
1answer
558 views
phpmyadmin displays blank page after installing apc and memcached
ii am running a lamp stack on centos 5.6 with php 5.3. i had installed phpmyadmin and it work. i was able to log in and do anything. Then i installed memcached and its php extension as well as apc and ...
0
votes
3answers
1k views
phpMyAdmin File Could Not Be Read
Whenever I try to upload a file to import into phpMyAdmin I get the following error:
File could not be read
phpMyAdmin is the only php script I am running on my server, and as such my php ...
2
votes
1answer
147 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
59 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, ...
3
votes
2answers
464 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 ...
0
votes
1answer
668 views
phpMyAdmin - PHP Fatal error: Allowed memory size of 268435456 bytes exhausted
I have the memory limit set to 128M in php.ini and all I try to do is just upload a Excel 2007 sheet of size 130KB, which contains only 100 rows. The error message in apache log reads:
[Mon May 09 ...
2
votes
1answer
513 views
show table status not showing innodb tables
After a server reboot I noticed that phpMyAdmin was not showing my innodb tables, just the myisam.
I logged into mysql server directly and while show tables is showing the innodb tables, when I use ...
2
votes
1answer
943 views
Add htaccess for phpMyAdmin installed in /usr/share/?
Installed phpMyAdmin on Ubuntu 10.10, running apache2. phpMyAdmin resides in /usr/share/, and is accessible because there is alias in apache2.
I'd like to add an .htaccess file for it, but I am ...
0
votes
1answer
2k views
Cannot start session without errors in phpMyAdmin running Nginx with PHP-FPM
Whenever I open phpMyAdmin from my VPS I get the following error:
Cannot start session without errors, please check errors given in your PHP and/or webserver log file and configure your PHP ...
0
votes
1answer
116 views
Changing phpMyAdmin so that it does not use a password…Any suggestions?
I am having a problem accessing phpMyAdmin currently. This was the error that was posted in the error logs:
" PHP Warning: mysql_connect(): Access denied for user 'root'@'localhost' (using password: ...
