Category: MySQL 8.0
-
Post Views: 18 Seamlessly migrate from Windows WSL2 to Ubuntu bare metal, build Go development environments based on existing MySQL/Redis containers, and access custom networks. 📌 Preface I have been learning in Windows 10 + WSL2 before go-gin-learning Project, now to brand new Ubuntu 26.04 system. I hope to continue to use Docker to isolate the sending environment, and at…
-
Post Views: 20 This article is a development environment for the ‘From Windows to Ubuntu: Complete Guide to Migration and Configuration’ series.It is suitable for developers who have completed the Ubuntu system installation and hope to build an efficient, isolated and multi-version database environment. Why use Docker to manage databases? Under Windows, I am used to running a separate database…
-
Post Views: 40 1. There are 10,000 parameters in the IN condition (the upper limit of the product needs to be 10,000), resulting in a long query time, and the interface response timeout. as shown in Figure 1 2. When the number of parameters of PLAT_ORDER_ID is reduced from 10000 to 5, the interface response does not time out, and…
-
Post Views: 19 1. View the response data in the interface, and the reasoning is that the checkin_location_coordinates in the response field is the point type of mysql. as shown in Figure 1 2. Decide to adjust the query sql, use mysql spatial functions (such as st_x and st_y) to extract the latitude and longitude, and avoid direct manipulation of…
-
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: 85 1. In the performance environment, the list interface response timeout. as shown in Figure 1 2. Determine the sql of the interface to execute, connect the mysql of the performance environment in the local environment, and then view the generated sql in Laravel Telescope, and find a select count(*) as aggregate FROM is much longer than other…
-
Post Views: 17 1. In Spatie\QueryBuilder , the request parameter contains “,” error: sqlstate[HY093]: Invalid parameter number: number of bound variables not match number of tokens (SQL: select count(*) as aggregate from `table` where `table`.`Shipping_type` = 2 and `Shipping_at_gmt` >= 2024-05-21 08:54:14 and `Shipping_at_gmt` <= 2024-08-21 08:54:14 and `table`.`Shipping_error_message in (AAA)). as shown in Figure 1 2. When the request…
-
Post Views: 52 1. The configuration for mysol server 8.0.39 has failed.. as shown in Figure 1 2. Check the logs, as shown below 3. Edit C:\ProgramData\MySQL\MySQL Server 8.0\My.ini. 4. Right-click mysql-installer-community-8.0.36.0.msi to install, mysol server, and click Reconfigure. as shown in Figure 2 5. Still reporting an error, but already reporting another error. Successfully started service MySQL80. Configured configuration…
-
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…