Author: Alex

How to allow a MySQL (MariaDB) user to create new users and grant privileges to manage databases and their contents to other users

Posted by Alex On August 22, 2023

By default, the right (privilege) to create new users, as well as grant them rights to databases, is granted only to root. The root user can do all kinds of operations on databases and users. If you want to grant some administrative privileges to another user, then you can do so. How to create a MySQL (MariaDB) administrative user You...

Why is MySQL (MariaDB) asking for a password even when it is specified with the “-p” option (SOLVED)

Posted by Alex On August 21, 2023

If you are trying to connect to the MySQL (MariaDB) server on the command line, then you may have encountered the problem that the MySQL (MariaDB) client does not see the password. For example, when connecting to MariaDB using the command (where “USER” is the actual username and “PASSWORD” is the actual password): mariadb -u USER -p PASSWORD Instead of...

Why “mysql -h” doesn’t show help. Error “option ‘-h’ requires an argument” (SOLVED)

Posted by Alex On August 21, 2023

Perhaps the most popular command line option, regardless of the utility used, is the “-h” option. For most command-line programs, the “-h” option displays help on how to use the program. But if you try to get help for MySQL like this: mysql -h Then instead of the expected list of options and their values, you will get an error:...

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...

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)”...

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 virtual machine, its performance drops...
Loading...
X