• Basic operation of invisible column in MySQL 8.0


    01 create invisible column To create an invisible column: CREATE TABLE `t2` (   `id` int NOT NULL AUTO_INCREMENT,   `name` varchar(20) DEFAULT NULL,   `age` int DEFAULT NULL INVISIBLE,   PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci As you can see, a table t2 is created in our SQL. The fields of T2 include ID, name and age. The age field sets invisible attributes. Of course, we can use the syntax of alter table to create […]

  • CentOS 8.0.1905 installing zabbix4.4 (verified)


    ZABBIX server environment platform Version: ZABBIX version 4.4System: CentOS   8.0.1905  Database: mysql-server-8.0.17 Install centos8 Yum source #cd /etc/yum.repos.d/ #rm -f CentO*.repo #curl -o CentOS-Base.repo https://raw.githubusercontent.com/hackyoMa/docker-centos/8/CentOS-Base.repo #yum makecache Install ZABBIX Yum source # rpm -Uvh https://repo.zabbix.com/zabbix/4.4/rhel/8/x86_64/zabbix-release-4.4-1.el8.noarch.rpm # dnf clean all Install ZABBIX server, web front end and agent # dnf -y install zabbix-server-mysql zabbix-web-mysql zabbix-apache-conf […]

  • Atomicity and implementation principle of MySQL 8.0 DDL


    1. Overview of DDL atomicity Before 8.0, there was no unified data dictionary DD. the server layer and engine layer had a set of metadata respectively. The metadata of sever layer included (. Frm,. Opt,. Par,. TRG, etc.), which was used to store table definition, partition table definition, trigger definition and other information; InnoDB layer […]

  • MySQL 8.0 error the server requested authentication method unknown to the client solution


    After MySQL has installed the latest version 8.0.11, the authorized user will be prompted to connect to the database The server requested authentication method unknown to the client After consulting some relevant information, it is found that the new version of MySQL account password unlocking mechanism is inconsistent terms of settlement: Delete the created user […]

  • Win10 64 bit MySQL 8.0 download and installation tutorial diagram


    How to download and install MySQL from the official website to the client login? This article tells you clearly. Step 1: download from the official website of MySQL. From[ https://dev.mysql.com/downloads/mysql/ ] https://dev.mysql.com/downloads/mysql/ )Find the required win10 64 bit mysql Click download to jump to the download page, as shown below. In the past, it was […]

  • How to keep Android 8.0 and above system applications alive


    Since there is a mechanism to guarantee the success of the upload process in Android, it is not a guarantee for the upload process to be implemented in batches. For Android, there are several ways to keep alive: Open the foreground service (good effect, recommended) Play a silent audio loop in service (good effect, but […]

  • Perfect solution to 2058 error in connection with MySQL 8.0


    introduction Use sqllog to connect mysql 8.0 (community version: mysql-installer-community- MSI), and error 2058 (plug caching) occurs_ sha2_ password could not be loaded:xxxx )The reason of the error is found by searching the data, and the scheme of this problem is put forward in this paper. reason The error prompt is shown in the following […]

  • Detailed explanation of range type example in C × 8.0


    Preface C ා language was released in 2000. Up to now, 7 versions have been officially released. Each version contains many exciting new features and functional updates. At the same time, the release of each version of C# is highly coupled with the Visual Studio and.NET runtime version in the same period, which is also […]

  • MySQL 8.0.15 installation and configuration method graph and text tutorial (windows10 x64)


    The content of recent study involves the knowledge of MySQL, so it is very necessary to install a mysql. The installation process is quite smooth by referring to other people’s tutorials. Some problems encountered in the installation process have been checked and solved. Here, the whole installation process is sorted out to give you a […]

  • Approaches to Correctly Modify ROOT Password in Versions above MySql8.0


    Deployment environment: Installation version red hat center 7.0 MYSQL version Failure occurred after successful deployment: 1. After starting MYSQL service normally, you can’t enter it by tapping the root account and password in Linux. 2. After adding skip-grant-table from the / etc/my.cnf configuration file, it can login normally, but it can’t create users and […]