Stack Overflow
Stack Overflow

Questions tagged [phpmyadmin]

phpMyAdmin is an open-source, web-based MySQL administration tool written in PHP. Use this tag for problems related to using this tool and not for general query problems

phpMyAdmin is an open source tool written in intended to handle the administration of over the Web. In other words, it allows you to handle MySQL via the web browser in a visual format, with no need to write complex commands from the command line. It can perform various tasks such as creating, reading, updating or deleting databases, tables, columns or rows (); executing statements; or managing users and permissions.

Since the version 4.0.0-alpha1, the HTML frames are gone and the navigation panel now presents a tree.

Features

  • Features provided by the program include:

  • Web interface

  • MySQL database management

  • Import data from CSV and SQL

  • Export data to various formats: CSV, SQL, XML, PDF (via the TCPDF
    library), ISO/IEC 26300 - OpenDocument Text and Spreadsheet, Word,
    Excel, LaTeX and others

  • Administering multiple servers

  • Creating PDF graphics of the database layout

  • Creating complex queries using Query-by-Example (QBE)

  • Searching globally in a database or a subset of it

  • Transforming stored data into any format using a set of predefined
    functions, like displaying BLOB-data as image or download-link

  • Live charts to monitor MySQL server activity like connections,
    processes, CPU/Memory usage, etc.

  • Working with different operating systems.

Useful links

Frequently asked questions

Check documentation for full list of frequent questions.

Similar lightweight tools:

16409 questions
3
votes
3 answers

phpMyAdmin table search returning empty result but SQL select works for specific table

It is very strange what is happening, I have never seen this before and I am pretty familiar with mysql. When searching a table using the phpMyAdmin table search feature, the result is empty no matter what I put. For example, searching 77 in the ID…
armd0202
  • 45
  • 1
  • 3
  • 7
3
votes
1 answer

#1062 - Duplicate entry '111' for key 'PRIMARY'

I am trying to import a DB in through phpMyAdmin and I'm having trouble with this particular error repeating itself even though I cannot find where the duplicate entry is. I changed some of the values of the PKs to see what would happen ie I changed…
NateHunt
  • 153
  • 1
  • 2
  • 8
3
votes
3 answers

Set up SQL query on timer with PHPmyAdmin

I am trying to execute a query on a timer (once a day at the same time). The query is the same every time. I grab data from excel and save it to my computer's desktop. Then UPDATE from file.csv with PHPmyAdmin. In phpmyadmin I do not see any option…
mattyd
  • 1,643
  • 2
  • 17
  • 26
3
votes
4 answers

How to update 200000 records in mySQL with single space in name field

I have more than 200000 records in my database with the customers name and information. The customer name has much space between first name and last name. ex. 1.ADAMS CRAIG 2. GABRIEL GEANETTE 3. KRANTZ AUDREY How I…
krish kim
  • 192
  • 4
  • 9
3
votes
4 answers

Insert .sql file into your MySQL database

I have installed XAMPP. In this I made a database via PhpMyadmin. How can I upload a SQL file to the database?
user1916274
  • 51
  • 1
  • 1
  • 2
3
votes
1 answer

Duplicate key name 'unique_id'

Here is the sql, however, there is an error says "*#1061 - Duplicate key name 'unique_id'* ", what is the problem. create table `users`( uid int(11) auto_increment, unique_id varchar(23) not null unique, name varchar(50) not null, email…
william007
  • 17,375
  • 25
  • 118
  • 194
3
votes
1 answer

Mysql UPDATE with selected data according to multiple tables

I wrote a SELECT query to select specific values, basically it only select data that is in all 3 tables. But when I try to update, it still updates more data (rows) than it should Here is select SELECT i.id, i.group_id, i.name, u.item,…
hihi
  • 41
  • 4
3
votes
0 answers

Exporting database from external server (without SSH access)

Our current website is hosted by the design agency who originally built the website, however we are bringing the development of the website in house therefore need to export the database from their server and import it to ours. We have FTP and…
Derek Carlisle
  • 485
  • 10
  • 27
3
votes
2 answers

Can't change table type to MyISAM

I'm trying to change a table's type to MyISAM but it won't let me: ALTER TABLE `mytable` ENGINE = MYISAM MySQL said: Documentation 1217 - Cannot delete or update a parent row: a foreign key constraint fails
user1701467
  • 285
  • 2
  • 7
  • 20
3
votes
2 answers

Modify Guest Order Email Address

I have a guest order in my Magneto system that I need to now modify the email address on file. The customer as mentioned did not create an account so I believe I will need to modify the MySQL tables directly. Can anyone point me in the right…
stitz
  • 1,429
  • 1
  • 16
  • 33
3
votes
1 answer

Nginx + Django + Phpmyadmin Configuration

I've migrated my server to amazon ec2, and trying to set up the following environment there: Nginx in the front serving static content, passing to django for dynamic content. I also would like to use phpmyadmin in this setting. I am not a server…
Ozgur Akcali
  • 5,264
  • 2
  • 31
  • 49
3
votes
2 answers

MySQL #1054 unknown column

When running the query below, I end up with a MYSQL error in PHPMyAdmin: #1054 - Unknown column 'wd.Datum' in 'having clause' This query belongs in a time reporting application, where users report time worked on projects on a daily basis. There's a…
David
  • 98
  • 2
  • 7
3
votes
1 answer

is it possible to run a stored procedure from within phpmyadmin 3.4.10.1?

i m wondering if phpMyAdmin can 'run' a stored procedure. I know I can create stored procedure using the sql tab in phpmyadmin, and that the stored procedure gets stored in the Routines table under InformationSchema database. When i try to CALL the…
kallakafar
  • 725
  • 3
  • 11
  • 27
3
votes
3 answers

Php form update in update the form

I am running while loop and fetch 3 records from database. and then update it on same page. Every record have submit button. But after edit when i submit the form it catchs the values of last record only and update other rows with the last record…
Zain Abid
  • 129
  • 2
  • 13
3
votes
1 answer

MySql error #1005 - Can't create table

I write a query when doing a tutorial Agile web application development with yii. I was trying to alter a table with this query and got this error in phpmyadin #1005 - Can't create table 'trackstar_dev.#sql-152_16' (errno: 121) (
Ashfaq Rahman
  • 85
  • 2
  • 5
  • 12
1 2 3
…
99
100