Tag: Navicat for MySQL
-
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: 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…
-
Post Views: 21 1. Reference URL:https://www.shuijingwanwq.com/2021/12/29/5622/, Laravel 8.x is deployed to Heroku, based on PostgreSQL implementation. Therefore, some steps can be omitted. 2. In the local development environment, the Laravel native environment has been deployed. Open URL:http://larabbs.local/, the response 200. as shown in Figure 1 3. Verify your installation, to verify your CLI installation, use the heroku –version command. Current…
-
Post Views: 16 1. Interface response to SQL error: SQLSTATE[42000]: Syntax error or access Violation: 1064 you have an error in your SQL syntax; check the manual that Corresponds to your MySQL Server version for the right syntax to use near6. as shown in Figure 1 2. Remove the request parameter: filter[and][0][or][1][keyword][fis]=, the response is 200, and no error is…
-
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…