---- Changes since 1.140 ----
The not null flag and a default value can be specified for fields in new tables.
The form for creating an initial table in a new database is now the same as the one for adding a table to an existing database.
---- Changes since 1.150 ----
Added a button on the module's main page for backing up all databases, either immediately or on schedule.
A Webmin user who has been set up to login to MySQL as a different user will now be prompted to login if his password set in the Webmin Users module incorrect.
Added an access control restriction to limit the number of databases a Webmin user can own.
Fields can now be specified as unsigned when creating a table.
---- Changes since 1.160 ----
Added the ability to select which tables to include when making a backup.
When viewing table data, the Advanced Search button can be used to perform and/or searches on multiple fields.
---- Changes since 1.200 ----
Added a Module Config option to specify the encoding for database content.
---- Changes since 1.210 ----
Added checkboxes and a button to the Edit Database page for dropping multiple tables at once.
Added checkboxes and a button to the module index for dropping multiple databases at once.
---- Changes since 1.220 ----
Added checkboxes and a button to the lists of user, database, host, table and field privileges for deleted several at once.
When there are too many databases or tables to reasonably list, a search form is show instead for finding matching databases or tables by name.
Added a button on the Edit Table page for exporting in CSV format, either to a file or for display in the browser.
---- Changes since 1.230 ----
Added an option on the CSV export page for selecting which columns to include.
---- Changes since 1.240 ----
When editing data in a table, enum fields are shown as menus.
The full MySQL error message is now shown when Webmin cannot login to the database.
When backing up all databases at once, an option is now available to run commands before/after all of them, rather than before/after each.
---- Changes since 1.250 ----
Added a new page for editing MySQL server settings in the [mysqld] section of the my.cnf file.
---- Changes since 1.260 ----
Added support for viewing, creating and managing indexes in databases.
If the before-backup command fails, the entire backup is halted.
Added an option on the backup page for entering a different character set.
---- Changes since 1.270 ----
Added a button for deleting multiple fields from a table at once.
Cleaned up table data editing code.
Added support for creating, listing and editing views in MySQL 5.
Added Module Config option to limit the displayed size of large text field data.
---- Changes since 1.290 ----
Added options to the MySQL Server Configuration page for setting the address to listen on, and the maximum number of connections.
Created a page showing database connections, with checkboxes and a button for killing them.
Create a page listing MySQL server variables, with the ability to edit system variables.
Column headings in the Table Data page can be clicked to sort the data by that column.
---- Changes since 1.300 ----
Added options on the backup form for selecting a compatibility format for exporting to other database types.
Added an option to compress backups with gzip or bzip2.
When executing an SQL file (such as a backup), it will be automatically un-compressed if needed.
Re-factored backup code into a separate function, which can be called from other modules.
Added an option to the database creation form for selecting the character set, when using MySQL 4.1 or newer.
Added access control options to prevent the viewing and management of views and indexes.
---- Changes since 1.320 ----
When there are too many databases or tables to display, a menu for editing a specific one is displayed in addition to the search field.
---- Changes since 1.330 ----
Fixed a bug that prevents compression from being done when backing up all databases.
---- Changes since 1.340 ----
Improved detection of support for views, which avoids errors with information_schema.views.
---- Changes since 1.370 ----
Added an option on the backup form to create the destination directory if missing.
Re-wrote the backup form to use the new Webmin UI library.
The MySQL password is no longer passed on the command line.
---- Changes since 1.380 ----
Fixed a bug that prevented 'Jump to row' from working properly.
---- Changes since 1.390 ----
The character set to use for MySQL output can now be set on the Module Config page.
When testing if a user can login, no specific database is used in case the user does not have access to the 'mysql' database.
When there are too many databases, huge lists of all databases and tables are not shown on the Table Permissions and Field Permissions pages. Instead, text boxes for entering names are shown.
System variables can now be searched using a new field, making it easier to find the one you want from the large list on some systems.
Re-designed the Execute SQL page to use tabs.
Converted all user interface code to use the new Webmin UI library, for a more consistent look.
---- Changes since 1.400 ----
Added a Module Config option to show databases and tables using just their names, which is much faster under MySQL 5 as it avoids the need to count their tables, fields and rows.
---- Changes since 1.410 ----
Display a more friendly error if a scheduled backup cannot be performed because MySQL is down.
The root password can be more easily change by the new 'Change Administration Password' page.
---- Changes since 1.420 ----
Display the number of tables and records created when executing SQL for a restore.
---- Changes since 1.430 ----
Improved the input for setting the default value for new fields, and added support for CURRENT_TIMESTAMP.
---- Changes since 1.440 ----
The correct character set is ready from my.cnf when connecting using DBI mode, thanks to jianxia.
The password is passed to all MySQL commands using the MYSQL_PWD environment variables on systems running MySQL 4.1 and later, version 5.1 in older Webmin releases.
---- Changes since 1.450 ----
Use DBI for listing databases and tables, to reduce dependency on the un-reliable MYSQL_PWD environment variable.
Fixed the input for setting the default value for fields.
---- Changes since 1.470 ----
Added code to detect a password in /root/.my.cnf which overrides the MYSQL_PWD variable, and thus causes login failures.
MySQL stored procedures are now included in backups, where supported.
---- Changes since 1.480 ----
Restores and imports from local files are now run as the Unix user configured for backups, rather than root.
---- Changes since 1.490 ----
The information_schema database is no longer included when backing up all databases, as it really just contains metadata.
---- Changes since 1.500 ----
Added a collation order field to the database creation form.
Added an option to the backup form to do backup in a single transaction, for InnoDB tables.
The default MySQL table type can now be set on the MySQL Server Configuration page.
---- Changes since 1.510 ----
Added greater than / less than selectors to the table data search form.
The SSL / X509 authentication type for a user can be set on the Edit User page.
---- Changes since 1.560 ----
Added confirmation before deleting multiple user, host, database, table and column permissions.
---- Changes since 1.570 ----
Added fields to the Edit User page for setting the maximum concurrent logins and operations per hour for users.
Scheduled MySQL backups can now have their success or failure sent via email, via new options on the Backup Database page.
When executing SQL or restoring a backup file, the character set can now be selected for the imported data.
---- Changes since 1.700 ----
When a database is deleted, any cron job for backing it up is also removed.
---- Changes since 1.770 ----
Added support for the new password columns in the user table as seen in MySQL 5.7, and massively cleaned up all the code for user, host and DB permissions management.
---- Changes since 1.810 ----
Single database backups can now be downloaded in the browser.
