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
  • Search


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

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