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

learn more… | top users | synonyms

0
votes
1answer
971 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
498 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
926 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
1answer
211 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 ...
1
vote
0answers
651 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
142 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
42 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 ...
3
votes
2answers
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
6k 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
1k 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
228 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
44 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
3k views

csv file to phpmyadmin import error

here is the pattern of my csv file -------------------------------------------------------------- | col1 | col2 | | col4 | | ...
0
votes
1answer
153 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 ...
4
votes
2answers
6k 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 ...
-1
votes
1answer
936 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
127 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
77k 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
344 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
77 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
860 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
301 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
453 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
18k 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
3k 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 ...
2
votes
2answers
15k 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
3answers
20k 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
324 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
6k 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
1k 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
4k 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 ...
7
votes
3answers
10k 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
425 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
572 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
151 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
721 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 ...
3
votes
2answers
5k 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
5k 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
910 views

Row is not deleted in PHPMyAdmin

I have a problem deleting a row in PHPMyAdmin. When 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
18k 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
896 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
6k 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
922 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
2k 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 ...