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 […]
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 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 […]
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 […]
How to speed up a VirtualBox virtual machine
Posted by Alex On August 15, 2023
What to do to speed up VirtualBox On the same computer, a VirtualBox virtual machine can have different performance and responsiveness. The following are a few ways to speed up the virtual machine. 1. Enable the I/O Caching option Enabling “Use Host I/O Cache” for virtual machine disks can dramatically improve virtual machine performance. See […]
Terrible VirtualBox disk performance (SOLVED)
Posted by Alex On August 15, 2023
The performance of a virtual machine depends on the resources allocated to it (the number of CPU cores, the amount of RAM) and on the number of running programs in the virtual machine and their resource requirements. This is logical and works about as intuitively expected. But with heavy use of the disk in a […]
How to move VirtualBox virtual machines to another drive or computer
Posted by Alex On August 15, 2023
Migration of VirtualBox virtual machines VirtualBox virtual machines can be transferred in whole or in part (for example, only virtual disks) within the same computer (for example, to a faster SSD), as well as between computers. This note will tell you how to properly migrate VirtualBox virtual machines without the need for a long setup […]
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 […]
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 […]
Finding multiline matches with PHP regular expressions
Posted by Alex On August 10, 2023
Multiline in PHP regular expressions By default, regular expressions in PHP look for matches within the same string. And in this case, the symbol “.” (dot) which is usually described as “anything” actually means “anything but a new line”. This default behavior can be overridden with a pattern modifier in case you need to find […]