If you have got XAMPP installed in your Windows 11 (it could be a dev. machine) and want to switch to an upgraded version as opposed to the one you’ve got bundled with XAMPP, you can follow the below steps so that your are able to leverage the upgrades.
I required the upgrade when I need to use the
JSON_ARRAYAGG() function which requires MariaDB 10.5.x.
Once you have downloaded and installed it, add it your our
Once done, the following commands are to be run inside an
powershell. Open the shell and change pth to the location of the install, say:
cd "c:\Program Files\MariaDB 10.5\bin"
sc.exe qc MySQL sc.exe delete MySQL sc.exe config MySQL binPath= "c:\Program Files\MariaDB 10.5\bin" .\mysqld --install .\mysqld --initialize net start MySQL (or start from Windows Services)
If you are getting an error on firing
net helpmsg 2185 a workaround could be to copy Database folders from older MySQL folder to the new one to see them in the new install -
C:\Program Files\MariaDB 10.5\data as your old data folder might not be compatible with the new one.
This might open up another problem in form of the following error message:
Unknown/unsupported storage engine: InnoDB and your data not showing inside the databases. Try to just copy
ibdata1 file and see if your data shows up.
http://127.0.0.1/phpmyadmin/ in a browser and check for errors
SET PASSWORD FOR 'root'@localhost = PASSWORD(""); CREATE USER 'pma'@'localhost' IDENTIFIED BY '';