Note that if your basedir and data-dir are different, you can change it in the commands.
Replace mariadb zip file#
In this new empty folder, extract the content of the ZIP file downloaded in the first step, the directory content will look like this:Īs final step, launch a new command prompt window and switch to the bin directory of MySQL using the following command: cd c:\xampp\mysql\binĪnd finally initialize an insecure instance (password unprotected) of MySQL with the following command just as required in XAMPP for local development: mysqld.exe -default-authentication-plugin=mysql_native_password -initialize-insecure -basedir=c:\xampp\mysql -datadir=c:\xampp\mysql\data Then create a new empty folder namely c:/xampp/mysql. In this new empty folder, extract the content of the ZIP file downloaded in the first step, the directory content will look like this: 3. Rename the c:/xampp/mysql folder to c:/xampp/mariadb. Rename the c:/xampp/mysql folder to c:/xampp/mariadb. Extract MySQL 8.x binary in the new directory. Extract MySQL 8.x binary in the new directory The ZIP file will contain all that you need to implement the new version of MySQL in xampp.
In my case, till the date the latest available version for 64 bits (as I'm using XAMPP 8.0.10) is MySQL 8.0.26. You can obtain the distribution from the official MySQL website here: The first thing you have to do is to download the binary of MySQL 8.x. Download MySQL Community Server 8.x binaries Create a backup of your current databases in case that there's any in your current MariaDB installation in XAMPP.Stop the MariaDB service if it's running.Requirementsīefore following these tutorials, be sure to:
Replace mariadb how to#
By default, the latest versions of XAMPP include MariaDB instead of MySQL, so in case that you really need the latest version of MySQL up and running in your local development stack, I will show you how to easily do it in this article. I use Windows daily and therefore, I use XAMPP as a really quick solution for web development. Recently I started working with new data types that are only available in the newest versions of MySQL.
0 kommentar(er)
