phpmyadmin/phpmyadmin

A web interface for MySQL and MariaDB

phpMyAdmin

A web interface for MySQL and MariaDB.

https://www.phpmyadmin.net/

Code status

Download

You can get the newest release at https://www.phpmyadmin.net/.

If you prefer to follow the Git repository, the following branch and tag names may be of interest:

• STABLE is the current stable release.
• master is the development branch.
• Releases are tagged; for example, version 5.0.1 was tagged as RELEASE_5_0_1.

Note that phpMyAdmin uses Composer to manage library dependencies; when using Git development versions, you must manually run Composer. Please see the documentation for details.

More Information

Please see https://docs.phpmyadmin.net/, or browse the documentation in the docs folder.

For support or security issues, you can visit https://www.phpmyadmin.net/

Translations are welcome. You can translate phpMyAdmin into your language.

If you would like to contribute to the phpMyAdmin's codebase, you can read the code contribution file or browse our website's contributing page.

phpmyadmin's Issues

thai language support

Here is the thai language file.
It is done by someone at thaidev.com, I suppose.

---

- Original URL: https://sourceforge.net/p/phpmyadmin/patches/1/
- Original author: korakot

Advanced Search

One big feature that is missing in phpmyadmin is a
whole range of search options.

The search on the main.php page would search all
fields in all databases.

The search on the db-details page would search all
fields of all the tables in the current DB.

The search on the table properties page would search
all fields in the current table.

The output would create one or more html tables, each
table would be for a different database/table, the
tables would also contain an edit button/link.

Pete

---

- Original URL: https://sourceforge.net/p/phpmyadmin/feature-requests/22/
- Original author: trafficg

Bug in help path to MySQL website

help path on MySQL website is buggy.
One extra slash in it.

---

- Original URL: https://sourceforge.net/p/phpmyadmin/bugs/4/
- Original author: robbat2

Insert (clone data)

In tbl_change, add some radio buttons to specify
what to do after the saving of the current record:

O go back to browse
X insert (new data)
O insert (clone last data)

---

- Original URL: https://sourceforge.net/p/phpmyadmin/feature-requests/15/
- Original author: lem9

Do not show Insert or modify

Hi,
After Vérifier la table [Documentation]
Analyser la table [Documentation]
Réparer la table [Documentation]
Optimiser la table [Documentation]
you should not be allowed to insert or modify…
When I try it I get :
Warning: Supplied argument is not a valid MySQL result
resource in c:/anetpub/www/mysql/tblchange.php3 on
line 46

John.

---

- Original URL: https://sourceforge.net/p/phpmyadmin/bugs/15/
- Original author: jonx

Create Database Privilege

Show create database only on create_priv being set.

---

- Original URL: https://sourceforge.net/p/phpmyadmin/feature-requests/10/
- Original author: robbat2

Advanced Mode Failed

hi ,

i run Mysql 3.23.38
Apache 1.3.19
php 4.0.5

When :
$cfgServers¹[‘adv_auth’] = false;
$cfgServers¹[‘user’] = ‘root’;
$cfgServers¹[‘password’] = ‘pass’;
everything works very well

When :

$cfgServers¹[‘adv_auth’] = true;
$cfgServers¹[‘stduser’] = ‘root’;
$cfgServers¹[‘stdpass’] = ‘pass’;

i have a prompt for username / password
i enter :
login: root
pass : pass

and it doesn’t work

i can connect with command line to the sql server with
the same login/pass

the Officiel release work well

Best regards
Zappy

---

- Original URL: https://sourceforge.net/p/phpmyadmin/bugs/14/
- Original author: *anonymous

upd. swe. translation

Finally…

---

- Original URL: https://sourceforge.net/p/phpmyadmin/translations/1/
- Original author: d_nordenberg

Import a csv-file failed

Hello,

I’ve a problem with the import of a csv-file into a
table.
The version of phpMyAdmin is 2.2.0pre3
After submitting the import-page, the following error
message appears:
Error
MySQL: Query was empty

This problem comes up if the magic_quotes_gpc is not
enabled. ( I have a ISP with and one without
magic_quotes_gpc enabled)

After this error i try the old version 2.1.0 and thsi
version import these csv-file.

Is this a bug?

Percy

---

- Original URL: https://sourceforge.net/p/phpmyadmin/bugs/12/
- Original author: *anonymous

get_table_def: support FULLTEXT

Hi,

in lib.inc.php3, get_table_def should support FULLTEXT
indexes.

Some of the problems if we don’t support it:

-we can’t copy a table containing a FULLTEXT index
-if we try to dump the structure, the result is not
valid

---

- Original URL: https://sourceforge.net/p/phpmyadmin/feature-requests/17/
- Original author: lem9

get_table_def: support key length

In lib.inc.php3, get_table_def should support key length.

In the present version we lose the information about key lengths on table copy or table dump.

---

- Original URL: https://sourceforge.net/p/phpmyadmin/feature-requests/20/
- Original author: lem9

Re: Bookmarks

Hi

I have just setup the lastest CVS files and tested out
the new bookmark feature (cool), I just have one
suggestion:

When you select the bookmark can the bookmarked sql
string automatically appear in the "Run Sql Query"
text box. I run many queries that are identical apart
from one parameter. It would be nice if the bookmarked
query would appear and then I could just edit it a
little each time I wanted to run it.

eg…

If I bookmarked a query such as:

select \* from users where user = ‘pete’

Then next time I wanted to bring up a users
information I could just change pete to another name
etc…

Have fun
Pete Kelly

---

- Original URL: https://sourceforge.net/p/phpmyadmin/feature-requests/16/
- Original author: trafficg

Problem editing rows with large BLOBs

Some BLOBs (whose size I have not determined) are too
large to be edited. It does not seem to be based on
the datatype, but rather the amount of space used.

---

- Original URL: https://sourceforge.net/p/phpmyadmin/bugs/8/
- Original author: *anonymous

don`t show all the fields in browse

When the tables are big (more than 30 fields) the
display of all fields is too slow and unnecessary.
Display the 10 first fields and all under request.

---

- Original URL: https://sourceforge.net/p/phpmyadmin/feature-requests/6/
- Original author: *anonymous

Detect MySQL features per version

In many cases, with older versions of MySQL still quite prevalent out there, we should detect what
versions those are and hide some of the features that only the new versions support, such as table types
and full-text searchs.

---

- Original URL: https://sourceforge.net/p/phpmyadmin/feature-requests/12/
- Original author: robbat2

Display xx records on the select page

On the select page (tbl_select.php3), when you you
suppress the 30 default value in the display xx
records per page (or put a non numeric value) then
click go, you’ve the following

sql error :
<———>
Error
SQL-query:

SELECT … // sql request // … where 1
MySQL said:
<———>

and nothing else …

---

Proposed patch:
on file "tbl_select.php3", on line 115-116
(before "header("Header("Location …"), add :

require("config.inc.php3"); // we need $cfgMaxRows …
if (($sessionMaxRows += 0) == 0) { $sessionMaxRows =
$cfgMaxRows;}

---

Since I don’t know if it might break something else,
would someone look at this ( and apply if safe ;-) ).

---

- Original URL: https://sourceforge.net/p/phpmyadmin/bugs/11/
- Original author: hal0802

Browse table bug

Browse a table with 70 records, click "End", then
press "previous" once.

Now at this point the "Previous" and "Begin" buttons
stop working.

or

Browse a table with 50 records, next click "End".

Now at this point the "Previous" and "Begin" buttons
stop working.

During these examples everything was set to the
default parameters.

Have fun :-)

---

- Original URL: https://sourceforge.net/p/phpmyadmin/bugs/6/
- Original author: trafficg

Multiple DUMP

It would be great when you DUMP the whole database
but you want just a few of them (and you are lazy
to do id one by another :) to select (<SELECT>)
multiple tables to DUMP.

-th

---

- Original URL: https://sourceforge.net/p/phpmyadmin/feature-requests/21/
- Original author: *anonymous

User Admin

Ability to do some user administration if logged in as the root user.

Although it would probably be a lot of work.

---

- Original URL: https://sourceforge.net/p/phpmyadmin/feature-requests/4/
- Original author: robbat2

Fix Directory given to Mysql in Windows

Mysql do not accept the common windows directory
description with …
In ldi_check.php you will receive (if in an Windows
environment) a file path like c:\winnt\temp\php11.tmp
So to pass this path to MySQL, it will be needed to
change all \ into / or put a \ in front of all
existent …
You need to addslashes($textfile) before sending it to
mysql…

---

- Original URL: https://sourceforge.net/p/phpmyadmin/bugs/1/
- Original author: *anonymous

stylesheet bug

phpmyadmin has differnet dom paths for IE and other
browsers, it should be modified to work with all
dom-capable browsers, see:
http://bugzilla.mozilla.org/show_bug.cgi?id=66791

(this bug relates to 2.1, but I guess this hasn’t fixed
yet?)

---

- Original URL: https://sourceforge.net/p/phpmyadmin/bugs/2/
- Original author: *anonymous

(?) Edit Form Generator

une extention ŕ phpMyAdmin pour génerer un code php de
base ŕ partir des tables pour faire des formulaires
d’édition "affinés".

Les formulaires de phpMyAdmin
1° donnent accčs a tous les champs.
2° sont dynamiquement recréé ŕ chaque affichage.
3° affichent des informations sur le type de chaque
champs
4° ne vérifient pas l’intégrité d’un contenu de champs
lorsqu’il reprend un id venant d’une autre table de la
base.

Je voudrais faire un générateur paliant c’est 4
points.

Le but est de générer des formulaires "pręt" ŕ
l’emploi.
pour faire une page d’admin orienté vers la structure
de l’information et pas orienté vers la structure de
la base.

ainsi que le code générique traitant la soumission du

1. formulaire.

An extention to the project to generate a generic
code form a database to a HTML form.

Actual Form of PHPMyAdmin

1° give an acces edit to all fields
2° are dynamic rebuilt on every request
3° show all information about records
4° don’t check relation between table.

The extention should prupose an Form generator
readty to use on a website.

Two Use :

Admin page with control of relation between table.

User page on Insert/Edit records with control of
content.

---

- Original URL: https://sourceforge.net/p/phpmyadmin/feature-requests/23/
- Original author: moosh_fr

GZIP of the DUMP

Hi guys,

I made a little improvement which can GZIP the DUMP
sent to you.

Is there a possibility to add this improvement?

---

- Original URL: https://sourceforge.net/p/phpmyadmin/feature-requests/8/
- Original author: tehac

3 check boxes for indexes

try to translate in english below.

Pour la création d’une table ou l’ajout d’un champs.

on a 3 check box.

PRIMARY UNIQUE et INDEX.

Mais sauf si je me trompe.

UNIQUE -> toujours un index
et
PRIMARY -> Toujours un INDEX UNIQUE

1. alors pour koi un check box et pas radio ?

When adding a fields we have 3 check box for
PRIMARY UNIQUE et INDEX.

but if I’n not in wrong

UNIQUE is always an index
and
PRIMARY is always an INDEX UNIQUE

so why a check box and not a radio with 4 choice ?

---

- Original URL: https://sourceforge.net/p/phpmyadmin/feature-requests/25/
- Original author: moosh_fr

add query box to table page

To make querying from a specific table easier
(I do this a lot), a textarea box (copy partially from
database page) is added.
A default query (select \* from thistable where 1)
is given in the box as well

---

- Original URL: https://sourceforge.net/p/phpmyadmin/patches/3/
- Original author: korakot

String Outsourcing in main.php3

Move strings that are not outsourced in main.php3 to
the language files.

---

- Original URL: https://sourceforge.net/p/phpmyadmin/feature-requests/9/
- Original author: robbat2

mySQL Space Usage suggestion

Hi,

maybe i have a suggestion for a next phpMyAdmin
Version to show in tbl_properties.php3 the spaceusage
for the current table.

Here is my sample code:

http://www.neptunlabs.de/phpMyAdmin/tbl_properties.new

Steve Alberty

ps: how can i develop on phpmyadmin cvs?

---

- Original URL: https://sourceforge.net/p/phpmyadmin/feature-requests/26/
- Original author: *anonymous

INSERT in addition to UPDATE row

There are many times when adding a new row is only
minor modification from a previous row.
In this case phpmyadmin should add a new button
(INSERT)
to the edit row page, to allow the newly edited data be
added to table instead of updating existing row.

---

- Original URL: https://sourceforge.net/p/phpmyadmin/feature-requests/3/
- Original author: korakot

magic quotes?

Hi

I have been using the orgiinal MyAdmin and it is
great .. shame works not continued .. which is why i
was gald to find your here.

Only problem.. pasting SQL into old version works fine
with quotes

e.g. DEFAULT =‘0’

But on your version it escapes them with \‘0\’ which
creates an SQL error.

---

- Original URL: https://sourceforge.net/p/phpmyadmin/bugs/9/
- Original author: *anonymous

Table type in table creation/changing

During table creation, it should allow user to specify
table type.
When modifying table structure, it should allow changing
the table type as well

---

- Original URL: https://sourceforge.net/p/phpmyadmin/feature-requests/1/
- Original author: korakot

Minor "<?" fix

Minor fix for the "<?" occuring on line 255 of tbl_properties.php3

---

- Original URL: https://sourceforge.net/p/phpmyadmin/patches/4/
- Original author: robbat2

Language select error

Hi

I just installed the latest version and received this
message.

Warning: Undefined index: en-gb in select_lang.inc.php
on line 43

I am running Win2000,IIS5,PHP4.

I looked around various files to see if anything was
setup wrong and everything seemed OK

In the config file these are the language settings.

$cfgDefaultLang = "en";
$cfgLang = "en";

The error was the same with and without $cfgLang

I can get everything up and running if I add this line
to the language array

$txt_langname[‘en-gb’] = "english.inc.php";

Thanks
Pete Kelly

---

- Original URL: https://sourceforge.net/p/phpmyadmin/bugs/5/
- Original author: trafficg

Bookmarked SQL-query appear / disappear

You can see the "Bookmarked SQL-query" combo box under
the "Run SQL query" textarea when you click on a
database (left frame).
But when you click on a table (still left frame) the
page showing still has the "Run SQL query" textarea
but not anymore the "Bookmarked SQL-query" combo
box …
Should’nt it be added ?

---

- Original URL: https://sourceforge.net/p/phpmyadmin/feature-requests/18/
- Original author: hal0802

backup / restore database

Hi

I have known about this error for a while now and it
caused me loads of hassle in the past, luckily I can
use telnet now to backup and restore my databases but
a lot of users cannot.

The problems are caused by symbols within the data.

I have attached a sample database, if you can restore
this data you have solved 90% of the problems in this
area.

Another bug I have come across is, if your on a server
that only supports safemode, and you try and upload a
file, php will return a "permission denied" error when
you try and read the file.

Here is a helpful url.

http://www.aota.net/ubb/Forum15/HTML/000671-1.html

Good luck with these bugs.

If you need a hand testing any code in safe mode I
will help you out.

Pete Kelly

---

- Original URL: https://sourceforge.net/p/phpmyadmin/bugs/7/
- Original author: trafficg

Error when editing an entry from a subset

Hi,

I get an error if I:
- select a subset of rows with the ‘select’ option, or
by a given query
- edit a single entry
- save it

Phpmyadmin wants to return to the subset of rows and
gives this error:

Warning: Supplied argument is not a valid MySQL result
resource
in /home/projects/phpmyadmin/phpmyadmin.openeye.nl/sql.
php3 on line 72

Database openeye – table CommInfo
Error
SQL-query:

SELECT Id,Value from CommInfo where 1 and Value like
MySQL said: You have an error in your SQL syntax
near ’’ at line 1
Back

This is not a valid query indeed…

Thanks,
Stijn.

---

- Original URL: https://sourceforge.net/p/phpmyadmin/bugs/13/
- Original author: stijn

Function & Data Type improvments

For config.inc.php3:
Added type synoynms for those that prefer them.
Complete change of function table to include most of the MySQL functions.

---

- Original URL: https://sourceforge.net/p/phpmyadmin/patches/5/
- Original author: robbat2

Module for User Administration

New module for User Administration with the next functions:
- View all users
- Add/Edit/Delete users
- Change/Delete user’s password
- Add/Revoke/Edit user’s privileges with any Database/Table/Columns
- Check the user privileges with any Database

---

- Original URL: https://sourceforge.net/p/phpmyadmin/patches/6/
- Original author: dvilla

DB & Table Size

It would be useful if we can display the size of the
Databases & Tables or even a summary page with the
size breakdown.

Something like what ‘du -ach’ produces.

---

- Original URL: https://sourceforge.net/p/phpmyadmin/feature-requests/24/
- Original author: valcrow

config options, safe mode

When running apache/php under safe mode, the
set_time_limit() calls don’t work; ie php error msgs
like "Warning: Cannot set time limit in safe mode "
during
SQL data dumps.

I’d like to see a safe_mode unfriendly calls wrapped
in a conditional, the conditional based on whether
safe_mode is on/off.

In other words, a config option to make phpMyAdmin
safe_mode friendly.

---

- Original URL: https://sourceforge.net/p/phpmyadmin/feature-requests/19/
- Original author: *anonymous

Edit page: functions depend on type

In the edit page, the function in the dropdown box
should be limited to a few related to the data type of field.
For example, in set and enum, there should be no
dropdown at all, and in the time-type, it should only show
functions related to time.

---

- Original URL: https://sourceforge.net/p/phpmyadmin/feature-requests/14/
- Original author: korakot

Enum 2 case + null

If a field is an ENUM
i.e. ENUM
but not with NOT Null.

phpMyAdmin dont give the possibilities to empty the
field. In insert or change Form for a record.

Now In french because my English is perhaps too bad.

si on a un champs ENUM ŕ 2 cas
par exemple ENUM
mais pas avec NOT Null

dans un formulaire insert ou modif d’enregistrement,
phpMyAdmin ne permet pas de laisser le
champ "vide"//NULL.

---

- Original URL: https://sourceforge.net/p/phpmyadmin/bugs/10/
- Original author: *anonymous

Table-edit: Radio buttons for enums

Armel Fauveau suggests to replace, in table-edit mode,
pull-down menus by radio buttons, to improve the
interface.

---

- Original URL: https://sourceforge.net/p/phpmyadmin/feature-requests/13/
- Original author: lem9

PHP Warnings

Warning: mysql_db_query is deprecated; use
mysql_select_db() and mysql_query() instead
in /home/httpd/htdocs/phpmyadmin/sql.php3 on line 69

Warnings like this are generated when the warning
level is set appropriately. Software like phpMyAdmin
should work smoothly even at the highest error
reporting level.

---

- Original URL: https://sourceforge.net/p/phpmyadmin/bugs/16/
- Original author: *anonymous

please add stripslashes() in db_read_dum

Hi. In db_read_dump you can enter a sql-Query. If you give something like
select \* from bla where blo>‘bla’
then it says something like syntax error:
select \* from bla where blo>\‘bla\’

changing the line 29 in db_read_dump from

$sql_query = trim($sql_query);

to
$sql_query = trim(stripslashes($sql_query));

solves the Problem.

Just a quickie!

Thanks

Tex

---

- Original URL: https://sourceforge.net/p/phpmyadmin/bugs/17/
- Original author: *anonymous

.php package for PHP4 users

I would like to have a .php release just as they used
to have in PHPWizards. I use PHP 4 extensivly and I
really don’t like to have to change the exension.

---

- Original URL: https://sourceforge.net/p/phpmyadmin/feature-requests/7/
- Original author: baldusi

(?) In-place edit of fields

In the browse page, the data in table field should be
easily editable (change from text to text-box when clicked)
and many rows be edited simultaneosly.
This should be possible if implemented in cross-browser
javascript (DHTML).

---

- Original URL: https://sourceforge.net/p/phpmyadmin/feature-requests/11/
- Original author: korakot

Maintainance Features on Properties Page

Could you add repair, check, optimise and any other
maintainance features to the main database pages.

Thanks
Pete Kelly

---

- Original URL: https://sourceforge.net/p/phpmyadmin/feature-requests/5/
- Original author: trafficg

font in stylesheet for thai language

The demo site has the hard-code font in the style sheet
section.
(Arial, Helvetica, sans-serif from header.inc.php3)
This will affect the display of thai font (and maybe other
non-europian font as well).
I suggest the system that sourceforge is using, ie. it
have a standard fonts (about 3) to include in the
stylesheet
for each language.
So I can specify the font to use for thai.

---

- Original URL: https://sourceforge.net/p/phpmyadmin/bugs/3/
- Original author: korakot

Advanced index creation

Ability to create index on more than one field
or for the first N character of the field.
Creation of full-text index.

This should be a separate page.

---

- Original URL: https://sourceforge.net/p/phpmyadmin/feature-requests/2/
- Original author: korakot

change form method type

Need to change the method type from GET to POST in
tbl_select.php3 at LINE 19

This due problems when having huge tables with lots of
columns and the GET method will not allow so much data.

---

- Original URL: https://sourceforge.net/p/phpmyadmin/patches/2/
- Original author: *anonymous