The tag has no wiki summary.

learn more… | top users | synonyms

16
votes
7answers
53k 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 ...
14
votes
3answers
17k 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.
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
2answers
18k 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 ...
5
votes
3answers
23k 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
4answers
6k 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 ...
4
votes
3answers
55k 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
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 ...
3
votes
1answer
2k 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?
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
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 ...
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. ...
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?
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
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 ...
2
votes
2answers
2k 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 ...
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
0answers
902 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
484 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
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?
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
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
366 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.
1
vote
1answer
176 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
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 ...
1
vote
1answer
910 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
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 ...
1
vote
1answer
6k 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. ...
1
vote
1answer
18 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
276 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
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
1answer
3k 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
532 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
712 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
1answer
46 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
333 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
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 ...
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 ...
1
vote
1answer
87 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
38k 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
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 ...
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.
1
vote
1answer
676 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
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 ...
0
votes
3answers
2k views

phpmyadmin import database table from google spreadsheet

I'm managing a small website, which allows people to register as members. Previously I used a google form to manage member registration, but now as the number of users becomes quite big I am ...
0
votes
3answers
283 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
7k views

phpMyAdmin: Cannot load mcrypt extension. Please check your PHP configuration

I get this error message on the phpMyAdmin login page: phpMyAdmin: Cannot load mcrypt extension. Please check your PHP configuration. Does someone knows the reason for it? Thanks, Udo
0
votes
1answer
675 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 ...
0
votes
2answers
2k views

Unable to create PDF graphics of Database layout using phpmyadmin

I have phpMyAdmin 3.4.2 setup on a Windows 7 system. And following versions of PHP and Mysql are installed - PHP Version 5.3.6 mysqlnd 5.0.8-dev - 20102224 - $Revision: 308673 $ (appears in the ...
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?