BetterMyAdmin
  • Introduction
    • Supported features
    • Shortcut keys
    • A word about users
  • Requirements
    • Runtime
    • Database
    • Web browser
  • Installation
    • Installing using Docker
      • Docker environment variables
      • Customizing configuration file using Docker
    • Installing from a checkout
    • Quick Install
      • Manually creating the file
      • Using the Setup script
    • phpMyAdmin configuration storage
      • Zero configuration
      • Manual configuration
    • Upgrading from an older version
    • Using authentication modes
      • HTTP authentication mode
      • Cookie authentication mode
      • Signon authentication mode
      • Config authentication mode
    • Securing your BetterMyAdmin installation
    • Using SSL for connection to database server
    • Known issues
      • Users with column-specific privileges are unable to “Browse”
      • Trouble logging back in after logging out using ‘http’ authentication
  • Configuration
    • Basic settings
    • BetterMyAdmin settings
    • Server connection settings
    • Generic settings
    • Cookie authentication options
    • Navigation panel setup
    • Main panel
    • Database structure
    • Browse mode
    • Editing mode
    • Export and import settings
    • Tabs display settings
    • PDF Options
    • Languages
    • Web server settings
    • Theme settings
    • Design customization
    • Text fields
    • SQL query box settings
    • Upload/save/import directories
    • Various display setting
    • Page titles
    • Theme manager settings
    • Default queries
    • MySQL settings
    • Default options for Transformations
    • Console settings
    • Developer
    • Examples
      • Basic example
      • Example for signon authentication
      • Example for IP address limited autologin
      • Example for using multiple MySQL servers
      • Google Cloud SQL with SSL
      • Amazon RDS Aurora with SSL
      • reCaptcha using hCaptcha
      • reCaptcha using Turnstile
      • reCaptcha using Google reCaptcha v2/v3
  • User Guide
    • Configuring BetterMyAdmin
    • Two-factor authentication
      • Authentication Application (2FA)
      • Hardware Security Key (WebAuthn/FIDO2)
      • Hardware Security Key (FIDO U2F)
      • Simple two-factor authentication
    • Transformations
      • Introduction
      • Usage
      • File structure
      • The External transformation
    • Bookmarks
      • Storing bookmarks
      • Variables inside bookmarks
      • Browsing a table using a bookmark
    • Query tabs
      • Keyboard
      • Storage
    • User management
      • Creating a new user
      • Editing an existing user
      • Deleting a user
      • Assigning privileges to user for a specific database
      • Configurable menus and user groups
    • Relations
      • Technical info
      • Relation view
        • Relation view example
      • Designer
      • Diagram
    • Charts
      • Chart implementation
      • Examples
        • Pie chart
        • Bar and column chart
        • Scatter chart
        • Line, spline and timeline charts
    • Server status: dashboard and slow queries
      • Dashboard
      • Slow queries
    • Import and export
      • Import
        • CSV
        • CSV using LOAD DATA
        • ESRI Shape File
        • MediaWiki
        • Open Document Spreadsheet (ODS)
        • SQL
        • XML
      • Export
        • CodeGen
        • CSV
        • CSV for Microsoft Excel
        • Microsoft Word 2000
        • JSON
        • LaTeX
        • TOON
        • MediaWiki
        • OpenDocument Spreadsheet
        • OpenDocument Text
        • PDF
        • JavaScript module
        • SQL
        • Texy!
        • XML
        • YAML
    • Custom Themes
      • Configuration
      • Creating custom theme
        • Theme metadata
    • Command palette
      • Opening it
      • What it lists
      • Choosing an entry
      • For developers
    • Other sources of information
      • Printed Book
      • Tutorials
        • Česky (Czech)
        • English
        • Русский (Russian)
  • AI agents and scripts
    • The API
    • MCP
  • FAQ - Frequently Asked Questions
    • Server
      • 1.1 My server is crashing each time a specific action is required or phpMyAdmin sends a blank page or a page full of cryptic characters to my browser, what can I do?
      • 1.2 My Apache server crashes when using phpMyAdmin.
      • 1.3 (withdrawn).
      • 1.4 Using phpMyAdmin on IIS, I’m displayed the error message: “The specified CGI application misbehaved by not returning a complete set of HTTP headers …”.
      • 1.5 Using phpMyAdmin on IIS, I’m facing crashes and/or many error messages with the HTTP.
      • 1.6 I can’t use phpMyAdmin on PWS: nothing is displayed!
      • 1.7 How can I gzip a dump or a CSV export? It does not seem to work.
      • 1.8 I cannot insert a text file in a table, and I get an error about safe mode being in effect.
      • 1.9 (withdrawn).
      • 1.10 I’m having troubles when uploading files with phpMyAdmin running on a secure server. My browser is Internet Explorer and I’m using the Apache server.
      • 1.11 I get an ‘open_basedir restriction’ while uploading a file from the import tab.
      • 1.12 I have lost my MySQL root password, what can I do?
      • 1.13 (withdrawn).
      • 1.14 (withdrawn).
      • 1.15 I have problems with mysql.user column names.
      • 1.16 I cannot upload big dump files (memory, HTTP or timeout problems).
      • 1.17 Which Database versions does BetterMyAdmin support?
      • 1.17a I cannot connect to the MySQL server. It always returns the error message, “Client does not support authentication protocol requested by server; consider upgrading MySQL client”
      • 1.18 (withdrawn).
      • 1.19 I can’t run the “display relations” feature because the script seems not to know the font face I’m using!
      • 1.20 I receive an error about missing mysqli and mysql extensions.
      • 1.21 I am running the CGI version of PHP under Unix, and I cannot log in using cookie auth.
      • 1.22 I don’t see the “Location of text file” field, so I cannot upload.
      • 1.23 I’m running MySQL on a Win32 machine. Each time I create a new table the table and column names are changed to lowercase!
      • 1.24 (withdrawn).
      • 1.25 I am running Apache with mod_gzip-1.3.26.1a on Windows XP, and I get problems, such as undefined variables when I run a SQL query.
      • 1.26 I just installed phpMyAdmin in my document root of IIS but I get the error “No input file specified” when trying to run phpMyAdmin.
      • 1.27 I get empty page when I want to view huge page (eg. db_structure.php with plenty of tables).
      • 1.28 My MySQL server sometimes refuses queries and returns the message ‘Errorcode: 13’. What does this mean?
      • 1.29 When I create a table or modify a column, I get an error and the columns are duplicated.
      • 1.30 I get the error “navigation.php: Missing hash”.
      • 1.31 Which PHP versions does phpMyAdmin support?
      • 1.32 Can I use HTTP authentication with IIS?
      • 1.33 (withdrawn).
      • 1.34 Can I directly access a database or table pages?
      • 1.35 Can I use HTTP authentication with Apache CGI?
      • 1.36 I get an error “500 Internal Server Error”.
      • 1.37 I run BetterMyAdmin on cluster of different machines and password encryption in cookie auth doesn’t work.
      • 1.38 (withdrawn).
      • 1.39 When I try to connect via https, I can log in, but then my connection is redirected back to http. What can cause this behavior?
      • 1.40 When accessing BetterMyAdmin via an Apache reverse proxy, cookie login does not work.
      • 1.41 When I view a database and ask to see its privileges, I get an error about an unknown column.
      • 1.42 How can I prevent robots from accessing BetterMyAdmin?
      • 1.43 Why can’t I display the structure of my table containing hundreds of columns?
      • 1.44 How can I reduce the installed size of phpMyAdmin on disk?
      • 1.45 I get an error message about unknown authentication method caching_sha2_password when trying to log in
      • 1.46 Missing HTTP_HOST variable when using nginx with HTTP/3
    • Configuration
      • 2.1 The error message “Warning: Cannot add header information - headers already sent by …” is displayed, what’s the problem?
      • 2.2 BetterMyAdmin can’t connect to MySQL. What’s wrong?
      • 2.3 The error message “Warning: MySQL Connection Failed: Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (111) …” is displayed. What can I do?
      • 2.4 Nothing is displayed by my browser when I try to run BetterMyAdmin, what can I do?
      • 2.5 Each time I want to insert or change a row or drop a database or a table, an error 404 (page not found) is displayed or, with HTTP or cookie authentication, I’m asked to log in again. What’s wrong?
      • 2.6 I get an “Access denied for user: ‘root@localhost’ (Using password: YES)”-error when trying to access a MySQL-Server on a host which is port-forwarded for my localhost.
      • 2.7 Using and creating themes
      • 2.8 I get “Missing parameters” errors, what can I do?
      • 2.9 Seeing an upload progress bar
      • 2.10 How to generate a string of random bytes
    • Known limitations
      • 3.1 When using HTTP authentication, a user who logged out can not log in again in with the same nick.
      • 3.2 When dumping a large table in compressed mode, I get a memory limit error or a time limit error.
      • 3.3 With InnoDB tables, I lose foreign key relationships when I rename a table or a column.
      • 3.4 I am unable to import dumps I created with the mysqldump tool bundled with the MySQL server distribution.
      • 3.5 When using nested folders, multiple hierarchies are displayed in a wrong manner.
      • 3.6 (withdrawn).
      • 3.7 I have table with many (100+) columns and when I try to browse table I get series of errors like “Warning: unable to parse url”. How can this be fixed?
      • 3.8 I cannot use (clickable) HTML-forms in columns where I put a MIME-Transformation onto!
      • 3.9 I get error messages when using “–sql_mode=ANSI” for the MySQL server.
      • 3.10 Homonyms and no primary key: When the results of a SELECT display more than one row with the same value (for example SELECT lastname from employees where firstname like 'A%' and two “Smith” values are displayed), if I click Edit I cannot be sure that I am editing the intended row.
      • 3.11 The number of rows for InnoDB tables is not correct.
      • 3.12 (withdrawn).
      • 3.13 I get an error when entering USE followed by a db name containing an hyphen.
      • 3.14 I am not able to browse a table when I don’t have the right to SELECT one of the columns.
      • 3.15 (withdrawn).
      • 3.16 (withdrawn).
      • 3.17 (withdrawn).
      • 3.18 When I import a CSV file that contains multiple tables, they are lumped together into a single table.
      • 3.19 When I import a file and have BetterMyAdmin determine the appropriate data structure it only uses int, decimal, and varchar types.
      • 3.20 After upgrading, some bookmarks are gone or their content cannot be shown.
      • 3.21 I am unable to log in with a username containing unicode characters such as á.
    • ISPs, multi-user installations
      • 4.1 I’m an ISP. Can I setup one central copy of BetterMyAdmin or do I need to install it for each customer?
      • 4.2 What’s the preferred way of making BetterMyAdmin secure against evil access?
      • 4.3 I get errors about not being able to include a file in /lang or in /libraries.
      • 4.4 BetterMyAdmin always gives “Access denied” when using HTTP authentication.
      • 4.5 Is it possible to let users create their own databases?
      • 4.6 How can I use the Host-based authentication additions?
      • 4.7 Authentication window is displayed more than once, why?
      • 4.8 Which parameters can I use in the URL that starts BetterMyAdmin?
    • Browsers or client OS
      • 5.1 I get an out of memory error, and my controls are non-functional, when trying to create a table with more than 14 columns.
      • 5.2 With Xitami 2.5b4, phpMyAdmin won’t process form fields.
      • 5.3 I have problems dumping tables with Konqueror (phpMyAdmin 2.2.2).
      • 5.4 I can’t use the cookie authentication mode because Internet Explorer never stores the cookies.
      • 5.5 (withdrawn).
      • 5.6 (withdrawn).
      • 5.7 I refresh (reload) my browser, and come back to the welcome page.
      • 5.8 (withdrawn).
      • 5.9 (withdrawn).
      • 5.10 (withdrawn).
      • 5.11 Extended-ASCII characters like German umlauts are displayed wrong.
      • 5.12 Mac OS X Safari browser changes special characters to “?”.
      • 5.13 (withdrawn)
      • 5.14 (withdrawn)
      • 5.15 (withdrawn)
      • 5.16 With Internet Explorer, I get “Access is denied” Javascript errors. Or I cannot make BetterMyAdmin work under Windows.
      • 5.17 With Firefox, I cannot delete rows of data or drop a database.
      • 5.18 (withdrawn)
      • 5.19 I get JavaScript errors in my browser.
      • 5.20 I get errors about violating Content Security Policy.
      • 5.21 I get errors about potentially unsafe operation when browsing table or executing SQL query.
    • Using BetterMyAdmin
      • 6.1 I can’t insert new rows into a table / I can’t create a table - MySQL brings up a SQL error.
      • 6.2 When I create a table, I set an index for two columns and BetterMyAdmin generates only one index with those two columns.
      • 6.3 How can I insert a null value into my table?
      • 6.4 How can I backup my database or table?
      • 6.5 How can I restore (upload) my database or table using a dump? How can I run a “.sql” file?
      • 6.6 How can I use the relation table in Query-by-example?
      • 6.7 How can I use the “display column” feature?
      • 6.8 How can I produce a PDF schema of my database?
      • 6.9 BetterMyAdmin is changing the type of one of my columns!
      • 6.10 When creating a privilege, what happens with underscores in the database name?
      • 6.11 What is the curious symbol ø in the statistics pages?
      • 6.12 I want to understand some Export options.
      • 6.13 I would like to create a database with a dot in its name.
      • 6.14 (withdrawn).
      • 6.15 I want to add a BLOB column and put an index on it, but MySQL says “BLOB column ‘…’ used in key specification without a key length”.
      • 6.16 How can I simply move in page with plenty editing fields?
      • 6.17 Transformations: I can’t enter my own mimetype! What is this feature then useful for?
      • 6.18 Bookmarks: Where can I store bookmarks? Why can’t I see any bookmarks below the query box? What are these variables for?
      • 6.19 How can I create simple LATEX document to include exported table?
      • 6.20 I see a lot of databases which are not mine, and cannot access them.
      • 6.21 In edit/insert mode, how can I see a list of possible values for a column, based on some foreign table?
      • 6.22 Bookmarks: Can I execute a default bookmark automatically when entering Browse mode for a table?
      • 6.23 Export: I heard BetterMyAdmin can export Microsoft Excel files?
      • 6.24 Now that BetterMyAdmin supports native MySQL 4.1.x column comments, what happens to my column comments stored in pmadb?
      • 6.25 (withdrawn).
      • 6.26 How can I select a range of rows?
      • 6.27 What format strings can I use?
      • 6.28 (withdrawn).
      • 6.29 Why can’t I get a chart from my query result table?
      • 6.30 Import: How can I import ESRI Shapefiles?
      • 6.31 How do I create a relation in designer?
      • 6.32 How can I use the zoom search feature?
      • 6.33 When browsing a table, how can I copy a column name?
      • 6.34 How can I use the Favorite Tables feature?
      • 6.35 How can I use the Range search feature?
      • 6.36 What is Central columns and how can I use this feature?
      • 6.37 How can I use Improve Table structure feature?
      • 6.38 How can I reassign auto-incremented values?
      • 6.39 What is the “Adjust privileges” option when renaming, copying, or moving a database, table, column, or procedure?
      • 6.40 I see “Bind parameters” checkbox in the “SQL” page. How do I write parameterized SQL queries?
      • 6.41 I get import errors while importing the dumps exported from older MySQL versions (pre-5.7.6) into newer MySQL versions (5.7.7+), but they work fine when imported back on same older versions ?
    • BetterMyAdmin project
      • 7.1 I have found a bug. How do I inform developers?
      • 7.2 I want to translate the messages to a new language or upgrade an existing language, where do I start?
      • 7.3 I would like to help out with the development of BetterMyAdmin. How should I proceed?
    • Security
      • 8.1 Where can I get information about the security alerts issued for BetterMyAdmin?
      • 8.2 How can I protect BetterMyAdmin against brute force attacks?
      • 8.3 Why are there path disclosures when directly loading certain files?
      • 8.4 CSV files exported from BetterMyAdmin could allow a formula injection attack.
    • Synchronization
      • 9.1 (withdrawn).
      • 9.2 (withdrawn).
  • Developers Information
  • Security policy
    • Typical vulnerabilities
      • Cross-site scripting (XSS)
      • Cross-site request forgery (CSRF)
      • SQL injection
      • Brute force attack
    • Reporting security issues
  • Copyright
    • Third party licenses
  • Credits
    • Credits, in chronological order
    • Translators
    • Documentation translators
    • Original Credits of Version 2.1.0
  • Glossary
BetterMyAdmin
  • Copyright
  • Edit on GitHub

Copyright

BetterMyAdmin is a port of phpMyAdmin to TypeScript and Node.js, derived from phpMyAdmin and distributed, like phpMyAdmin, under the GNU General Public License version 2 or (at your option) any later version (GPL-2.0-or-later). This documentation is adapted from phpMyAdmin’s documentation, which is distributed under the same license.

Copyright (C) 2026 The BetterMyAdmin contributors

BetterMyAdmin is an independent project and is not affiliated with or endorsed by the phpMyAdmin project; “phpMyAdmin” is used here only to describe what this software is derived from and compatible with.

phpMyAdmin’s copyright, which covers the code and documentation BetterMyAdmin derives from:

Copyright (C) 1998-2000 Tobias Ratschiller <tobias_at_ratschiller.com>
Copyright (C) 2001-2018 Marc Delisle <marc_at_infomarc.info>
    Olivier Müller <om_at_omnis.ch>
    Robin Johnson <robbat2_at_users.sourceforge.net>
    Alexander M. Turek <me_at_derrabus.de>
    Michal Čihař <michal_at_cihar.com>
    Garvin Hicking <me_at_supergarv.de>
    Michael Keck <mkkeck_at_users.sourceforge.net>
    Sebastian Mendel <cybot_tm_at_users.sourceforge.net>
    [check credits for more details]

This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License version 2, as published by the Free Software Foundation.

This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.

You should have received a copy of the GNU General Public License along with this program. If not, see <https://www.gnu.org/licenses/>.

Third party licenses

BetterMyAdmin includes several third-party libraries (npm packages) which come under their respective licenses; see their licensing information in the node_modules/ directory of a checkout, or in the package metadata of each dependency listed in the repository’s pnpm-lock.yaml. It also includes phpMyAdmin’s translations, under phpMyAdmin’s license.

Previous Next

© Copyright 2012 - 2026, The phpMyAdmin devel team; 2026, the BetterMyAdmin contributors.

Built with Sphinx using a theme provided by Read the Docs.