Tag: 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: 22 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: 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: 14 1. Since too large SQL files cannot be imported in phpmyadmin, I decided to import them in mysql query browser, as shown in Figure 1 2. The SQL file size is: 186MB, as shown in Figure 2 3. Click the Execute button to execute the script, as shown in Figure 3 4. During the execution process, the…
-
Post Views: 13 1. Back up the entire site file, use the FTP client, and copy the file from the server to the local machine, as shown in Figure 1 2. Log in to phpmyadmin and back up the database, as shown in Figure 2 3. Search in the background: Backup, and then select BackupwordPress to install, as shown in…
-
Post Views: 11 1. The final expectation result is: modify the avatar in the player table, its value is: /storage/web/app/player_avatar/gzhou/579365.jpg, where gzhou is the value of the current record field TEAM_CODE, 579365 is the value of the current record field code, as shown in Figure 1 2. First modify the avatar of a record, and its SQL statement is successfully…