XAMPP - UPGRADE MYSQL to version 8.0

Описание

STEP 1: Download MySQL Community Server 8.x (64-Bit) from: https://dev.mysql.com/downloads/mysql/

STEP 2: Create mysql directory in Xampp

STEP 3: Create a new file "g:\xampp\mysql\bin\my.ini"

[mysqld]
# Set basedir to your installation path
basedir=g:/xampp/mysql

# Set datadir to the location of your data directory
datadir=g:/xampp/mysql/data

# Default: 128 MB
# New: 1024 MB
innodb_buffer_pool_size = 1024M

# Default since MySQL 8: caching_sha2_password
default_authentication_plugin=mysql_native_password

[client]
ssl-mode=DISABLED

STEP 4:
cd g:\xampp\mysql\bin

STEP 5:
mysqld.exe --default-authentication-plugin=mysql_native_password --initialize-insecure --basedir=g:\xampp\mysql --datadir=g:\xampp\mysql\data


=======================
Learn to code for free:
https://imranOnline.net
https://github.com/imranonline-net
https://www.facebook.com/ImranOnline.net