Super User
Super User

Questions tagged [phpmyadmin]

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

phpMyAdmin is a web-based utility written in PHP and used to manage MySQL databases on a server. phpMyAdmin provides a complete suite of tools for administering and managing MySQL databases, including database querying, data import and export, database server monitoring, and global search.

210 questions
44
votes
4 answers

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?
kettlepot
  • 1,015
41
votes
4 answers

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.
fazpas
  • 1,643
35
votes
12 answers

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 apt-get phpmyadmin but the command apt-get is not…
David
  • 2,307
  • 8
  • 25
  • 26
23
votes
2 answers

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 errors given in your PHP and/or webserver log file…
David
  • 2,307
  • 8
  • 25
  • 26
16
votes
2 answers

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.
user1032531
  • 1,711
15
votes
6 answers

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 perfectly, and also the homebrew, and it's updated.
HTML Man
  • 253
15
votes
3 answers

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?
Ben
  • 1,377
  • 7
  • 22
  • 40
11
votes
7 answers

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 go to MySQL console.. type in that password and…
test
  • 458
8
votes
3 answers

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 instead. (*) captured using Wireshark. If I use…
That Brazilian Guy
  • 7,094
6
votes
2 answers

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 prompts and one of them is: The phpmyadmin package…
miphe
  • 1,039
6
votes
4 answers

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 so, I do not know how to log out. I know this is…
user3159862
6
votes
6 answers

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 PHP installation properly. Also ensure that…
Hayden
  • 161
6
votes
4 answers

"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 database-viewer-app I have created a new User with limited…
Jonah Goldstein
  • 201
5
votes
2 answers

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 enabled by default. I followed the tutorial, but when I…
user317572
5
votes
2 answers

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?
drum
  • 719
1
2 3
…
13 14