• How to install MySQL 8.0.18-winx64 in win10


    1. First go to the official website to download the MySQL installation package https://dev.mysql.com/downloads/mysql/ 2. After downloading, unzip it to the file directory where you want to install MSQ (e.g. D: MySQL) 3. The administrator commands to run the command line and enter the bin directory of MySQL installation package 4. Execute the command mysqld […]

  • Installation of mysql-8.0.18-winx64 under Windows


    1. Download the installation package Installation package address: https://dev.mysql.com/downloads/mysql/ 2. Extract to installation directory Extract the zip after downloading. The installation path I use here is: C:\Program Files\mysql-8.0.18–winx64 After decompression, you need to manually create the data folder under the installation path and my.ini file 3. Configuration my.ini file edit my.ini Contents of the document […]

  • MySQL 8.0.18 using clone plugin to rebuild Mgr


    Assuming that a node of three node Mgr is abnormal, you need to add this node to the Mgr cluster again. The specific operation process is as follows: Contributor side execution ( DROP USER ‘donor_clone_user’@’’; CREATE USER ‘donor_clone_user’@’’ IDENTIFIED BY ‘password’; GRANT BACKUP_ADMIN on *.* to ‘donor_clone_user’@’’; INSTALL PLUGIN clone SONAME ‘mysql_clone.so’; Receiver side execution( […]

  • MySQL 8.0.18 Mgr building and switching function


    1、 System installation package yum -y install make gcc-c++ cmake bison-devel ncurses-devel readline-devel libaio-devel perl libaio wget lrzsz vim libnuma* bzip2 xz 2、 Turn off firewall and SELinux sed -i ‘s/SELINUX=enforcing/SELINUX=disabled/’ /etc/selinux/config setenforce 0 /etc/init.d/iptables stop echo “/etc/init.d/iptables stop”>>/etc/rc.local 3、 Modify system limit parameters cat >> /etc/security/limits.conf << EOF # ###custom # * soft nofile […]

  • MySQL installer 8.0.18 visual installation tutorial


    1、 MySQL 8.0.18 installation 1. Baidu search windows for MySQL 2. Select MySQL:: Download MySQL installer 3. Select download second (MySQL installer community MSI) 4. Download without registration 5. Right click to install after downloading 6. Click Run 7. Check OK and click Next 8. Check custom and click next 9. Select MySQL servers […]

  • A tutorial for win10 64 bit to install the latest MySQL 8.0.18 with compressed package


    Win10 64 bit installation latest MySQL 8.0.18 download Download the latest version on the official website: The compressed package version I use here does not use the graphic installer Download address: https://dev.mysql.com/downloads/mysql/ After downloading, unzip it directly to the location you want to use. It’s better to put it on a disk with a solid-state […]