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
  • Escape key hides the Create view dialog, it cannot be accessed

    Escape key hides the Create view dialog, it cannot be accessed

    Describe the bug

    During view creation, hitting the escape key hides the dialog but it is no longer accessible. Hitting escape could be needed to ignore auto suggest.

    To Reproduce

    Steps to reproduce the behavior:

    1. Open any database
    2. On view click New
    3. Enter some fields, perhaps triggering auto suggest.
    4. Hit escape

    Expected behavior

    Nothing or auto suggest popup disappears.

    Screenshots

    image

    Server configuration

    • Operating system:w11
    • Web server:Apache
    • Database version:10.7.3
    • PHP version:8.1.5
    • phpMyAdmin version:5.2.0

    Client configuration

    • Browser:Firefox
    • Operating system:w11

    Additional context

    Add any other context about the bug here.

    bug affects/5.2 affects/5.3 confirmed/5.2 confirmed/5.3 
    opened by theking2 3
  • 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 1
  • 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 3
Releases(RELEASE_5_2_0)
Owner
phpMyAdmin
We're building phpMyAdmin, the most used MySQL management tool.
phpMyAdmin
Damn Vulnerable Web Application (DVWA) is a PHP/MySQL web application that is damn vulnerable.

Damn Vulnerable Web Application (DVWA) is a PHP/MySQL web application that is damn vulnerable. Its main goal is to be an aid for security professionals to test their skills and tools in a legal environment, help web developers better understand the processes of securing web applications and to aid both students & teachers to learn about web application security in a controlled class room environment.

Robin Wood 7k Jan 5, 2023
Simple web interface to manage Redis databases.

phpRedisAdmin phpRedisAdmin is a simple web interface to manage Redis databases. It is released under the Creative Commons Attribution 3.0 license. Th

Erik Dubbelboer 3k Dec 31, 2022
amadeus-ws-client: PHP client for the Amadeus GDS SOAP Web Service interface

amadeus-ws-client: PHP client for the Amadeus GDS SOAP Web Service interface This client library provides access to the Amadeus GDS SOAP Web Service i

Amadeus Benelux 164 Nov 18, 2022
phpRedisAdmin is a simple web interface to manage Redis databases.

phpRedisAdmin phpRedisAdmin is a simple web interface to manage Redis databases. It is released under the Creative Commons Attribution 3.0 license. Th

Erik Dubbelboer 2.8k Dec 1, 2021
Web interface to manage multiple instance of lxd

LXDMosaic ?? Share your feedback ?? More input required ?? Roadmap ??️ Docs ?? Get Started Prepare LXD Setup LXD and ensure LXD is available over the

null 438 Dec 27, 2022
PHP, MySQL and JS based web chat application

About The Project Chat Application coded in PHP, CSS3 and JS. This is just a project to learn and improve understanding on certain topics. This is not

Neil 8 Apr 18, 2022
Open Source Voucher Management System is a web application for manage voucher. used PHP with Laravel Framework and use MySQL for Database.

Voucher Management System is a web application for manage voucher. You can create and manage your voucher. Voucher Management System is used PHP with Laravel Framework and use MySQL for Database.

Artha Nugraha Jonar 34 Sep 17, 2022
Web application for the health record of the Hemal's Thalasseamia Patients. Technologies PHP, JavaScript, HTML, W3.CSS and MySQL

Web application for the health record of the Hemal's Thalasseamia Patients. Technologies PHP, JavaScript, HTML, W3.CSS and MySQL

Thilrash Gowzul Ameen 1 Dec 15, 2021
A Responsive Web Chat App Using Php , MySql and JavaScript

Web-Chat-App A Responsive Web Chat App Using Php , MySql and JavaScript Prerequisites XAMPP [Php Runtime Environment] click HERE To Download XAMPP Set

Luttapi 4 Jul 12, 2022
Um chat web feito com HTML, CSS, SASS, JS, PHP e MYSQL

ChatWeb Tecnologias Front-end usadas: Pré processador CSS: Linguagem de programação usada: Projeto hospedado no: Editor de texto usado: Objetivos: Par

Adriel Cavalcante 4 Oct 27, 2022
A unified front-end for different queuing backends. Includes a REST server, CLI interface and daemon runners.

PHP-Queue A unified front-end for different queuing backends. Includes a REST server, CLI interface and daemon runners. Why PHP-Queue? Implementing a

CoderKungfu 646 Dec 30, 2022
A simple wrapper for PHP Intervention Library to provide a more simple interface and convenient way to convert images to webp

This package is a simple wrapper for PHP Intervention Library to provide a more simple interface and convenient way to convert images to webp - next generation format - extension, and resize them to render only needed sizes.

eyad hamza 18 Jun 28, 2022
Created simple login system and chat type website using mysql database along with php and html , css and javascript.

Created simple login system and chat type website using mysql database along with php and html , css and javascript.

null 1 Jan 6, 2022
TinyFileManager is web based file manager and it is a simple, fast and small file manager with a single file, multi-language ready web application

TinyFileManager is web based file manager and it is a simple, fast and small file manager with a single file, multi-language ready web application for storing, uploading, editing and managing files and folders online via web browser. The Application runs on PHP 5.5+, It allows the creation of multiple users and each user can have its own directory and a build-in support for managing text files with cloud9 IDE and it supports syntax highlighting for over 150+ languages and over 35+ themes.

Prasath Mani 3.5k Jan 7, 2023
Kyle is a web application built with Laravel for web developers and small companies to efficiently track and stay on top of yearly expenses related to services

Kyle Kyle is a web application built with Laravel for web developers and small companies to efficiently track and stay on top of yearly expenses relat

Laravelista 36 Jul 15, 2022
Switch the DokuWiki interface language according to the accept-language request header

Switch the DokuWiki interface language according to the accept-language request header

CosmoCode GmbH 1 Jan 4, 2022
Interface Network is an application about social media

Interface Network is an application about social media

Noval 3 Apr 20, 2022
Roundcube Webmail is a browser-based multilingual IMAP client with an application-like user interface.

Roundcube Webmail roundcube.net ATTENTION This is just a snapshot from the GIT repository and is NOT A STABLE version of Roundcube. It's not recommend

Roundcube Webmail Project 4.7k Dec 28, 2022
Bolt is a simple CMS written in PHP. It is based on Silex and Symfony components, uses Twig and either SQLite, MySQL or PostgreSQL.

⚠️ Note - Not the latest version This is the repository for Bolt 3. Please know that Bolt 5 has been released. If you are starting a new project, plea

Bolt 4.1k Dec 27, 2022