database management systems / DBMS - Page 3

How to create a new MySQL (MariaDB) user and configure its status and privileges

Posted by Alex On August 19, 2023

This note will show how to create a new MySQL (MariaDB) user, as well as configure its privileges (permissions) at the DBMS level as a whole, at the level of a particular database, and even at the level of individual tables and columns. Why create a new MySQL or MariaDB user Using root to perform Data Management Language (DML) operations...

How to allow a user to access only certain columns in MySQL (MariaDB)

Posted by Alex On August 18, 2023

Table of contents 1. How to set permissions on individual columns in MySQL (MariaDB) 2. How to allow the user to add entries to a column 3. How to allow the user to view entries in a column 4. How to allow the user to update records in a column 5. How to allow the user to create a foreign...

How to allow a user to access only certain tables in MySQL (MariaDB)

Posted by Alex On August 18, 2023

Table of contents 1. How to set permissions on individual tables in MySQL (MariaDB) 2. How to allow a user to create a specific table in a database 3. How to allow a user to delete a specific table in a database 4. How to allow a user to delete records in a table 5. How to allow a user...

How to allow a user to access only certain databases in MySQL (MariaDB)

Posted by Alex On August 17, 2023

Table of contents 1. How to set permissions on individual databases in MySQL (MariaDB) 2. How to allow a user to create tables in a database 3. How to allow a user to delete tables in a database 4. How to allow user to delete records in database tables 5. How to allow user to add records in database tables...

Error when using ‘USE’ statement in MySQL (Mariadb): “ERROR 1044 (42000): Access denied for user” (SOLVED)

Posted by Alex On August 16, 2023

Table of contents 1. The “USE” statement causes the error “ERROR 1044 (42000)” 2. How to fix MySQL (MariaDB) “ERROR 1044 (42000): Access denied for user” with USE statement 3. How to grant a user read access to a database and its contents 3.1 How to give a user read access to a specific database in MySQL (MariaDB) 3.2 How...

ERROR 1044 (42000): Access denied for user 'mial'@'localhost' to database 'TestDB'. Can't create MySQL database (SOLVED)

Posted by Alex On August 14, 2023

Why can't user create MySQL (MariaDB) database When trying to create a database, you may encounter an error: ERROR 1044 (42000): Access denied for user 'mial'@'localhost' to database 'TestDB' The reason for the error is that the specified user (username “mial” in this example) does not have the authority to create databases. The solution to the problem depends on the...

How to list MySQL/MariaDB users and their privileges (using RDBMS client and PHP)

Posted by Alex On August 13, 2023

This note explains which queries can be used to list MySQL and MariaDB users. The article shows how to run these commands in MySQL/MariaDB query string as well as with PHP. How to display a list of users and their privileges using the DBMS client Queries to list MySQL / MariaDB users To list all users in MySQL / MariaDB,...