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

learn more… | top users | synonyms

1
vote
1answer
3k 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
2answers
4k 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 ...
0
votes
1answer
876 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 ...
1
vote
1answer
178 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. ...
0
votes
1answer
37 views

Problems with MySQL [Minecraft]

I get an error with MySQL. My servers crash every day having something to do about Java. But this one was different. Error: http://pastebin.com/n2xLY50L Edit: I also have two values put in my ...
0
votes
1answer
36 views

phpMyAdmin causes computer to restart?

This might sounds crazy, but on windows 8 I tried 3 browsers (Firefox, Chrome, And IE) and each time I went to: http://127.0.0.1/phpmyadmin a message would show up: "your pc ran into a problem and ...
0
votes
2answers
2k views

csv file to phpmyadmin import error

here is the pattern of my csv file -------------------------------------------------------------- | col1 | col2 | | col4 | | ...
0
votes
1answer
110 views

Can I remove the “New table” button from the Navigation Tree in PHPMyAdmin (4.0.9)?

Every database listed in the left-hand pane has a "New" button for creating a new table, i.e. the first item in this tree. It takes up room and I don't need it. There doesn't seem to be a config ...
3
votes
2answers
4k views

Installing phpmyadmin package ERROR 1045 (28000)

I need to create a new mySQL db for a local site, I thought I'd do that with phpMyAdmin so I installed that package like so: sudo apt-get install phpmyadmin During this process I get a couple of ...
0
votes
1answer
704 views

Using PHPMyAdmin or MySQL Workbench, how to search across 10 tables and return all records matching a specific criteria?

This seems like it should be so simple but I'm having a hell of a time solving it. I have 10 tables named in the following way: b1_settings b2_settings ... b10_settings I need to search across all ...
0
votes
1answer
96 views

Debian: Login to mysql doesn't work

So I rented this server with Debian 7, and wanted to install a webserver, and followed the following tutorial: http://www.howtoforge.com/ubuntu_debian_lamp_server And I'm now stuck at the PHPMyAdmin ...
1
vote
3answers
62k 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 ...
1
vote
2answers
322 views

How do I access phpmyadmin?

I get a 403 Forbidden when I try to access my phpmyadmin. I installed it from the repository and choosed apache2 in the installation progress. The symlink phpmyadmin.conf in conf.d to apache.conf in ...
0
votes
0answers
70 views

Unable to install phpmyadmin on LAMP

I am trying to install phpmyadmin on LAMP on DigitalOcean. Everything is working properly, just checked here :- http://testpanda.com/info.php but when I try to install phpmyadmin using this command ...
-1
votes
1answer
603 views

How to quickly insert large amounts of days into MySQL? [closed]

I'm looking for a way to insert a ton of data manually into a MySQL table in the most efficient way. The source data currently lives on a web page (outside my control and so no access to the ...
0
votes
1answer
238 views

Can't login into phpMyAdmin with Safari

I have this weird problem that I can't login into phpMyAdmin with Safari. With every other system/browser I can login just fine, but not with my Safari browser. I tried to empty cache, history, etc., ...
2
votes
0answers
1k views

CentOS 5.10 Yum Packages won't update/upgrade

I've just used yum to install PhpMyAdmin and it installed version 2.11.11.3-2.el5 which is completely out of date since version 4 is out. I've tried running yum update phpmyadmin but I receive No ...
-2
votes
1answer
352 views

Can I give access to database without access to cpanel

I'm going to give a freelancer access to the database. The idea was to give him the access with SSH (MySQL Workbench). But it came out that to do so, I would need to give him the password to my cpanel ...
1
vote
1answer
11k views

how do I install phpmyadmin on windows server 2012 from scratch

how do I install phpmyadmin on windows server 2012 from scratch?? I dont even know where to begin this. I tried but it didn't work out. What else do I need to install in order to make this work? I do ...
1
vote
2answers
2k 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 ...
1
vote
0answers
9k views

How to fix: “phpMyAdmin - Error Cannot start session without errors”?

When I try to login to PHPmyadmin I get the following error: phpMyAdmin - Error Cannot start session without errors, please check errors given in your PHP and/or webserver log file and configure your ...
2
votes
2answers
16k views

How to fix the phpmyadmin error “json extension is missing”?

Today i have installed the xdebug packets. After installing them my phpmyadmin and different other softwares aren't working anymore. PhpMyAdmin gives this output: json extension is missing. First ...
0
votes
1answer
288 views

How do I fix the WSOD in phpMyAdmin and Drupal in chrooted Apache?

When I attempt to run phpMyAdmin (both 3.5.5 and 4.0.4.2) or Drupal (7.22) in chrooted Apache (2.2.3), I get the WSOD (White Screen Of Death; a.k.a. a blank page). I have tried with both mod_chroot ...
0
votes
1answer
54 views

creation of accounts for each users in mysql / phpmyadmin

I am planning to create mysql accounts for each of my web devs and build their own databases. I need these devs to have accounts to access their own phpmyadmin where they can manipulate their own sets ...
0
votes
1answer
1k views

Having formatting problems when exporting table from phpMyAdmin

I'm having some trouble in exporting some data directly from phpMyAdmin. I'm selecting a table in phpMyAdmin, from a specific database, and then I'm exporting that table in Excel based CSV format. ...
0
votes
1answer
5k 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 ...
-1
votes
1answer
75 views

phpMyAdmin: Make foreign relation more readable [closed]

I am adding some foreign relations in phpMyAdmin to make data more easily accessible when adding rows. How can I make the foreign relation value stay as is (ex. ad6c68d9c365364f437e4a569765de2e) but ...
0
votes
1answer
908 views

Insatall phpMyAdmin in CentOS vps

I can make a account in host1free.com.And now I had a vps server In this vps server opreting system is centOS and I can not use it before so I am newbie for this and I want to install a phpmyadmin in ...
1
vote
1answer
3k views

how to create table relationship diagram in phpmyadmin?

I want to create table relationship diagram in phpmyadmin. Anyone is there for the solution? Other necessary details Apache Version :2.2.22 PHP Version :5.4.3 MySQL Version :5.5.24 Wamp Version ...
6
votes
3answers
7k 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 ...
0
votes
5answers
206 views

phpMyAdmin - table names

When you have a table called sheep and you would like to call it c what would be the correct way to do this in phpMyAdmin when writing the query
0
votes
1answer
444 views

s accessing mysql database on server from other PCs

I have installed XAMPP on a server PC. I want to access it from other PC through MySQLWorkbench or even access it through server IP and PHPMyAdmin page. I tried configuring the httpd-xampp.conf file ...
0
votes
0answers
124 views

PhpMyAdmin keeps refreshing automatically on Chrome in Ubuntu?

When I log in to it (running on localhost) it keeps refreshing like crazy. It works alright in firefox though. Anyone had this problem before?
0
votes
0answers
585 views

XAMPP phpMyAdmin failed with #2002

New test server running Windows 7 64 bit. I installed XAMPP and created a seperate user other than the root. When I created another account and initiated XAMPP I was able to get localhost but when ...
1
vote
2answers
4k views

Is there any way to generate DDL SQL statements from database?

Given already created SQL databases, is there any way to generate the DDL SQL statements to recreate the database?
8
votes
3answers
4k views

I can't open phpMyAdmin, get error 301 or 500

I've installed phpMyAdmin, but I can't open it on any browser: I get a 301 redirect(*) if I browse to http://localhost:8080/phpmyadmin. If I add a / to the end of the addres, I get a 500 error status ...
2
votes
0answers
708 views

Row is not deleted in PHPMyAdmin

I am having problem deleting a row in PHPMyAdmin. I click the 'Delete' button to delete the row, at the top it says Showing rows 0 - 0 ( ~1 total , Query took 0.0004 sec) SELECT * FROM ...
2
votes
2answers
15k views

Completely removing apache + phpmyadmin + php from Ubuntu?

I am trying to completely remove apache + phpmyadmin + php from my Ubuntu operating system. For phpmyadmin i tried sudo apt-get autoremove phpmyadmin but the files were still in the /etc/ folder. ...
0
votes
2answers
1k views

Can't open and lock privilege tables: Table 'mysql.host' doesn't exist

i am working on windows 7 ..i am using xampp . i restarted my computer then after that when open the mysql yog..then it gives me an error error no 2003 can't connect to mysql server on localhost ...
0
votes
1answer
840 views

Running phpmyadmin xampp Ubuntu 12.10

I know it is a common problem and there are many solutions on the web but I'm trying everything and anything is working, I can't have phpmyadmin running on my machine. I installed XAMPP through: sudo ...
1
vote
1answer
5k views

phpMyAdmin is showing 403 Forbidden

I have just changed my www folders permission to 777 using this command sudo chmod -R 777 www And now when I try to open phpMyAdmin in browser and it is not opening and showing 403 Forbidden Error ...
0
votes
0answers
785 views

Configuring phpmyadmin.site.com subdomain with nginx

I have a Rails site being served by nginx. I want to also have phpmyadmin for the same data. My phpmyadmin is installed in /use/share/phpMyAdmin I wrote this in in my nginx.conf file: server { ...
1
vote
2answers
1k views

phpmyadmin wont work on fresh ubuntu 12.04 vb setup

I regularly set up virtualbox ubuntu setups to run as local webservers. I have set these up several times and never had an issue. However, something has changed: 1)vb guest additions no longer allow ...
0
votes
1answer
417 views

Export all posts as CSV from WordPress DB and open in OpenOffice/Excel

I am exporting all of my posts from phpMyAdmin as a CSV file using , as the column seperator and "" as the text delimeter. The export works fine but when I open it up in something like OpenOffice, ...
2
votes
2answers
9k views

can't login in phpmyadmin and mysql after fresh installation of lamp server and phpmyadmin on ubuntu 12.04 LTS

I am trying to search a solution for this problem, but didn't find a solution. I am getting an error while login in phpmyadmin #1045 Cannot log in to the MySQL server Connection for controluser as ...
1
vote
1answer
628 views

Config setting to open phpMyAdmin in default browser?

Is it possible to configure phpMyAdmin to open with the default browser? I searched in the .ini files in case there might be some string related to 'browser' or 'mozilla' etc, but couldn't find ...
1
vote
1answer
1k views

How can I see the entire table description in phpMyAdmin?

phpMyAdmin allows someone creating a table to add table comments: The problem is, when you view a table it doesn't show the complete contents of the field if it's longer than a specific number of ...
0
votes
1answer
2k views

getting a weird error whenever I try restarting apache

I'm trying to install apache, php5, mysql, and phpmyadmin. And I'm following a tutorial but this error keeps happening here's the error: apache2: Syntax error on line 227 of ...
1
vote
0answers
165 views

How can I make phpMyAdmin show the queries it runs?

Is there an option to make phpMyAdmin more verbose and tell what queries it runs? For some actions it does show the query but for most it doesn't.
0
votes
3answers
332 views

A site created on the Mac opens as a directory

I placed a phpmyadmin directory in the sites folder on the Mac. When I open the location of phpmyadmin in the browser, http://new-host-w.home/~username/phpmyadmin/ it opens as a directory instead of ...