Tag: Navicat
-
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: 17 1. Reference:In MySQL 8.0, when querying the total number of table records, the analysis optimization of the timeout. The execution time in Navicat is: 3.075 seconds. as shown in Figure 1 2. The execution time in Laravel 9 is: 60317.74ms. It is equivalent to 60 seconds. as shown in Figure 2 3. Verify another count(*) SQL, the…
-
Post Views: 14 1. The external network address of the Alibaba Cloud RDS MySQL instance has been applied to connect. as shown in Figure 1 2. Failed to connect in Navicat for MySQL, error: 2003 – CANT connect to mysql server onRM-BP(10060 “Unknown Error”). as shown in Figure 2 3. To access RDS through the external network, you need to…
-
Post Views: 60 1. In Navicat for MySQL, when editing the database, the database name cannot be edited, as shown in Figure 1 2. Rename the database in phpmyadmin, it can be seen that phpmyadmin can support the operation of direct rename, as shown in Figure 2 3. Prepare to rename g-s-yii2-app-advanced-test in Navicat for mysql, and create a new…
-
Post Views: 43 1. When running the SQL file, an error is reported:[ERR]2013 – Lost Connection to MySQL Server During During Query, as shown in Figure 1 [错误]2013 – Loss of connection to mysql server during query 2. Open the directory C:\ProgramData\MySQL\MySQL Server 5.7, edit the my.ini file, as shown in Figure 2 3. Change max_allowed_packet=4m to max_allowed_packet=256m, as shown…