A web-based PHP utility used to manage MySQL databases on a server.

learn more… | top users | synonyms

-1
votes
1answer
9 views

Owncloud - where in the SQL database is the email stored?

I am searching and searching but still cannot find it. In what table does owncloud store the email addresses?
3
votes
3answers
4k views

How can I install PHPmyadmin on Mac Lion using Homebrew

How can I install PHPmyadmin using homebrew, if that possible. I'm using Mac 10.7. I installed Homebrew, and it's working perfectly. I use it to download php 5.4 and mysql. Both are working ...
1
vote
3answers
40k views

How to set login to phpmyadmin for default user/password in wamp server?

I understand that I need to log in to wamp server in order to create a database. My problem is that the phpmyadmin page opens without asking me to log in. So, I presume that I am not logged in. If ...
0
votes
1answer
13 views

phpMyAdmin used by java application

I have a MySQL database running at a site using phpMyAdmin. My problem is that I want to use this database inside a Java application which runs as a regular, non browser, application. The problem is ...
1
vote
1answer
53 views

Unable to modify variables phpmyadmin via variables tab (Xampp)

I am quite new to phpmyadmin configuration. I had project where utf8 encoding is needed. What i'm trying to do is to change the variables text/char all into utf8. I changed, yes at that moment the ...
2
votes
1answer
7k views

WAMP - phpMyAdmin trouble with password, #1045 - Access denied for user 'root'@'localhost'

I've been playing around with WAMP so far I have succeeded in making a password through cmd.exe for mysql: mysqladmin -u root -p password "newpassword" <-- I used this command on Windows 7. ...
0
votes
1answer
3k views

phpMyAdmin removes the primary key for MySQL table

My problem is this: I create a table in WAMP Server's phpMyAdmin, I always make the first column as name: id type: int index: primary auto_increment: true then I add other columns , mostly harmless ...
0
votes
0answers
30 views

phpMyAdmin + TYPO3 = Error code 200, how to solve?

I'm running a TYPO3 4.5.37 with the phpMyAdmin 4.18.4 plugin installed (both latest versions). TYPO3 itself works perfectly fine and the website, too. But if I click on the phpMyAdmin extension in the ...
0
votes
0answers
31 views

What are spiders trying to achieve on my site? [migrated]

I've recently set up a build server that compiles Java source on Github webhooks. I created a public page for downloading latest .jars with a top level domain and I'm logging requests to it. What are ...
0
votes
1answer
29 views

how to delete taggregate_temp_ tables at once?

In MySQL, I have multiple tables named like this: taggregate_temp_1364792160 taggregate_temp_1364795760 taggregate_temp_1364799360 taggregate_temp_1364802960 taggregate_temp_1364806560 ...
0
votes
0answers
13 views

How can I change initial login page for phpMyAdmin4?

How can I change initial login page for phpMyAdmin4? I want to add some text to 'Welcome to phpMyAdmin'. Have been looking for file to change but can't find it. Thanks.
16
votes
7answers
54k views

How to install PHPMyAdmin on Linux EC2 instance?

I just finished setting up a default Linux EC2 instance and would like to install PHPMyAdmin. I already have Apache and MySQL installed but cannot seem to install PHPMyAdmin. I tried using sudo ...
0
votes
1answer
204 views

#1045 - Access denied for user 'root'@'localhost' (using password: YES)

I have this error when trying to connect to my phpmyadmin. I tried all the solutions but nothing works. I changed password in config.inc and cleared cookies, restarted services of wamp but nothing. ...
0
votes
0answers
68 views

borked XAMPP upgrade — any way to rebuild my database if i saved var/mysql folder?

After I upgraded to Mac OS X Yosemite, the mySQL server on my XAMPP install stopped turning on. XAMPP released an upgrade that fixed this. So, I copied and pasted my "htdocs" and "var/mysql" folders ...
0
votes
0answers
25 views

How can I start Xampp Control Mysql Service automatically with Program?

I am working on C# using mysql phpmyadmin server and I am creating application for windows forms. I want this application to start xampp controller itself in background so I don't have to start it ...
0
votes
0answers
22 views

ISPConfig - two phpmyadmin versions

I've installed phpmyadmin first and then I configured ISPConfig, which appears to come with a different phpmyadmin version (an older one). How do I run only one of them? EDIT: whenever I go to my ...
1
vote
1answer
24 views

Is it possible to access any databases other than MySQL using phpmyadmin?

I heard that phpmyadmin is a GUI used to access MySQL DB. I wish to know whether any other databases are compatible to work with phpmyadmin.
0
votes
0answers
28 views

importing issue with mysql version to another

I have got an issue with mysql import, I have taken a backup of the mysql version 5.1.32 with the help of command mysqldump -u root -p --routines oneclicksite > oneclick.sql and importing it with ...
1
vote
2answers
1k views

Wamp's localhost taking so much time on opening

I have following configuration for WAMP on local machine Windows 7. When I try to open localhost from WAMP Notification icon, it's taking so much time (around in minutes). Even phpmyadmin is taking ...
0
votes
1answer
31 views

How to open phpmyadmin on Mac OSX Mountain Lion with XAMPP

How do i access phpmyadmin on my Mac? I heard that use can use localhost/phpmyadmin but it returns server not found. I installed PHP, MySQL and Apache with XAMPP.
0
votes
1answer
68 views

Forcing SSL on phpmyadmin

I couldn't decide which website this question we be on (since I see it almost everywhere) so feel free to migrate. I've set up a self-signed SSL cert on my server to secure my installation of ...
0
votes
0answers
34 views

PhpMyAdmin and cake on AWS Ec2

Question - I have Cake PHP installed and phpmyadmin in the same root directory (/var/www/html). Now when I try to navigate to my elastic ip/phpmyadmin I get Cake PHP telling me : Error: ...
0
votes
1answer
15 views

Adding a column to an imported spreadsheet - PHPmyadmin

I've imported data to phpmyadmin and I need to add a column to create a primary key (called companyID) How do I go about doing this?
0
votes
1answer
33 views

How to remove few tables from a large SQL file?

I have a SQL file with size around 3 GB. So this takes some long time to restore every time when i took recent dump from production. In this one table 'access_log' itself took 2.2 GB which is just a ...
0
votes
0answers
24 views

How to open PHP myadmin in XAMPP for linux?

I am running Linux Mint 17 (based on Ubuntu), and i have successfully installed Xampp. I would like to now work with MYSQL, so i was wondering how to open the PHP myadmin page in my browser. ...
0
votes
0answers
316 views

Installing PHPMyAdmin on AWS EC2

I followed Amazon's instructions http://docs.aws.amazon.com/AWSEC2/latest/UserGuide/install-LAMP.html to install a LAMP stack on a Micro EC2 instance running Linux. Installation was successful. I am ...
0
votes
1answer
81 views

How to update PHP and MySQL in SUSE LINUX Release 11.2

I have in a server SUSE LINUX Release 11.2, with PHP Version 5.2.17 and phpMyAdmin 3.3.9, How can I do for update the two elements, I tried with: sudo apt-get update php5 but dont works, says: ...
0
votes
2answers
197 views

Ubuntu - Secure PHPMyAdmin in Nginx

I followed the instruction on this site for installing PHPMyAdmin. However, this configuration is for an Apache, and I am using Nginx. I can't find any tutorial online on how to restrict the allowed ...
0
votes
0answers
76 views

Cannot open http://<myipaddress>/phpadmin

I am able to access localhost or localhost/phpmyadmin using http but not when I replace localhost with my own ip address. What mistake I might be doing? Steps already taken: 1) Changed "Require ...
0
votes
2answers
230 views

phpMyAdmin cannot login - keeps asking for credentials

I have phpmyadmin on my Arch linux box, it is running, so is apache with php and mysql. When I go to http://localhost/phpmyadmin/, it shows the usual login prompt. However, no matter what I enter, ...
0
votes
1answer
77 views

Can't login to local phpmyadmin

Hy, I've just installed MySQL and PHPMyadmin on my OS X Maverics, following this link: http://www.coolestguidesontheplanet.com/downtown/get-apache-mysql-php-and-phpmyadmin-working-osx-109-mavericks ...
0
votes
1answer
732 views

Unknown SQL server host error in phpMyAdmin after switching php versions in WAMP

I've installed Wamp Server 2.2, which includes php 5.3.13, Apache 2.2.22 and MySQL 5.5.24. Then I installed php 5.2.4 using the WampServer2-PHP524.exe extension found here on SourceForge. When I ...
14
votes
3answers
18k views

How to export mysql schema from phpmyadmin?

I have a huge db that hangs the server if I try to export it, is there a way I can export it without all the data? Only the tables structure.
0
votes
1answer
220 views

mysqli extension is missing in phpMyAdmin on RedHat 5.9 Server

We have installed Apache, PHP, MySQL, and attempted to install phpMyAdmin. When going to phpMyAdmin in the browser, we are presented with "The mbstring extension is missing." We are unable to get ...
-2
votes
1answer
56 views

Secure way to manage mysql through web browser

I would like to offer clients access to their own mySQL database. Is there a secure way of doing this? Is there any way to secure phpmyadmin without using a htaccess password or restricting it to ...
0
votes
0answers
129 views

Phpmyadmin hide_db hides all databases

I want to hide the information_schema database from users as it has caused confusion. I have the following in config.inc.php: $cfg['Servers'][$i]['extension'] = 'mysqli'; /* Optional: User for ...
1
vote
1answer
495 views

View existing indexes using phpMyAdmin

Using phpMyAdmin, is it possible to view existing indexes on a table? If so,how? One of my tables should have an unique index with two keys, and I want to confirm it exists.
0
votes
1answer
143 views

how to insert many similar records in mysql at a time using phpmyadmin?

we know that we can insert multiple records at a time using this query: INSERT INTO `TABLE1` (`First`,`Last`) VALUES ('name1','surname1'), ('name2','surname2'), ('name3','surname3'), ...
0
votes
2answers
202 views

phpMyAdmin wrong configuration on Debian

I'm running Debian Sid (headless) with phpMyAdmin 4.2.2deb1. When I log in on phpMyAdmin I see the following message: The phpMyAdmin configuration storage is not completely configured, some extended ...
1
vote
1answer
193 views

Making phpmyadmin accessible over internet

I have XAMPP installed on my Windows XP server. I have port 3306 (mysql) and 80 (apache) on the machine forwarded to 5016 and 5011 on the router respectively. I am able to access the phpmyadmin ...
1
vote
0answers
345 views

Mysql socket error 2002 on Linux Mint - Access denied

My apache and xampp servers are running on port 2145 and 16443 respectively. sudo /opt/lampp/lampp restart Restarting XAMPP for Linux 1.8.2-5... XAMPP: Stopping Apache...ok. XAMPP: Stopping ...
0
votes
1answer
56 views

Setup page for phpMyAdmin not appearing but the domain is

Relative newbie here... EC2 instance installed, apache is running and can see the Test Page for the Apache server I am following the instructions found on ...
1
vote
1answer
31 views

Why would phpMyAdmin be working with 127.0.0.1 blocked?

Newbie with all this. My background provides familiarity with PHP as well as databases... Setting up EC2 and have gotten as far as installing phpMyAdmin with lots of bumps and restarts (and denting ...
0
votes
1answer
354 views

phpMyAdmin No activity within 1440 seconds; please log in again. Issue

I have installed latest phpMyAdmin on Apache+php+mysql on CentOs. But after sometime of inactivity i am getting No activity within 1440 seconds; please log in again. And redirected to the ...
0
votes
0answers
86 views

invalid default value in SQL export

I exported a database with phpmyadmin, and am now attempting to import the database with PMA on a different machine, but I'm getting this weird error. What can I try as a solution? Error SQL query: ...
1
vote
1answer
2k views

Can phpMyAdmin be used to connect to a remote database?

I recently read this tutorial, which explains how one can easily reconfigure a local installation of phpMyAdmin to connect to a remote database. The functionality seems to be supported, but not ...
0
votes
0answers
60 views

Connecting to remote database via phpMyAdmin - Validation error

I've been trying to connect to a remote MySQL database via local phpMyAdmin, as per explanation by this tutorial. However, I'm not authenticating properly with the database due to the IP address ...
0
votes
2answers
1k views

Configuring PHPMyAdmin to connect to remote database

After Googling the possibility of using PHPMyAdmin to connect to remote databases, I found this article, which confirms that this is supported after a simple config edit. In the article, the author ...
1
vote
0answers
551 views

Cannot create database as root in phpMyAdmin

I just got my VPS. I log in to phpMyAdmin as the root but I cannot create a database. I can't even see a link for this. I also want to change other user's permissions, but I cannot find out how to do ...
1
vote
1answer
90 views

phpmyadmin CSV files import and export

When I try to import CSV files in phpmyadmin, I get message in green that says "0 rows" but it is nevertheless a success message. I know my data is correct, as it importing fine on another computer. ...