Showing entries 1 to 3
Displaying posts with tag: data reports (reset)
Meet New Possibilities to Data Analysis with a New Version of Query Builder for MySQL

We are glad to announce the updated version of dbForge Query Builder for MySQL. The tool offers users a great solution to build, generate, and handle MySQL queries from simple to complex in a visual and easy-to-use interface. In this version, the team focused on the Data Reporting and Analysis feature that allows for fast […]

The post Meet New Possibilities to Data Analysis with a New Version of Query Builder for MySQL appeared first on Devart Blog.

How to Get a List of Permissions of MySQL Users

MySQL has advanced database access system. A database user can have access to the whole database, separate tables, or to separate columns of tables. Also there is a restriction for actions a user may perform with records. MySQL server uses several tables in a special database to organize such a complicated database access structure. The access policy is based on the values available in these tables.

The database that MySQL server uses to store internal data about users is called mysql by default. There are tables for storing information about users’ accounts in this database:

  • user contains a list of all users of the MySQL server and their permissions to access the database;
  • db contains a list of databases with a matching list of database users and their privileges for executing operations;
[Read more]
How to Get a List of Permissions of MySQL Users

MySQL has advanced database access system. A database user can have access to the whole database, separate tables, or to separate columns of tables. Also there is a restriction for actions a user may perform with records. MySQL server uses several tables in a special database to organize such a complicated database access structure. The access policy is based on the values available in these tables.

The database that MySQL server uses to store internal data about users is called mysql by default. There are tables for storing information about users’ accounts in this database:

  • user contains a list of all users of the MySQL server and their permissions to access the database;
  • db contains a list of databases with a matching list of database users and their privileges for executing operations;
[Read more]
Showing entries 1 to 3