phpMyAdmin is an open source tool written in PHP to handle administration of MySQL over the web. It can perform various tasks such as creating, modifying or deleting databases, tables, fields or rows; executing SQL statements; monitor MySQL health status, or managing users and permissions.

learn more… | top users | synonyms

17
votes
2answers
22k views

How can I change the default storage engine in phpmyadmin?

I use InnoDB almost exclusively in my applications. However, if I'm not careful when setting up the table, I forget to change it and phpmyadmin sticks me with MyISAM. Is there a way to change the ...
10
votes
5answers
58k views

importing large SQL file phpmyadmin

I am trying to import this SQL file in phpmyadmin and got this message #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right ...
8
votes
2answers
120k views

How to resolve too many connections and fatal error in mysql running on vps

I am running an application PHPlist on my linode server, simultaneously running 12 PHP scripts, each of which opens a MySQL connection. Now when I access PHPlist it often shows this error: Fatal ...
8
votes
2answers
7k views

Running SQL Query on all databases

I have one hosting account using cPanel and phpmyadmin. I have 50 databases under this account, all WordPress. I need this query modified so that it runs through all databases to update the ...
7
votes
3answers
35k views

How to display database structure in phpMyAdmin?

Is there any way to generate a report of my database structure using phpMyAdmin? What I would like is a table format like the following, and an Entity Relationship table. Table name: List ...
7
votes
2answers
27k views

How can I reset a mysql table auto-increment to 1 in phpMyAdmin?

I know that in MySQL at the command line I can reset a table's auto-increment field to 1 with this: ALTER TABLE tablename AUTO_INCREMENT = 1 I am curious if there is a way to do this from within ...
7
votes
3answers
17k views

Why can't this mysql user log in with password?

In phpmyadmin I created a user called "edward" with password and all privileges: Yet when I try to log in via phpmyadmin, it says "Cannot log in to the MySQL Server". When I try to log in on the ...
7
votes
2answers
5k views

Is this a normal set of MySQL privileges?

Using phpmyadmin on a local test wamp setup, and well as pretty much the title states, there are 3 users marked as user = ANY, password = NO, such as: USER | HOST | Password | Global Priv | Grant ...
5
votes
5answers
3k views

Fast way of delete MySQL record

I have a 1.2 million record in a database table( it use index column also) I want to delete old 1 million record. I try to do it using PhpMyadmin but it take more time. DELETE FROM `table` WHERE ...
5
votes
2answers
2k views

MySQL error 2006 MySQL server has gone away after upgrade to 5.6.10 using homebrew on Max OS X 10.8.3 [closed]

I upgraded my installation of MySQL on my Mac OS X 10.8.3 using homebrew brew install mysql Everything seemed to go smoothly, but...not really, as it turns out. I cannot add a new user (neither ...
5
votes
1answer
6k views

How to export mysql database based on a where condition

I need to export the data and structure of a table but the data must have a specific condition (WHERE status=0 and id>20). How to export mysql database based on a where condition from phpMyAdmin or ...
5
votes
2answers
15k views

MySQL tables do not show up in the phpMyAdmin and MySQLWorkbench

I just setup the phpMyAdmin and I have this problem: When I login, I can't see any tables. I had tried this with MySQLWorkbench and I got the same result. Any suggestions ?
4
votes
1answer
10k views

how to retrieve rows of different dates using IN clause

My table structure: +-----------------+--------------+------+-----+-------------------+----------------+ | Field | Type | Null | Key | Default | Extra | ...
4
votes
2answers
17k views

Server requested authentication method unknown to the client [mysql_old_password]

Warning: PDO::__construct(): The server requested authentication method unknown to the client [mysql_old_password] SQLSTATE[HY000] [2054] The server requested authentication method unknown to the ...
4
votes
1answer
740 views

MySQL: Delete a record from all tables in one shot

I have a MySQL database, with one table that has a primary key, f_id that is referenced in multiple table as a foreign key. I want to delete all records where f_id is a specific value from all ...
4
votes
1answer
2k views

Stuck outside MySQL / XAMPP

I have been using XAMPP (on Windows XP/XAMPP 1.7.4 /PHP 5.3.5) for quite a while now, and last morning I started to get some weird messages when I was developing my website. It happened yesterday and ...
3
votes
1answer
714 views

How can I get MySQL to use the value returned by a function as a default?

I have a pre-existing table that has a column to that can hold a UUID. I'd like to be able to define a default such that new rows coming in (from legacy systems) will still get a UUID defined, via ...
3
votes
1answer
75 views

“zip” a mySQL (phpMyAdmin) database [duplicate]

I've created a large database on my local WAMP webserver. I would like to send that database with all tables and table data to another computer. Is this possible? mySQL ver: 5.5.15 PHP ver: ...
3
votes
2answers
108 views

optimize table in stored produce using phpMyAdmin causes out of sync error

I get the following error when running the code in phpMyAdmin. NOTE: I can run any other sql code (update, insert, replace) via phpMyAdmin in a stored procedure; but an optimize causes issues. NOTE: ...
3
votes
1answer
82 views

How identify tables with millions of entries

On a debian server with apache and mysql, how can I find out if any one table gets spammed? I have lots of different blogs, wordpress, wikis,... on my server of different customers. It seems like ...
3
votes
2answers
588 views

PHPMyAdmin for multiple servers w/ single pma database

We have PHPMyAdmin setup for our various MySQL instances. The annoying part is the current setup is requiring an individual pma database on each instance. Because of this the severs that are slaves ...
3
votes
1answer
936 views

SQL set profiling

I'm setting up an automatic database backup for a website. When I try to do a backup it comes up with the error" MySQL error: The 'SHOW PROFILE' feature is disabled; you need MySQL built with ...
2
votes
1answer
3k views

What is the difference between MySQL and PostgreSQL in terms of writing SQL queries? [closed]

Other than performance and security is there really any difference between MySQL and Postgres like SQL queries, built-in functions, procedures and so on? I'm asking this because I'm familiar with PHP ...
2
votes
2answers
77 views

Delete all highscores from a certain country

I have two tables: tbl_players tbl_highscores I need to delete all highscores that are registered from a certain country. My problem is that the language are set per player, rather than by ...
2
votes
2answers
4k views

Is there any way to recover a database after dropping from phpmyadmin?

I was planning to drop all the tables from a test account, but unfortunately, I didn't notice that I was in the production account when I chose to drop all the tables of my db from phpmyadmin ...
2
votes
3answers
25k views

How could I connect to MySQL database running on WAMP server from other computers in same LAN?

I'm new in web development. I'm requesting help from all of you. My problem is: I installed WAMP server in my desktop computer. My desktop computer has a static LAN IP (192.168.0.101). I'm able to ...
2
votes
3answers
17k views

How to use 2 auto increment columns in MySQL phpmyadmin

Is it possible to use 2 auto increment values ? One starting from 0 Another starting from 4000400 Please help me
2
votes
2answers
1k views

What is the difference between using varchar(100) and varchar(255)?

I want to know difference between varchar(100) and varchar(255) in terms of memory usage and programming problems of using more memory.
2
votes
2answers
4k views

Not able to access stored procedure from my application

I have written few stored procedures and executed in my server that is having php myadmin now while calling this stored procedure from my application it is showing following exception ...
2
votes
2answers
66 views

Backing up MySQL database

I have quite large and rather important DB to backup. First off, whats best way to do it? Secondly, easiest way I know is to export it through phpmyadmin, but, i'm worried about options, although ...
2
votes
1answer
844 views

Poor MySQL for Drupal on Shared Hosting

My Drupal site is on a shared host where I cannot modify the my.cnf configurations but the database seems to be performing poorly. Here are some of the flagged issues that I can see... In ...
2
votes
1answer
871 views

BACKUP and RESTORE MySQL Database

I have very specific question. I have seen the instructions on how to backup and restore mysql database using SSH but they barely explain the process when backing up on one server and restoring on ...
2
votes
1answer
536 views

Lost tables in Drupal site database

I have Drupal site on my local server build using pressflow I had problems with the xammp 1.7.4 server, so I delete everything except mysql and htdocs folders. I installed the server again, but the ...
2
votes
3answers
117 views

All My Databases Are Gone?

Today I changed my username and password in MySQL and I logged into phpmyadmin to see that all my databases were gone. I've tried changing the datapath but then I realized I didn't see any of my ...
2
votes
1answer
877 views

There is no export as SQL option

As CMS I use Wordpress. I want to export a whole category (windows 8) so I run the SQL command : SELECT * FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = ...
2
votes
1answer
445 views

phpmyadmin - Login issue, takes me back to the login page after logging in

I'd setup phpmyadmin quite a while ago and it worked well and I got everything setup and working etc... However, I went to login recently and it always just takes me back to the login page. The ...
2
votes
1answer
988 views

How to restrict MySQL user to not import and export database

I have created a read only MySQL user but this user have an option to export the database through phpmyadmin. How can I disable the options Export and Import?
2
votes
1answer
1k views

ON DELETE cascade alternate

I am trying to create a database for 2 Tables like: Table1 : tb1-id(pk) | tb2-id | other Table2 : tb2-id(pk) | other FOREIGN KEY Table2(tb2-id) REFERENCES Table1(tb1-id) ON DELETE ...
2
votes
1answer
2k views

PhpMyAdmin Missing parameter

Everything was working fine until this moment I want to create a new database and I'm receiving this error db_create.php: Missing parameter: new_db (FAQ 2.8) Also when I was trying to export my ...
2
votes
0answers
59 views

Why is our 1000 MB database file not uploading completely via phpMyAdmin?

We have an e-commerce Magento site and a large database of 1000 MB for that site. When we try to import the database through phpMyAdmin, it's not uploading the full databse, a lot of tables will be ...
2
votes
0answers
577 views

Recover innodb database from ibdata1 and *.frm files only

I have a problem on my server. I had a hard disk error on my server, and I restarted it. After that, I started wamp server software, but mysql services were not started. I checked all mysql data, ...
2
votes
1answer
156 views

Moving data from an old table into a newly created table with different field names / number of fields

I've been handed over management of a database, and I have had very little exposure to MySQL (or databases in general) so far. I would like to do two things, both of which are (I expect) fairly ...
2
votes
1answer
537 views

Analysis of MySQL database in real time Amazon RDS similar to phpMyAdmin

I'm using a single Amazon RDS instance (medium) to power several WordPress websites running on a single Amazon EC2 instance. I used to have my databases on another EC2 instance and installed ...
2
votes
0answers
281 views

PhpMyAdmin: UploadDir & SaveDir

Regarding UploadDir & SaveDir in phpmyadmin, I have them both set to './save' with permissions at 755. I am the only one using phpmyadmin, but still, could I make this tighter? Thanks PHP 5.3.3 ...
2
votes
0answers
187 views

phpMyAdmin slow for small database

I have a small database (<100 KB when dumped) that will hang in phpMyAdmin when I try to sort by various columns. Sometimes it hangs when I try to edit columns by directly clicking on their ...
2
votes
0answers
210 views

Can't access a specific database from phpMyAdmin

I've installed WAMP on a computer some months ago. Now I'm trying to use it and I was trying to surf the databases using phpMyAdmin. So I went to localhost/phpmyadmin and it showed me the databases. ...
2
votes
1answer
623 views

Change the same field from all the tables from a particular database

Suppose I have a database sitedb and in that I have 20 tables and a primary key(say uid) for one table is used in other tables as dependencies. uid is of type int with length 10. Lets say that the ...
1
vote
2answers
513 views

What exactly do database passwords protect?

I would like to know what exactly I am password protecting on my server when I set a database password. I am unclear as to what people are referring to when saying to password protect a database. Are ...
1
vote
1answer
4k views

MYSQL Triggers syntax

I need some help with my trigger statement, as I would like to only insert the new row if a column value does not already exist, or if it does exist update a corresponding column. Currently I have a ...
1
vote
2answers
83 views

How can I make an automatic copy of a MySQL database to another MySQL database on the same server?

I have two MySQL databases called LIVE and REPORTS on the same server. I want to copy the LIVE database and all its contents into the REPORTS database everyday at a specific time frame between 1 am ...