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

learn more… | top users | synonyms

22
votes
8answers
69k 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 ...
15
votes
3answers
23k 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.
13
votes
2answers
23k views

Where is the PHP log file located on Mac OSX?

I am having issues with phpMyAdmin on my Mac. I cannot seem to connect to the local MySQL server. When I try to log in I get the following message Cannot start session without errors, please check ...
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 ...
7
votes
4answers
7k views

“login” to phpMyAdmin via different users

I want a non-techie (marketing/sales) to have access to the data I manage regularly via phpMyAdmin: without any ability to alter/insert/delete without me having to build a special ...
6
votes
3answers
6k 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 ...
6
votes
3answers
28k views

How can phpMyAdmin be restarted after /etc/phpmyadmin/config.inc.php is changed?

How can phpMyAdmin (running on Ubuntu 10.04) be restarted after the /etc/phpmyadmin/config.inc.php file was changed?
5
votes
1answer
3k views

Make the table listing show entire fields

I'd like to know if a way exists to make PHPMyAdmin show entire fields in the table browsing tab. Right now I have a TEXT field and I can never read the entries in their entirety. How can I do that?
4
votes
3answers
64k views

How can I start phpMyAdmin?

I have just installed phpMyAdmin on my Ubuntu (using sudo apt-get install libapache2-mod-auth-mysql php5-mysql phpmyadmin). I think installation went OK. So, how can I start the phpMyAdmin now? I ...
3
votes
2answers
3k 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 ...
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 ...
2
votes
2answers
15k 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 ...
2
votes
1answer
3k 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.
2
votes
2answers
14k 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. ...
2
votes
2answers
8k 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?
2
votes
1answer
2k views

Export MySQL database structure

I have a MySQL database. I would like to export the tables/structure to a script. I don't need the data, just a script to create all tables I have. I have access to PhpMyAdmin.
2
votes
2answers
8k 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 ...
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. ...
2
votes
1answer
71 views

phpmyadmin not displaying schema

I have a server with a large number of mysql databases. Recently some of the schemas have stopped displaying when logged in as Root. If I use the login for that specific database then I can see it. ...
2
votes
1answer
1k views

Chrome phpmyadmin Saved Password not coming up anymore

I'm using Chrome with 2 installs of phpmyadmin (3.3.2deb1 and 2.11.8.1deb5+lenny8). Since about 3 weeks ago, chrome does not remember the saved password anymore and doesn't prompt to save it. Both ...
2
votes
1answer
71 views

Is there a shortcut key to run a query PHPMyAdmin?

I run a lot of queries in phpmyadmin because it has a very nice display compared to mysql command line usage. I find it very inconvenient to always have to click the go button instead of pressing a ...
2
votes
2answers
874 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, ...
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
0answers
678 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 ...
1
vote
2answers
3k 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?
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 ...
1
vote
2answers
13k 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 ...
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 ...
1
vote
1answer
492 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
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 ...
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 ...
1
vote
1answer
30 views

PhpMyAdmin extra authentication - where is the password saved?

Some months ago I set up LAMP on my Ubuntu 14.04 DigitalOcean-server. I also installed PhpMyAdmin with an extra security layer. I have two domains attached to this server. For example1.com/phpmyadmin ...
1
vote
1answer
151 views

Unable to access phpMyAdmin on a LAMP setup on an Azure server

I am trying to install phpMyAdmin on LAMP on Azure. Everything is working properly, I just checked my server .net/info.php. I succesfully installed phpMyAdmin using this command: sudo apt-get ...
1
vote
1answer
47 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.
1
vote
2answers
314 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 ...
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
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 ...
1
vote
1answer
609 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
2answers
920 views

Convert a table into text file in phpmyadmin

I am using phpmyadmin on ubuntu to import a table, and I used this command select * from questionresults into outfile 'training.txt' to convert the table into text file, but I cant find where ...
1
vote
0answers
23 views

Manual SQL install error

I am receiving the following error when trying to manually install my SQL: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right ...
1
vote
0answers
27 views

Unable to access the PHP myadmin in windows due to the new security feature of xamp

Mine is a windows 7 64 bit machine with xamp v1.8.0,drupal 7.34 installed on the local server. I connect to the sever using the mstsc run command and load the url of the PHP myadmin and it loads ...
1
vote
1answer
104 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
457 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 ...
1
vote
1answer
40 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 ...
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 ...
1
vote
1answer
152 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. ...
1
vote
3answers
58k 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
0answers
8k 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 ...
1
vote
0answers
160 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.
1
vote
1answer
740 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 ...