©SQL :: Manager
HomeProgram InformationTechnical detailsFree downloadDonate for a cup of coffee
myway SQL Manager for MySQL and MariaDB, Download on Uptodown
MySQL, MariaDB Edit and manage database

Management and editing of MySQL and MariaDB databases. Information, statistics and tools

Permission role The database configuration can be reached by selecting the database in the main menu
MySQL - Edit permission role

Module for managing and editing databases:

Information and statistics.

Permission editing.

Foreign key management and processing.

Data backup as SQL scripts and CSV files

Tools for converting and copying databases.

Deleting the database from the SQL server.

Execute SQL statements on databases.

Search databases for database objects (tables, views, procedures, functions, triggers and events).

Database information Displays information about the database.
Table statistics Displays information and statistics about tables in the database.
User access rights Management of access rights of program users for this database.
Database user rights Management of database user rights of this database.
Foreign keys Management of the foreign keys available for this database.
Database backup Module for backing up the database.
CSV backup CSV backup of the database.
Database tools Module for database operations (change sorting, copy databse, delete rights).
Delete database Deleting the database from the connected server.
SQL statements Opens the window for executing SQL statements on this database.
Database search Search in definition names of database objects (tables, views, procedures, functions, triggers, events),
with %... inside the definition names.
Database fulltext search Full-text search in definitions (table fields, views and program codes).
MySQL - Database menu

Labeled menu by double-clicking title bar.

MySQL and MariaDB databases are containers whitch owns collections of tables, views, stored procedures, user-defined functions, and other database items. A SQL server can manage multiple databases, each with its own elements.

Databases can be created using the CREATE DATABASE statement, specifying a unique name for the database. DROP DATABASE deletes a database, ALTER DATABASE changes database properties, and SHOW DATABASES lists all available databases. Tables within a database are organized in a schema that helps organize related tables and objects within a database. Multiple users with different permissions can be created and assigned to specific databases. This enables controlled access to data and ensures security. It is important to back up SQL databases regularly to protect against data loss.

MySQL and MariaDB allow operations affecting multiple databases within the same server, for example querying data using SELECT b> from different databases in a single query or creating views that reference tables from different databases.
For more information on MySQL databases, see: mysql.com and mariadb.com
Updated: 2023-09-15ImprintContactTerms & conditionsPrivacy & CookiesUpdatesSitemapFacebookLinkedinTwitterStatistics©2020-2024 Heino Cunze-Fischer