MariaDB - Suay.Site

ERROR 1114 (HY000) at line 19894: The table ‘en’ is full (SOLVED)

Posted by Alex On September 24, 2023

Why does the “ERROR 1114 (HY000)” occur When adding information to a database, for example, when using an “INSERT” statement, or when importing tables or databases into MySQL (MariaDB), error number 1114 may occur: ERROR 1114 (HY000) at line 19894: The table 'en' is full After the error there is an explanation: the specified table is completely occupied. The problem...

PHP Fatal error: Uncaught mysqli_sql_exception: No database selected (SOLVED)

Posted by Alex On September 6, 2023

Let's look at a small PHP code that tries to connect to a MySQL or MariaDB DBMS and execute a query with a “SELECT” statement: <?php $db_user = "root"; $db_password = ""; $mysqli = new mysqli("localhost", $db_user, $db_password); if ($mysqli->connect_errno) { printf("Somehow we failed: %s\n", $mysqli->connect_error); exit(); } $query = "SELECT * FROM TestTABLE;"; $result = $mysqli->query($query); while ($row =...

“ERROR 1046 (3D000): No database selected” in MySQL and MariaDB (SOLVED)

Posted by Alex On September 3, 2023

How to fix “ERROR 1046 (3D000): No database selected” The error “ERROR 1046 (3D000): No database selected” occurs most often due to haste – of course, before performing actions with tables and the information stored in them, you must specify (that is, select to use) database. This simple mistake is a good reason to tell you about at least 5...

How to change the command line prompt for MySQL (MariaDB)

Posted by Alex On September 2, 2023

The MySQL (MariaDB) client, when connected to a DBMS server, displays the database selected to use and the name of the DBMS (such as MariaDB or MySQL) at the default command prompt. Perhaps you want to add to this information the username, the hostname on which the MySQL (MariaDB) server is running, the port number, the current date and time,...

How to determine the location and name of the MySQL (MariaDB) configuration file. How to find the group name for MySQL and MariaDB configuration files

Posted by Alex On September 2, 2023

MySQL and MariaDB config files Some useful settings that improve productivity or solve problems that have arisen should be saved in configuration files. But you may encounter a situation where some online guide recommends saving the settings to a file located in a certain directory, but in your Linux this file or even the entire directory is missing. The confusion...

How to quickly clear a command line in the MySQL (MariaDB) client

Posted by Alex On September 1, 2023

How to quickly clear the MySQL (MariaDB) command line prompt When actively working with the DBMS at the command line prompt, from time to time anyone makes mistakes. For example, an invalid query expression was entered: in the wrong terminal window, or before selecting a database, or some other error. In the Linux terminal, this problem is solved in an...

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

What is the difference between utf8_general_ci, utf8_unicode_ci, utf8mb4_general_ci, utf8mb4_unicode_ci collations. Which collation, character set and encoding to choose for MySQL database

Posted by Alex On August 25, 2023

As of MySQL 5.5.3 you must use utf8mb4 and not utf8. Both of these groups refer to UTF-8 encoding, but the older utf8 has MySQL-specific restrictions that prevent characters above 0xFFFD from being used. Thus, neither utf8_general_ci nor utf8_unicode_ci need to be used anymore. As for the new encoding versions utf8mb4_general_ci and utf8mb4_unicode_ci. That is unicode preferred over general. The...

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