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
User Guide
Edit on GitHub
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
Designer
Diagram
Charts
Chart implementation
Examples
Server status: dashboard and slow queries
Dashboard
Slow queries
Import and export
Import
Export
Custom Themes
Configuration
Creating custom theme
Command palette
Opening it
What it lists
Choosing an entry
For developers
Other sources of information
Printed Book
Tutorials