software errors / problem solutions - Page 2

“ERROR 1366 (22007): Incorrect string value” in MySQL/MariaDB (SOLVED)

Posted by Alex On August 26, 2023

How to insert emoji into MySQL/MariaDB database On the one hand, inserting emoji into a MySQL / MariaDB database table does not require any special preparatory steps – just insert one or more emoji characters, which may contain other text. For example: INSERT INTO TestTABLE (`test_column`) VALUES ("🎫⏭️✈️ and hi 🌅"); But when executing the previous request, you may encounter...

PHP not displaying emoji from MySQL/MariaDB database (SOLVED)

Posted by Alex On August 25, 2023

When retrieving rows from a MySQL (MariaDB) database, you may encounter a situation where all the text is displayed correctly, but question marks are displayed instead of emoji. The most likely problem is an incorrectly used encoding when executing queries against the MySQL (MariaDB) DBMS. There are two ways to fix this situation. 1. Select utf8mb4_unicode_ci encoding when creating database...

Error “ERROR 1142 (42000)”: command denied to user for table in MySQL / MariaDB (SOLVED)

Posted by Alex On August 25, 2023

Error number 1142 (42000) occurs when the user does not have enough privileges on the table or database to execute the query. An example of an error when executing a query with a SELECT statement: SELECT * FROM TestDB.TestTABLE; The request failed with an error: ERROR 1142 (42000): SELECT command denied to user 'mial'@'localhost' for table `TestDB`.`TestTABLE` An example of...

Error “ERROR 1143 (42000)”: command denied to user for column in table in MySQL (MariaDB) (SOLVED)

Posted by Alex On August 24, 2023

How to fix “ERROR 1143 (42000)” in MySQL (MariaDB) Error number 1143 (42000) occurs when a user has privileges on some columns of a table, but he tries to exercise his privileges on those columns for which he does not have permissions. If the user tries to perform actions for which he does not have privileges on any column in...

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

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

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

Error “Multiple connections to a server or shared resource by the same user, using more than one user name, are not allowed” (SOLVED)

Posted by Alex On July 24, 2023

When using SMB and connecting to a Windows network share (share), an error may occur: Unable to access \\XXX. You may not have permission to use this network share. Contact the administrator of this server to obtain the appropriate permissions. Multiple connections to a server or shared resource by the same user, using more than one user name, are not...