A web interface for MySQL and MariaDB

Overview

phpMyAdmin

A web interface for MySQL and MariaDB.

https://www.phpmyadmin.net/

Code status

Testsuite Selenium tests Documentation build status Translation status Coverage percentage Code quality score CII Best Practices

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 doc folder.

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

Translations are welcome, you can translate phpMyAdmin to 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.

Comments
  • Warning on creating unknown context

    Warning on creating unknown context

    There seems to be missing SQL parser context in some cases and it leads to further errors:

    Cannot modify header information - headers already sent by (output started at /home/kyle/www/phpmyadmin/libraries/sql-parser/src/Context.php:448)
    

    This report is related to user submitted report #29618 on the phpmyadmin error reporting server.

    Update: I think the cause is here: https://github.com/phpmyadmin/phpmyadmin/issues/12791#issuecomment-314750866

    bug automated-error-report parser 
    opened by nijel 139
  • Division by zero

    Division by zero

    Division by zero seems to happen when Util::getListNavigator gets $max_count = ''.

    Param | Value -----------|-------------------- Error Type | Warning Error Message |Division by zero Exception Type |php phpMyAdmin version |4.7.2 Incident count | 3 Link | Report#34173

    This comment is posted automatically by phpMyAdmin's error-reporting-server.

    bug automated-error-report 
    opened by nijel 113
  • automated normalization: Finding partial dependencies (both automated and manual) for 2NF

    automated normalization: Finding partial dependencies (both automated and manual) for 2NF

    Hi I need review on this. To convert table to second normal form we need to first find partial dependencies list in case table has composite primary key. For that I have created a form that user need to fill. Also if table has some data then using those data, in backend I'm calculating the possible partial dependencies list which user can see for help. Please have a look, and let me know if I'm doing something wrong and if have some suggestions for improvements.

    opened by smita786 102
  • Token mismatch error on every action

    Token mismatch error on every action

    I'm getting token mismatch on every link I click, and I can get only to the main menu screen, nothing else is working.

    I attach image where you can see the bug and the version of php, mysql and phpMyAdmin I'm using. Also I'm Windows 7 and using xampp 1.8.1 and Chrome/26.0.1410.64.

    Also here is the config file I build it with the setup option:

    /* Servers configuration */ $i = 0;

    /* Server: 127.0.0.1 [1] */ $i++; $cfg['Servers'][$i]['verbose'] = ''; $cfg['Servers'][$i]['host'] = '127.0.0.1'; $cfg['Servers'][$i]['port'] = ''; $cfg['Servers'][$i]['socket'] = ''; $cfg['Servers'][$i]['connect_type'] = 'tcp'; $cfg['Servers'][$i]['extension'] = 'mysqli'; $cfg['Servers'][$i]['nopassword'] = true; $cfg['Servers'][$i]['auth_type'] = 'http'; $cfg['Servers'][$i]['user'] = 'root'; $cfg['Servers'][$i]['password'] = ''; $cfg['Servers'][$i]['AllowNoPassword'] = true; $cfg['Servers'][$i]['CountTables'] = true;

    /* End of servers configuration */

    $cfg['DefaultLang'] = 'en'; $cfg['ServerDefault'] = 1; $cfg['UploadDir'] = ''; $cfg['SaveDir'] = ''; $cfg['AllowArbitraryServer'] = true; $cfg['UserprefsDeveloperTab'] = true; $cfg['Error_Handler']['display'] = true;


    • Original URL: https://sourceforge.net/p/phpmyadmin/bugs/3893/
    • Original author: pbojan
    • Found in version: 4.1.6
    • Attachment: http://sourceforge.net/p/phpmyadmin/bugs/3893/attachment/127.0.0.1%20%20%20127.0.0.1%20%20%20phpMyAdmin%204.0.0%20rc4.png
    bug duplicate 
    opened by pma-import 96
  • Internal encoding different than UTF-8

    Internal encoding different than UTF-8

    Quite many things on the error reporting server:

    Runtime Notice: htmlentities(): Only basic entities substitution is supported for multi-byte encodings other than UTF-8; functionality is equivalent to htmlspecialchars

    Seems like the internal encoding is set to something else than UTF-8 in these cases.

    This report is related to user submitted report #17586 on the phpmyadmin error reporting server.

    bug automated-error-report 
    opened by nijel 87
  • Warning open_basedir restriction in effect

    Warning open_basedir restriction in effect

    is_writable(): open_basedir restriction in effect. File(/var/www/tmp) is not within the allowed path(s): (/home/:/var/www/html/:/tmp:/var/tmp:/usr/loc

    This report is related to user submitted report #19832 on the phpmyadmin error reporting server.

    bug automated-error-report 
    opened by nijel 77
  • Warning on checking docs

    Warning on checking docs

    file_exists(): open_basedir restriction in effect. File(doc/html/index.html) is not within the allowed path(s): (/usr/share/phpmyadmin/:/etc/phpmyadmi

    This report is related to user submitted report #18227 on the phpmyadmin error reporting server (reported about 5000 times).

    bug automated-error-report 
    opened by nijel 73
  • Fonts too large

    Fonts too large

    Compared with version 2.7.0 the fonts used in 2.8.0 are one size too large. It is the same in IE, Firefox and Opera, all running on Windows XP.


    • Original URL: "https://sourceforge.net/p/phpmyadmin/bugs/2085/":https://sourceforge.net/p/phpmyadmin/bugs/2085/
    • Original author: tonymarston
    • Found in version: 2.8.0.2
    bug 
    opened by pma-import 73
  • 4.9.2+ Failed to set session cookie. Maybe you are using HTTP instead of HTTPS

    4.9.2+ Failed to set session cookie. Maybe you are using HTTP instead of HTTPS

    Getting the same error. Tried using Chrome (all extension disabled), IE, Firefox. Tried options of clearing cookies. Nothing in phpmyadmin, php, or apache error logs. No luck.

    using myPHPAdmin 4.9.2 with PHP Version 7.3.12 and MySQL version 8.0.18 with standard authentication.

    Failed to set session cookie. Maybe you are using HTTP instead of HTTPS to access phpMyAdmin.
    

    Originally posted by @Btazbt in https://github.com/phpmyadmin/phpmyadmin/issues/14184#issuecomment-563838701

    bug question 
    opened by williamdes 71
  • Error when linting RENAME query

    Error when linting RENAME query

    When linting "RENAME" query, following PHP error happens:

    Trying to get property of non-object

    Param | Value -----------|-------------------- Error Type | Notice Error Message |Trying to get property of non-object Exception Type |php phpMyAdmin version |4.7.2 Incident count | 3 Link | Report#34031

    This comment is posted automatically by phpMyAdmin's error-reporting-server.

    bug automated-error-report parser 
    opened by nijel 71
  • Gsoc central columns list

    Gsoc central columns list

    Hi, I have made basic page for managing central columns.. its not complete yet. 'm still working on it and 'll add commits. but meanwhile I wanted to know if if I'm going fine, if the page looks fine.

    opened by smita786 69
  • renaming database does not copy views in new database and throws error

    renaming database does not copy views in new database and throws error

    Issue #16422 is closed, but not fixed; I have database with views, renaimng database does not copy views in new database and throws error. Phpmyadmin 5.2.0

    Originally posted by @Lovor01 in https://github.com/phpmyadmin/phpmyadmin/issues/16427#issuecomment-1290422798

    bug affects/5.2 affects/5.3 
    opened by williamdes 0
  • UI bug in table structure menu

    UI bug in table structure menu

    image

    and

    image

    I think it5.3 different with demo. Looks not same ))

    Originally posted by @AsrorbekDev in https://github.com/phpmyadmin/phpmyadmin/issues/17693#issuecomment-1225164014

    bug ui good first issue affects/5.2 affects/5.3 
    opened by williamdes 0
  • Exporting user accounts does not contain `CREATE USER`

    Exporting user accounts does not contain `CREATE USER`

    Describe the bug

    The function to export a specific mysql user account does only contain the GRANT queries but a CREATE USER query in the begining is missing. This is a problem when importing the users to a MySQL 8 server which requires the CREATE USER query.

    To Reproduce

    Steps to reproduce the behavior:

    1. Go to 'User accounts' in the top menu
    2. Click on 'Export' on a specific user
    3. See only GRANT queries
    bug help wanted affects/5.2 affects/5.3 
    opened by rokka 3
  • fix: remove analyze explain button

    fix: remove analyze explain button

    Description

    The service mariadb.org/explain_analyzer is unavailable.

    I asked MariaDB via Slack and it's broken for a while.

    Fixes /

    Before submitting pull request, please review the following checklist:

    • [x] Make sure you have read our CONTRIBUTING.md document.
    • [x] Make sure you are making a pull request against the correct branch. For example, for bug fixes in a released version use the corresponding QA branch and for new features use the master branch. If you have a doubt, you can ask as a comment in the bug report or on the mailing list.
    • [x] Every commit has proper Signed-off-by line as described in our DCO. This ensures that the work you're submitting is your own creation.
    • [x] Every commit has a descriptive commit message.
    • [x] Every commit is needed on its own, if you have just minor fixes to previous commits, you can squash them.
    • [x] Any new functionality is covered by tests.
    opened by kesselb 2
  • Ref #17769 - replace superglobals with serverrequest in database/ controllers

    Ref #17769 - replace superglobals with serverrequest in database/ controllers

    Signed-off-by: Evgeny Skorlov [email protected]

    Description

    Ref https://github.com/phpmyadmin/phpmyadmin/issues/17769

    replace superglobals with serverrequest in Database/CentralColumnsController.php Database/OperationsController.php Database/QueryByExampleController.php Database/TrackingController.php

    opened by ru-asdx 1
Releases(RELEASE_5_2_0)
Owner
phpMyAdmin
We're building phpMyAdmin, the most used MySQL management tool.
phpMyAdmin
phpMyFAQ - Open Source FAQ web application for PHP and MySQL, PostgreSQL and other databases

phpMyFAQ 3.1 What is phpMyFAQ? phpMyFAQ is a multilingual, completely database-driven FAQ-system. It supports various databases to store all data, PHP

Thorsten Rinne 547 Dec 27, 2022
Staggered import of large and very large MySQL Dumps even through the web servers with hard runtime limit and those in safe mode.

Staggered import of large and very large MySQL Dumps (like phpMyAdmin dumps) even through the web servers with hard runtime limit and those in safe mode. | Persian Translation Version

Amir Shokri 5 Jan 8, 2022
TO DO LIST WITH LOGIN AND SIGN UP and LOGOUT using PHP and MySQL please do edit the _dbconnect.php before viewing the website.

TO-DO-LIST-WITH-LOGIN-AND-SIGN-UP TO DO LIST WITH LOGIN AND SIGN UP and LOGOUT using PHP and MySQL please do edit the _dbconnect.php before viewing th

Aniket Singh 2 Sep 28, 2021
A simple and extensible fixture loader for PHP 7.3+, supporting SQLite and MySQL

Flowder Flowder is a (really) simple fixture loader for PHP 7.3+, supporting SQLite and MySQL. Using Flowder in PHP 7.2 or below? Try version 1 instea

Joe Haines 6 Jan 17, 2021
Independent query builders for MySQL, PostgreSQL, SQLite, and Microsoft SQL Server.

Aura.SqlQuery Provides query builders for MySQL, Postgres, SQLite, and Microsoft SQL Server. These builders are independent of any particular database

Aura for PHP 424 Dec 12, 2022
A validating SQL lexer and parser with a focus on MySQL dialect.

SQL Parser A validating SQL lexer and parser with a focus on MySQL dialect. Code status Installation Please use Composer to install: composer require

phpMyAdmin 368 Dec 27, 2022
A simple PHP and MySQL based internet forum that displays the messages in classical threaded view (tree structure)

my little forum my little forum is a simple PHP and MySQL based internet forum that displays the messages in classical threaded view (tree structure).

Mark Hoschek 97 Dec 29, 2022
A Symfony application for managing and automating regular backups of MySQL databases.

DbSaver DbSaver is an application written by Bastien LOUGHIN allowing you to make automatic daily backups (and manual backups) for your MySQL database

Bastien 35 Nov 11, 2022
Very easy to use PDO MYSQL API. Just Include in PHP file and get it working.

CRUD-MYSQL-API Very easy to use PDO MYSQL API. Just Include in PHP file and get it working. INSTALATION Step 1: git clone https://github.com/arhex-lab

Abdul Raheem 4 Jun 14, 2022
Tiny php mysql lib (PDO-based) with handy fetch/update functionality, supports both SQL and parametric queries

Micro PHP mysql lib (~ 200 lines of code) with ultra powerful CRUD for faster than ever development: parametric fetch/insert/update/delete (based on a

Mr Crypster 18 Dec 10, 2022
A simple program to query mysql data and display the queried data in JSON format

A simple program to query mysql data and display the queried data in JSON format. The data displayed in JSON format will change and update as the data in your mysql database changes.

null 2 Mar 7, 2022
The Enobrev\ORM library is a small framework of classes meant to be used for simply mapping a mysql database to PHP classes, and for creating simply SQL statements using those classes.

The Enobrev\ORM library is a small framework of classes meant to be used for simply mapping a mysql database to PHP classes, and for creating simply SQL statements using those classes.

Mark Armendariz 0 Jan 7, 2022
PHP version of mysqldump cli that comes with MySQL

MySQLDump - PHP Requirements | Installing | Getting started | API | Settings | PDO Settings | TODO | License | Credits This is a php version of mysqld

diego torres 1.1k Jan 8, 2023
MySQL Spatial Data Extension integration with Laravel.

Laravel MySQL Spatial extension Laravel package to easily work with MySQL Spatial Data Types and MySQL Spatial Functions. Please check the documentati

Joseph Estefane 741 Jan 9, 2023
Symfony 5.2 + api platform project with ELK stack + elastic FileBeats for the log management. All running in 7 docker containers: nginx, php 8, mysql, elastic search, logstash, kibana, fileBeats.

Symfony with ELK and Elastic FileBeats Stack Prerequisites: Make sure that docker and docker-compose are installed in your machine and available for y

null 13 May 20, 2022
MySQL Load Data Infile Support For Laravel

Laravel Load File ?? A package to help with loading files into MySQL tables. This uses MySQL's LOAD DATA statement to load text files quickly into you

Ellis Green 64 Dec 30, 2022
A mysql database backup package for laravel

Laravel Database Backup Package This package will take backup your mysql database automatically via cron job. Installing laravel-backup The recommende

Mahedi Hasan Durjoy 20 Jun 23, 2021
Laravel Code Generator based on MySQL Database

Laravel Code Generator Do you have a well structed database and you want to make a Laravel Application on top of it. By using this tools you can gener

Tuhin Bepari 311 Dec 28, 2022
Small script for importing the KvK (Dutch Chamber of Commerce) Open Data Set (CSV file) to a MySQL database.

KvK-CSV-2-SQL Small script for importing the KvK (Dutch Chamber of Commerce) Open Data Set (CSV file) to a MySQL database. Table of content KvK-CSV-2-

BASTIAAN 3 Aug 5, 2022