Category: Database Management Tools
-
Post Views: 17 1. In phpMyAdmin, it prompts: An error was detected, the error report has been generated but failed to send. If you are having problems, please submit vulnerability reports manually. You need to refresh the current page. as shown in Figure 1 2. Because it is downloaded phpmyadmin-5.2.2-all-languages.zip. After decompression, run directly, and decide to refer to: installing…
-
Post Views: 21 1. When logging in in phpMyAdmin, prompt: mysqli::real_connect(): The server requested authentication method unknown to the client[caching_sha2_password]. as shown in Figure 1 2. Starting with MySQL 8.0, the default authentication method is changed from MYSQL_Native_password to caching_sha2_password. While this new approach is more secure, older versions of PHP (before 7.4) and some MySQL client libraries do not…
-
Post Views: 59 1. Failed to activate Navicat. The reason may be due to the upper limit of the number of activations has been reached. Please check if you have deactivated the license key before uninstalling or reinstalling Navicat. As shown in Figure 1 2. Since the system that previously installed Navicat has been reinstalled, it is impossible to deactivate…
-
Post Views: 20 1. Modify the PHP implementation of the table field type 2. However, in Navicat for MySQL, check that there is no change in DDL. Even after closing the connection and closing the database, it is opened again, and it is found that there is still no change. Finally had to close Navicat for MySQL and open it…
-
Post Views: 52 1. When clearing the table in MySQL 5.7, there are more than 3 million records in the table, and when there are more than 2 million records left, prompt: 1206 – The total number of locks Exceeds the lock tablesize. as shown in Figure 1 2. Reference: The total number of locks exceds. 3. This problem can…
-
Post Views: 16 1. In Navicat for MySQL, when the table is copied from one database to another, an error is reported:[ERR]1292 – Incorrect DateTime Value:0000-00-00 00:00:00for columnCREATED_AT_GMTat row 1. as shown in Figure 1 2. Execute: Select version(), it is found that the version of the two database software is inconsistent. They are: 5.7.19-log and 8.0.23-0ubuntu0.20.04.1. as shown in…
-
Post Views: 18 1. There are now 2 projects, and their domain names are: Object.local, Object-master.local. The redis configuration of its .env file is as follows 2. However, the performance at this stage is that both projects still use Redis 1. The problem caused by sharing a Redis 1 database is that when Object.local is opened, and then Object-master.local is…
-
Post Views: 14 1. The data in the table is as follows 2. When executing a where like query, use likelayouts\\%Attempts to query the data rows starting with Layouts\. The result is empty. as shown in Figure 1 3. When executing a where like query, use likelayouts\\\%Attempts to query the data rows starting with Layouts\. Only the corresponding results are…
-
Post Views: 17 1. In Navicat for MySQL, import the SQL file, and report an error when executing: 2006 – MySQL Server has gone away. as shown in Figure 1 2. The size of the imported SQL file is about 35MB. as shown in Figure 2 3. The reason is that the default settings of max_allowed_packet are very low. In…