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

learn more… | top users | synonyms

0
votes
0answers
564 views

Main php.ini file to change file size for phpmyadmin in Centos 6.4 with ISP Config 3 is not working

Hi I'm trying to upload a backup database via phpmyadmin. But the max upload size is 2mb. I changed php.ini file and restarted the apache but it does not work. the ini file that I changed is in ...
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
0answers
65 views

phpMyAdmin only shows two databases

Having a weird problem where mysql is showing multiple databases when I go SHOW DATABASES; I get 5 results. When I go to phpMyAdmin I only get two: information_schema and test. If you could ...
0
votes
0answers
491 views

Enable WAMP/phpmyadmin designer/relationview

I am using wamp 2.4e 32bit on windows8 Article 1, Article 2. 2nd one seemed better one to me. I have successfully created phpmyadmin database as instructed. Also I think the path where I am puting ...
1
vote
2answers
283 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
55 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
352 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
157 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
919 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
214 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
votes
3answers
6k 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
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 ...
1
vote
0answers
5k 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
12k 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
245 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
47 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
837 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
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 ...
-1
votes
1answer
67 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
670 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
2k 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 ...
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 ...
0
votes
5answers
107 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
350 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
100 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
458 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
2k 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
498 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
12k 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
994 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
769 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
4k 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
654 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
350 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
6k 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
536 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
925 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
148 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
285 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 ...
0
votes
1answer
533 views

Cannot Login To phpMyAdmin

I'm running a simple LAMP server at home from which I host a personal blog. The server is running Arch Linux, with the latest-and-greatest versions of Apache, MySQL, and PHP. In order to easily ...
0
votes
1answer
1k views

Setup phpMyAdmin on CentOS VirtualBox

I installed phpMyAdmin from sourceforge, following this tutorial. However, when I login, I see this notice: The phpMyAdmin configuration storage is not completely configured, some extended ...
2
votes
2answers
5k views

How can I create an ERD for my phpmyadmin database?

Is there a way I can create an Entity Relationship Diagram for my PHPMyAdmin database?
1
vote
4answers
1k views

Mac - Better GUI MySQL tool than phpMyAdmin [closed]

I've been running into a lot of shortcomings with phpMyAdmin, especially when it comes to anything Foreign Key related. Imports and Exports can be shady, and working with large amounts of data is a ...
0
votes
1answer
288 views

Can't remove phpmyadmin because of file lock

I interrupt my remote-session during the installation of myphpadmin. Now I want to remove and reinstall it. Now suddenly when I type in sudo apt-get remove phpmyadmin the following error message ...
3
votes
1answer
1k views

Phpmyadmin will not allow empty password

I am running Ubuntu 11.04 and I installed phpmyadmin(version 4:3.3.10-1). But when I try to use phpmyadmin, I get the error message as Login without a password is forbidden by configuration (see ...
1
vote
1answer
681 views

phpMyAdmin 3.4.4 install over MySQL 5.1 database with cookie authentication fails

I can't log into my instance of phpMyAdmin via cookie authentication using Google Chrome. I keep getting bounced back to the login page with a warning about cookies. I'm running Ubuntu 10.04.2 LTS ...
1
vote
2answers
10k views

WAMP MySQL Service will not start

I did a fresh install of WAMP (v2.1) and it works excep the MySQL isn't starting.... here: and everytime I press "Start/Resume Service", NOTHING happens. I go to my.ini and put in a password.Then ...