Category: phpMyAdmin
-
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: 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: 19 1. Enter the CentOS server based on Xshell 6, compress and package the website program directory, execute the compression command, and the execution result is shown in Figure 1 2. Connect to the FTP server based on FlashFXP, download the compressed package: shuijingwanwq.com-20191203.zip to the local, as shown in Figure 2 3. Connect to the MySQL server…
-
Post Views: 48 1. Execute the update statement in mysql workbench, the statement is as follows: 2. Error code: 1175, the specific error information is as follows:, as shown in Figure 1 3. Execute the update statement in phpmyadmin, the statement is as follows: the execution is successful, as shown in Figure 2 4. According to the prompts, to disable…
-
Post Views: 15 1. HTML escape characters appear in SyntaxHighlighter 3.x of WordPress 4.9.8, and newline tags are automatically added, etc., as shown in Figure 1 2. The expected format should not appear HTML escape characters, as shown in Figure 2 3. For a long time, there were no HTML escape characters. I am not sure whether it was caused…
-
Post Views: 15 1. Reference URL:https://docs.phpmyadmin.net/zh_CN/latest/setup.html#installing-using-composer 2. Install and run the command based on composer, as shown in Figure 1 3. Enter the phpmyadmin-localhost directory, update phpmyadmin to the latest version, and run the command, as shown in Figure 2 4. Use the installer to generate the configuration file: config.inc.php, open the browser and use the /setup suffix to access,…
-
Post Views: 53 1. Use updateAll() to update the value of prev_status to the value of status, and update the value of status to 4, the table structure is shown in Figure 1 2. Based on the query builder, the code is as follows 3. However, it does not meet the expectations. The values of prev_status are updated with 0,…