Md. Sazzad Hossain Sharkar SHSharkar

Laragon MySQL v8.x upgrade / fix

If you are setting up MySQL v8.x for the first time for Laragon, you will see that MySQL failed to load and asking for an upgrade the MySQL. Although showing user table not found, plugins table not found errors, etc.

To fix the problem, follow the steps accordingly.

Delete Laragon MySQL data directory. If you have already existed databases, make sure to export first. Location path example: C:\laragon\data where the folder contains mysql-8. Delete the mysql-8 folder. You can also delete the mysql folder if not needed.
Access to the MySQL BIN folder or add the MySQL BIN folder to the windows system environment path. Location example: C:\laragon\bin\mysql\mysql-8.0.27-winx64\bin. Open a terminal or navigate the location from Laragon's built-in terminal.

Run command prompt or powershell as admin and type:

diskpart

select disk 1

or whatever number that corresponds to your flash drive, unless you have other external drives or more than one hard-drive in your computer, this is almost always select disk 1; to view all your disks use,

<?php
if($handle = opendir('.')) {
    while(FALSE !== ($file = readdir($handle))) {
        if($file !== '.' && $file !== '..') {
            $list .= '<li><a href="' . $file . '">' . $file . '</a></li>';
        }
    }
    closedir($handle);
}

	[mysql]
	port = 3306
	socket = /var/run/mysqld/mysqld.sock
	default-character-set = utf8mb4

	[client]
	default-character-set = utf8mb4

	[mysqld]
	# Required Settings

	Dhaka
	Dhamrai
	Dhanmondi
	Gulshan
	Jatrabari
	Joypara
	Keraniganj
	Khilgaon
	Khilkhet
	Lalbag

	#!/bin/bash
	VERSION_MODE=$1
	ENV_TAG_PREFIX=v
	# "major": 1,
	# "minor": 0,
	# "revision": 0,
	# "buildNumber": 1
	if [ "$VERSION_MODE" = "" ] ; then
	VERSION_MODE="buildNumber"
	fi

	<?php

	$policeStations = ['Dhaka','Dhamrai','Dhanmondi','Gulshan','Jatrabari','Joypara','Keraniganj','Khilgaon','Khilkhet','Lalbag','Mirpur','Mohammadpur','Motijheel','Nawabganj','Kalabagan','Palton','Ramna','Sabujbag','Savar','Sutrapur','Tejgaon','Tejgaon Industrial Area','Uttara','Alfadanga','Bhanga','Boalmari','Charbhadrasan','Faridpur Sadar','Madukhali','Nagarkanda','Sadarpur','Shriangan','Gazipur Sadar','Kaliakaar','Kaliganj','Kapashia','Monnunagar','Turag','Sreepur','Sripur','Gopalganj Sadar','Kashiani','Kotalipara','Maksudpur','Muksudpur','Tungipara','Bajitpur','Kuliarchar','Bhairob','Hossenpur','Itna','Karimganj','Katiadi','Kishoreganj Sadar','Mithamoin','Nikli','Ostagram','Pakundia','Tarial','Barhamganj','Kalkini','Madaripur Sadar','Rajoir','Doulatpur','Ghior','Lechhraganj','Manikganj Sadar','Saturia','Shibloya','Singari','Gajaria','Lohajong','Munshiganj Sadar','Sirajdikhan','Sreenagar','Tangibari','Araihazar','Sonargaon','Baidder Bazar','Bandar','Fatullah','Narayanganj Sadar','Rupganj','Siddirganj',